BSAN FINAL CHAPTER 7 UPDATED ACTUAL
QUESTIONS AND CORRECT ANSWERS
Question:
1. An interactive Excel report that summarizes and analyzes
large amounts of data
Answer:
PivotTable
Question:
2. The data for a PivotTable, formatted in columns and rows,
which can be located in an Excel worksheet or an
external source
Answer:
source data
Question:
3. The column titles from source data that form categories
of data for a PivotTable
Answer:
Field Names
Question:
4. A window that lists the fields from the source data and an
area in which you can arrange the fields in the PivotTable.
Answer:
PivotTable Fields Pane
Question:
5. The lower portion of the PivotTable Fields pane where
you build the PivotTable report by rearranging and
repositioning fields.
Answer:
Layout Section
QUESTIONS AND CORRECT ANSWERS
Question:
1. An interactive Excel report that summarizes and analyzes
large amounts of data
Answer:
PivotTable
Question:
2. The data for a PivotTable, formatted in columns and rows,
which can be located in an Excel worksheet or an
external source
Answer:
source data
Question:
3. The column titles from source data that form categories
of data for a PivotTable
Answer:
Field Names
Question:
4. A window that lists the fields from the source data and an
area in which you can arrange the fields in the PivotTable.
Answer:
PivotTable Fields Pane
Question:
5. The lower portion of the PivotTable Fields pane where
you build the PivotTable report by rearranging and
repositioning fields.
Answer:
Layout Section