22
QuizMultiple Choice

Managing Workbook Properties — Unit test

Question 22 • GA-Business and Technology

Anna needs to reference a cell on another worksheet in her workbook. What is the correct syntax for this operation?

Answer
A
=SUM(F2:F5,Sheet2A10)
B
=SUM(F2:F5,Sheet2!A10)
C
=SUM(F2:F5,!Sheet2A10)
D
=SUM(F2:F5,_Sheet2A10)

Explanation

To reference a cell on another worksheet, use the sheet name, an exclamation mark, and the cell address: Sheet2!A10. Choice B uses that syntax inside the SUM formula, adding the range F2:F5 and the value in cell A10 on Sheet2.

AI-written and checked against the verified answer.

Previous
Next