18
QuizMultiple Choice

Managing Workbook Properties — Unit test

Question 18 • GA-Business and Technology

Lisa intends to use the Hide command on a column in her spreadsheet. How are the cells in this column affected by this command?

Answer
A
The data in all of the cells is deleted.
B
The data in only some of the cells is deleted.
C
The cells can no longer be referenced in functions or formulas.
D
The cells can still be referenced in functions or formulas.

Explanation

Hiding a column changes whether it is displayed, not whether its contents exist. The cells remain in the spreadsheet, so formulas and functions can still reference them. Therefore, the correct choice is “The cells can still be referenced in functions or formulas.”

AI-written and checked against the verified answer.

Previous
Next