4. Topic 4(COLON) Spreadsheets and Basic Data Handling

Lesson 4.2: Formulae And Cell Referencing — Quiz

Test your understanding of lesson 4.2: formulae and cell referencing with 5 practice questions.

Practice Questions

Question 1

What is the result of the formula $=3+2*4$ in a spreadsheet?

Question 2

In a spreadsheet, what does the absolute reference $A$1 mean?

Question 3

What is the result of the formula $=B1+C1$ if $B1=5$ and $C1=3$?

Question 4

If you copy a formula containing a relative reference $D2$ from cell $A1$ to cell $A2$, what will the new reference in $A2$ be?

Question 5

What would be the outcome of the formula $=SUM(A1:A4)$ if A1, A2, A3, and A4 contain the values $2$, $3$, $6$, and $4$ respectively?