Excel $ sign exercises

Excel $ sign exercises

In your download, complete the following exercises.

Watch the video clip with instructions for the exercises and read below



$ Signs Exercise 1

In the yellow cells, create a formula that determines the total revenue by multiplying the units sold in a month with the selling price i.e. in E11 the formula would be =E9*C6. Use $ signs so that you can copy it across

$ Signs Exercise 2

In the yellow cells, create a formula that determines the total revenue by multiplying the units sold in a month for a branch with the selling price i.e. in E11 the formula would be =E11*E8. Use $ signs so that you can copy it across and down

$ Signs Exercise 3

In the yellow cells, create a formula to determine the cost of sales amount by multiplying the correct sales amount with the correct cost of sales % (cell C14 would be -C11*B7). Put in the correct $ signs so that you can copy the formula across and down to get the right answer.

 

Solutions to the Exercises

Watch the video clip for solutions to the exercises

 

Back to: Excel Fundamentals-2 hrs > Absolute and Relative Referencing