QUESTION IMAGE
Question
lisa intends to use the hide command on a column in her spreadsheet. how are the cells in this column affected by this command?
the data in all of the cells is deleted.
the data in only some of the cells is deleted.
the cells can no longer be referenced in functions or formulas.
the cells can still be referenced in functions or formulas.
When a column is hidden in a spreadsheet, the data within its cells is not deleted. Hidden cells can still be referenced in functions or formulas. Deletion of data would require a different command (like 'Delete' or 'Clear Contents'), and hiding does not prevent formula/function referencing.
Snap & solve any problem in the app
Get step-by-step solutions on Sovi AI
Photo-based solutions with guided steps
Explore more problems and detailed explanations
The cells can still be referenced in functions or formulas.