Here is a spreadsheet which is to be used to calculate the q…

Here is a spreadsheet which is to be used to calculate the quotients for a divisor method apportionment.  A formula needs to be entered into cell C5 so that cell C5 may be copied into cells beneath it (all the way down to cell C8) to produce the correct quotients in those cells. What formula should be placed into C5? Your formula should make appropriate use of relative and absolute cell references.   A B C 1 Divisor 600   2       3 District Population Quotient 4       5 Ward 1 6385   6 Ward 2 3172   7 Ward 3 9642   8 Ward 4 5328