What I found about that Dell Optiplex 790 is that it got max limit of 35W on PCI-e. Normal specification for PCI-e slot is maximum of 75W.
When you plug in GPU it can draw power from PCI-e or/and from extra cables comming directly from your PSU.
Some GPU do not need these extra cable as they can draw enough power from PCI-e slot alone.
Now about that Gigabyte GPU. It got 2x 6-pin slot, each should deliver up to 75W so combined 150W.
+ possible 35W from pci-e mean total 185W max. With normal PCI-e specification it would be 225W.
According to this
review power consumption under load for that card should be something between 125-130W so that GPU should get enough power from those 2 6-pin cables alone.
To matter of PSU, if you want that GPU you need better PSU, 235W supplied in it won't certainly be enough.
That 500W should be ok, make sure it's supplied with atleast 2 slots/cables for PCI-e power connector.