NEW
Font size
WorksheetsCreating Formulas and Functions
Total questions: 10
Worksheet time: 5mins
Multiply H3 times C4
=H3xC4
H3XC4
H3*C4
=H3*C4
Add C2 and C3
C2+C3
C3+C2
=C2+C3
=SUM(C2+C3)
Subtract D4 from D3
=D4-D3
=D3-D4
=SUBTRACT(D4-D3)
D3-D4
Divide E3 by C1
=C1/E3
=E3/C1
Add the range B2-B10
=B2+B10
=SUM(B2,B10)
=SUM(B2-B10)
=SUM(B2:B10)
Add C6 through C10 then subtract C5
=SUM(C6:C10)-C5
=C6+C7+C8+C9+C10-C5
=SUM(C6-C10)/C5
Add A3 and A4 then divide by C10
=A3+A4/C10
=(A3+A4)/C10
=C10/A3+A4
=C10/(A3+A4)
Find the average of D1 through D10
=AVERAGE(D1:D10)
=AVERAGE(D1-D10)
=AVERAGE(D1,D10)
=AVERAGE(D1;D10)
Find the net income of the income amounts that are located in B2 through B4 and the expenses that are in B7 through B12.
=SUM(B2:B4)+SUM(B7:B12)
=(B2:B4)+(B7:B12)
=B2+B3+B4+B8+B9+B10+B11+B12
=SUM(B2:B12)
Find the sales tax if Total Sale amount is in E12 and tax rate is in B4
=E12*B4
=E12XB4
=E12/B4
=SUM(E12*B4)
