# Excel \$ sign exercises

## Excel \$ sign 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