Multiple Choice
Case-Based Critical Thinking Questions Case 5-1 You are a student who is new to the more advanced features of Excel. You have a lot of familiarity with ranges from an earlier Excel class, but you know that there is an alternative that will give you access to additional features that you do not have with a cell range. What is that option?
A) Convert the range to a table.
B) Convert the range to an index.
C) Convert the range to a PivotChart.
D) You are wrong; the range has as many features as any Excel alternative.
Correct Answer:

Verified
Correct Answer:
Verified
Q9: The _ command automatically inserts a subtotal
Q13: Ascending order arranges labels alphabetically from A
Q31: You can split the worksheet window into
Q61: With the Last Quarter criteria filter quarters
Q79: When you click in each cell in
Q83: You can access the Sort buttons in
Q100: If you freeze the top row in
Q106: The first sort field in a sort
Q126: You can use a table's sizing handle
Q134: You select the _ option button in