0 of 135 lessons complete (0%)
Function and Formula Basics

Dollar Sign ($A$1) Examples

You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.

Cell ref Ex 1

In cell B16 to B20 create a formula that multiplies the sales amount in column A with the commission percentage in cell B10.

Cell Ref Ex 2

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

Cell Ref Ex 3

In G12 to G17 create a formula that works out how much VAT is due on the sales price in the F column by making use of the amount in cell H8

Cell Ref Ex 4

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

Cell Ref Ex 5

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.

To see the full course contents click here.