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..
-Your tutee has a lot of familiarity with ranges from an earlier Excel class,but he knows that there is an alternative that will give him access to additional features that he does 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) The tutee is wrong;the range has any many features as any Excel alternative.
Correct Answer:

Verified
Correct Answer:
Verified
Q2: Each column represents a <span
Q18: When you filter your data all records
Q19: MATCHING<br>Identify the letter of the choice that
Q30: Criteria filters allow you to specify relationships
Q34: Critical Thinking Case-Based Questions<br>Case 5-3<br>As she prepares
Q59: You can calculate <span class="ql-formula"
Q60: When the Subtotals feature "outlines" your worksheet
Q67: MATCHING<br>Identify the letter of the choice that
Q90: When you delete a record from a
Q127: The fields you use to order the