18
QuizMultiple Choice

Unit Test — Unit test

Question 18 • Computer Applications I-Sem A -CA- 39901A

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