Page 33 - ThinkGPT_V2.1_C6_Flipbook
P. 33
Let us use the mathematical functions in Excel. To use the mathematical functions, follow the given steps:
2 To calculate the
price of Pencils, type
1 Type the
the =PRODUCT(B3:C3)
following data
function and press the
in the Excel
Enter key.
worksheet.
When you press the Enter key, the price of the pencils appears in the cell D3. Using the AutoFill
feature, we can calculate the prices of the Geometry Boxes and Pens.
3 To calculate the subtotal, type the =SUM(D3:D5)
function and press the Enter key.
4 Calculate the Tax
by using the =D6*C7
formula.
5 Calculate the Total by using the =SUM(D6:D7) function.
Formulas and Functions in Excel 31

