STUDY GUIDE MICROSOFT EXCEL CHAPTER 8.
QUESTIONS AND ANSWERS PROVIDED 2024
REVISION WORK
1. A report is an interactive chart that allows users to
change the groupings that graphically present data.:
PivotChart
2. Summary functions for Pivot Charts and PivotTables can be
accessed by tapping or clicking on the Summary Functions
submenu.: More Options
3. PivotTable fields contain values that describe data by
categorizing it.: category
4. You can display a PivotTable in one of layouts.: three
5. Pivotable drawn from columns in the worksheet data.:
fields
6. Changes to category fields in a PivotChart report are also
made to of the corresponding PivotTable report.: row fields
7. The summary function for a PivotChart or PivotTable
provides an estimate of the standard deviation of all data to
be summarized, used when data is a sample of a larger
population of interest.: StdDev
8. The summary function for a PivotChart or PivotTable
provides the product of values in the data source.: Product
value is a number that measures the strength of a
trend.:
R-squared
9. The default summary function in a PivotTable is the
function.: SUM
1/6
, STUDY GUIDE MICROSOFT EXCEL CHAPTER 8.
QUESTIONS AND ANSWERS PROVIDED 2024
REVISION WORK
1 1. Tap or click the Filter button on a slicer to remove any
filters and return the PivotTable and Pivot Charts to their
unfiltered states: Clear
12. The summary function for a PivotChart or PivotTable
provides the standard deviation of all the data to be
summarized, used when data is the population of interest.:
StdDev
13. A is a field with values not entered as data, but
determined by computation involving data in other fields.:
calculated field
14. When you update cell contents in Excel, you also update all of
the following
EXCEPT: PivotTables
1 5. are a visual filter used to make PivotTables and Pivot
Charts easier to interpret.: Slicers
16. The Field List, +1- Buttons, and Field Headers buttons are
. Tapping or clicking them again turns the display off and
on.: toggle buttons
17. To add slicers to a worksheet, tap or click the Insert Slicer
button (PIVOTCHART TOOLS ANALYZE tab I group) to
display the Insert Slicers dialog box.: Filter
18. In a PivotTable, fields correspond to columns in the
original data.: category
19. The default chart type for a PivotChart is a chart.:
clustered column
2/6
QUESTIONS AND ANSWERS PROVIDED 2024
REVISION WORK
1. A report is an interactive chart that allows users to
change the groupings that graphically present data.:
PivotChart
2. Summary functions for Pivot Charts and PivotTables can be
accessed by tapping or clicking on the Summary Functions
submenu.: More Options
3. PivotTable fields contain values that describe data by
categorizing it.: category
4. You can display a PivotTable in one of layouts.: three
5. Pivotable drawn from columns in the worksheet data.:
fields
6. Changes to category fields in a PivotChart report are also
made to of the corresponding PivotTable report.: row fields
7. The summary function for a PivotChart or PivotTable
provides an estimate of the standard deviation of all data to
be summarized, used when data is a sample of a larger
population of interest.: StdDev
8. The summary function for a PivotChart or PivotTable
provides the product of values in the data source.: Product
value is a number that measures the strength of a
trend.:
R-squared
9. The default summary function in a PivotTable is the
function.: SUM
1/6
, STUDY GUIDE MICROSOFT EXCEL CHAPTER 8.
QUESTIONS AND ANSWERS PROVIDED 2024
REVISION WORK
1 1. Tap or click the Filter button on a slicer to remove any
filters and return the PivotTable and Pivot Charts to their
unfiltered states: Clear
12. The summary function for a PivotChart or PivotTable
provides the standard deviation of all the data to be
summarized, used when data is the population of interest.:
StdDev
13. A is a field with values not entered as data, but
determined by computation involving data in other fields.:
calculated field
14. When you update cell contents in Excel, you also update all of
the following
EXCEPT: PivotTables
1 5. are a visual filter used to make PivotTables and Pivot
Charts easier to interpret.: Slicers
16. The Field List, +1- Buttons, and Field Headers buttons are
. Tapping or clicking them again turns the display off and
on.: toggle buttons
17. To add slicers to a worksheet, tap or click the Insert Slicer
button (PIVOTCHART TOOLS ANALYZE tab I group) to
display the Insert Slicers dialog box.: Filter
18. In a PivotTable, fields correspond to columns in the
original data.: category
19. The default chart type for a PivotChart is a chart.:
clustered column
2/6
