Multiple Choice
Case 5-2
Cali has just discovered the power of using text filters to control which records display in his worksheet,and he has begun to use them often to find precisely the records he needs.The following questions are based on a camp directory table that includes First Name,Last Name,Date of Birth,Camp,and Phone Number.
-If Ted decides that he wants to work with nonnumeric data in his PivotTable,what function must he use to produce summaries?
A) Sum
B) Aggregate
C) Total
D) Count
Correct Answer:

Verified
Correct Answer:
Verified
Q14: To freeze a row select the cell
Q26: When you create a table if your
Q32: You select the _ option button in
Q34: To create a table click the _
Q69: Custom filters enable you to specify various
Q87: To calculate subtotal for a table the
Q89: _ order arranges labels in reverse alphabetical
Q97: The entry 20000 is the _ for
Q122: Excel can summarize data in a range
Q125: The fields you use to order your