Question

in cell h5, enter a formula that will calculate the percentage of attendees that went to the Altamonte springs job fair in 2018. Use relative cell references and copy formula to the range h6:h11.

Answer 1

formula is:

(No. of attendees that went to the Altamonte springs job fair / Total attendees) *100

Explanation with example:

If

No. of attendees that went to the Altamonta spring job fair value in cell=f2

Total attendees value in cell=g3

Then we write formula in Cell h5:

=(f2/g3)*100

and then press enter the ans. will show in cell h5

Now in 2nd part:

Locate the fill handle in the bottom-right corner of cell h5

Click and drag the fill handle to filled cells h6 to h11

the formula of h5 will copy in cells h6 to h11 , This is called relative cell references.