Question

Consider the following worksheet:

(a) In a spreadsheet, every formula starts with a/an ................. sign.
(b) Write the formula to calculate the amount for Glue stick. (Amount is calculated as Price $\times$ Quantity)
 

Hint:

Use cell references in formulas to make your spreadsheet dynamic and accurate. Always check the correct row and column before writing a formula.

Answer 1

Spreadsheets like Microsoft Excel, Google Sheets, or LibreOffice Calc are used for performing calculations, organizing data, and analyzing information.
(a) In any spreadsheet, a formula always begins with an equals sign (=).
This tells the program that the cell will calculate a value instead of displaying plain text or numbers.
Without the equals sign, the spreadsheet will not treat the entry as a formula and no calculation will happen.
For example, typing =A1+B1 adds the values in cells A1 and B1.
(b) In the given worksheet, the Glue stick is listed in row 3.
The Quantity for the Glue stick is found in cell C3, which is 11.
The Price for the Glue stick is found in cell D3, which is 45.
To find the total Amount, multiply Quantity by Price using a formula.
Therefore, the correct formula is =C3*D3.
When you enter this formula in cell E3, it multiplies 11 by 45 and gives you the total amount for the Glue stick.
This method can be used for all rows to calculate amounts automatically and saves time compared to manual calculation.
Using cell references instead of actual numbers makes the spreadsheet dynamic.
If the Quantity or Price changes, the Amount updates automatically.