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, such as Microsoft Excel, Google Sheets, and LibreOffice Calc, are utilized for calculations, data organization, and information analysis.
(a) All formulas in a spreadsheet commence with an equals sign (=).
This indicator signals the program to compute a value for the cell, rather than display plain text or numbers.
Absence of the equals sign means the entry will not be processed as a formula, and no calculation will occur.
For instance, typing =A1+B1 sums the values present in cells A1 and B1.
(b) Within the provided worksheet, the Glue stick is located in row 3.
The Quantity for the Glue stick is situated in cell C3, with a value of 11.
The Price for the Glue stick is found in cell D3, valued at 45.
To determine the total Amount, multiply the Quantity by the Price using a formula.
Consequently, the correct formula is =C3*D3.
When this formula is entered into cell E3, it multiplies 11 by 45, yielding the total amount for the Glue stick.
This methodology is applicable across all rows for automated amount calculation, offering a time-saving alternative to manual computation.
Employing cell references instead of absolute numbers renders the spreadsheet dynamic.
Should the Quantity or Price be altered, the Amount will update automatically.