Multiple Choice
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.
Correct Answer:

Verified
Correct Answer:
Verified
Q11: After data is filtered,you can _ it.<br>A)
Q12: You can use the _ tab to
Q13: To show items hidden in a PivotTable,you
Q15: You can format cells in a PivotTable
Q18: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB5278/.jpg" alt=" -In the accompanying
Q19: Jamie wants to be able to analyze
Q20: MATCHING<br>Identify the letter of the choice that
Q52: MATCHING<br>Identify the letter of the choice that
Q57: You can click the More Functions command
Q130: You can find fields whose contents match