Recall & Review
beginner
What is a calculated field in a spreadsheet?
A calculated field is a cell or column where the value is automatically computed using a formula based on other cells' data.
Click to reveal answer
beginner
How do you create a calculated field in Google Sheets?
You type a formula starting with an equal sign (=) in a cell, using references to other cells to perform calculations.
Click to reveal answer
beginner
Example: If A1 has 10 and B1 has 5, what formula creates a calculated field that adds them?
The formula is
=A1 + B1. It adds the values in A1 and B1 and shows the result.Click to reveal answer
beginner
Why use calculated fields instead of typing numbers manually?
Calculated fields update automatically when source data changes, saving time and reducing errors.
Click to reveal answer
intermediate
What happens if you delete a cell that a calculated field depends on?
The calculated field will show an error like
#REF! because it lost the reference to the needed data.Click to reveal answer
What symbol do you start a formula with in Google Sheets to create a calculated field?
✗ Incorrect
Formulas always start with an equal sign (=) to tell the sheet to calculate.
If cell A2 has 8 and B2 has 3, which formula calculates their product?
✗ Incorrect
The asterisk (*) multiplies the values in A2 and B2.
What will happen if you change the value in a cell that a calculated field uses?
✗ Incorrect
Calculated fields recalculate automatically when source data changes.
Which of these is NOT a valid calculated field formula?
✗ Incorrect
Formulas need operators like +, -, *, or functions; just writing 'A1 B1' is invalid.
What does the formula
=A1-B1 do?✗ Incorrect
The minus sign (-) subtracts the value in B1 from A1.
Explain what a calculated field is and why it is useful in spreadsheets.
Think about how spreadsheets do math for you.
You got /4 concepts.
Describe how to create a simple calculated field that adds two numbers in Google Sheets.
Remember the equal sign and plus sign.
You got /4 concepts.