Case-Based Critical Thinking Questions
Case 5-1
You are tutoring a fellow student who is new to the more advanced features of Excel..
-Which of the following is NOT a feature that is unique to Excel tables (as opposed to structured ranges of data)?
A) You can format quickly using a table style.
B) You can enter a formula in one table cell that is automatically copied to all other cells in that table column.
C) You can add new rows and columns that automatically expand the range.
D) You can freeze the top row of the worksheet.

Question

Quizplus · Accepted Answer

Freezing the top row of the worksheet is a feature that is not unique to Excel tables. This feature can be accessed from the View tab in the Ribbon and applies to the entire worksheet, not just tables. Options A, B, and C are all features unique to Excel tables.