Question

participation activity 1.3.3 introduction to spreadsheets. refer to the spreadsheet below shown in the earlier animation. spreadsheet image with columns a, b, c, d and rows 1 - 5, with some cells filled 1) how many cells are shown? input box check show answer incorrect hint: the number of cells is equal to the number of rows times the number of columns. 2) how many cells contain data? do not count the label in cell d1. input box check show answer 3) cell b1 contains the word weight. what does cell a2 contain? input box check show answer 4) which cell contains the number 12? input box check show answer

Explanation:

Step1: Count total rows and columns

Rows = 5, Columns = 4

Step2: Calculate total cells

$\text{Total Cells} = 5 \times 4 = 20$

Step3: Count data-containing cells

Count cells with values (exclude D1 label): A1, B1, A2, B2, A3, B3, A4, B4, A5, B5 → total 10

Step4: Identify A2's content

Locate cell A2 in the table

Step5: Locate cell with value 12

Find row/column for value 12

Answer:

1. 20
2. 10
3. 8
4. A5