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

1
Which of the following Excel features is best for illustrating changing profit ranges as the selling price is adjusted?
A)One-variable data table
B)Two-variable data table
C)Three-variable data table
D)PivotTable and associated chart
2
Which of the following Excel features can display results for several formulas at the same time?
A)One-variable data table
B)Two-variable data table
C)Pointer table
D)Refresh table
3
How is an array formula identified in the formula bar in an Excel worksheet?
A)Chevron braces <>
B)Curly braces {}
C)Parentheses ()
D)Square brackets []
4
Which of the following objects may appear in an Excel PivotTable even though it is not a field in the data source list?
A)Calculated field
B)Custom calculation
C)Array field
D)Sliced field
5
Which of these Excel functions would not likely be used in a PivotTable?
A)MAX
B)MIN
C)PMT
D)SUM
6
Which of the following statements about an Excel data table is false?
A)A data table is a range of cells that displays the results of changing values in a formula.
B)There are two types of data tables that can be created in Excel.
C)A two-variable data table can calculate a formula for each input value.
D)The Data Table command substitutes input values into the formula.
7
Which of the following command tabs is unique to an Excel PivotChart?
A)PivotChart Tools Design tab
B)PivotChart Tools Layout tab
C)PivotChart Tools Format tab
D)PivotChart Tools Analyze tab
8
When a field in an Excel PivotTable is set to use a compact form, which of the following describes the location of the labels for the next field in the PivotTable?
A)They are below the field.
B)They are in the next column.
C)They are in the same column.
D)They are above the field.
9
Which of the following statements applies to an Excel PivotTable?
A)It can be used to slice-and-dice the data.
B)It allows array formulas to be interactively repositioned.
C)Its field can be rotated in and out of several workbooks.
D)It relocates its file location each time it is pivoted.
10
Which of the following Excel elements forms the basis for a PivotTable?
A)A data source list or table
B)All formula cells in a worksheet
C)All value cells in a worksheet
D)A source workbook







Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Excel > Lesson 15 Quiz