Site MapHelpFeedbackLesson 13 Quiz
Lesson 13 Quiz
(See related pages)

1
Which of the following terms describes a subset of data from an Excel list range?
A)PivotTable
B)Filter
C)Output
D)Criteria
2
Which of the following statements defines an Excel cell attribute?
A)A format setting or a property
B)A formula or a built-in function
C)A list range field or record
D)A comparison or relational operator
3
Which of the following statements describes the AGGREGATE function in an Excel worksheet?
A)It groups and summarizes data in an outline format.
B)It inserts a selected summary from grouped records.
C)It formats the records into summary and detail rows.
D)It sums data from cell ranges using a selected calculation.
4
Which of the following criteria examples for an advanced filter uses a valid wildcard character?
A)ch@
B)ch*
C)ch^
D)ch%
5
Which of the following statements describes a filter for an Excel list range?
A)A list range with detail and summary rows
B)A shortened version of a list range
C)A row of header labels
D)A list range with a calculation
6
How many outlines can be created in an Excel worksheet?
A)1
B)3
C)5
D)8
7
Which of the following options from the Subtotal dialog box specifies the field used for grouping in an Excel list range?
A)Add subtotal to
B)At each change in
C)Or select a category
D)Set group
8
Which of the following values is calculated in this formula for an advanced filter =SalesData!C3>AVERAGE(SalesData!$C$3:$C$15)?
A)The value of cell C3
B)The average of cells C3:C15
C)The value greater than cell C3
D)The average greater than cells C3:C15.
9
Which of the following criteria is correct for an advanced filter to find records in an Excel list in which the last name begins with Mc?
A)?mc* in the last name field
B)mc* in the last name field
C)"starts with mc" in the last name field
D)"contains mc" in the last name field
10
Which of the following Excel functions does not belong to the Database category?
A)DAVERAGE
B)DB
C)DCOUNT
D)DSUM





To learn more about the book this website supports, please visit its Information Center.
(c)2011 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Notice.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Excel > Lesson 13 Quiz