ITE 140 EXAM 2 QUESTIONS WITH 100% ACCURATE
SOLUTIONS
1) ________ prevents anyone from changing a workbook. -- Answer ✔✔ Protection
2) A PivotChart displays ________ that you can click to choose a filter and change the
data displayed in the chart. -- Answer ✔✔ field buttons
3) A PivotTable report ________ large amounts of data so you can analyze related
totals. -- Answer ✔✔ combines and compares
4) A ________ can import data from an Excel workbook, from a Microsoft Access
database, or from an external source such as a corporate database, a public data
feed, or an analysis service. -- Answer ✔✔ DataModel
5) A chart that illustrates the relationship of each part to a whole is called a ________.
-- Answer ✔✔ pie chart
6) A field that is being removed from the PivotTable report is indicated by a(n) attached
to the pointer as you drag ________. -- Answer ✔✔ X
,7) A method of incorporating data from multiple, related tables into an Excel
worksheet is called a ________. -- Answer ✔✔ Data Model
8) A slicer includes a ________ that indicates the category of the slicer items. --
Answer ✔✔ slicer header
9) An area to position fields that contain data that is summarized in a PivotTable or
PivotChart is called the ________. -- Answer ✔✔ Values area
10) An area to position fields that you want to display as columns in the PivotTable is
called ________. -- Answer ✔✔ Columns areas
11) An area to position fields that you want to display as rows in the PivotTable reports
is called the ________. -- Answer ✔✔ Rows area
12) By default, when a non-numeric field is added to a PivotTable, it is placed in the
________ area. -- Answer ✔✔ rows area
13) By using a PivotTable, you can show the same data in a table in ________. --
Answer ✔✔ more than one arrangement
14) Excel uses the column titles as the ________ for the categories of data. -- Answer
✔✔ field names
, 15) If you change the underlying data on which a PivotTable report is based, you must
also ________ or update the PivotTable to reflect the new data. -- Answer ✔✔
refresh
16) In Microsoft Access, each column is called a ________. -- Answer ✔✔ field
17) In Microsoft Access, each row is called a ________. -- Answer ✔✔ record
18) In Microsoft Access, the field used to uniquely identify a record is called a
________. -- Answer ✔✔ primary key
19) In a PivotTable, a single piece of information for every record is called a ________. -
- Answer ✔✔ field
20) In the PivotTable field section, you can rearrange existing fields by using which of the
following areas in the layout section? -- Answer ✔✔ row headers
21) The ________ is a window that lists all the fields from the source data for us in a
PivotTable and provides an areas in which you can arrange the fields in the
PivotTable. -- Answer ✔✔ PivotTable Fields pane
22) The ________ is an area where you can position fields to use for filtering the
PivotTable and thereby enabling you to display a subset of the data in the PivotTable
report. -- Answer ✔✔ Filters area
SOLUTIONS
1) ________ prevents anyone from changing a workbook. -- Answer ✔✔ Protection
2) A PivotChart displays ________ that you can click to choose a filter and change the
data displayed in the chart. -- Answer ✔✔ field buttons
3) A PivotTable report ________ large amounts of data so you can analyze related
totals. -- Answer ✔✔ combines and compares
4) A ________ can import data from an Excel workbook, from a Microsoft Access
database, or from an external source such as a corporate database, a public data
feed, or an analysis service. -- Answer ✔✔ DataModel
5) A chart that illustrates the relationship of each part to a whole is called a ________.
-- Answer ✔✔ pie chart
6) A field that is being removed from the PivotTable report is indicated by a(n) attached
to the pointer as you drag ________. -- Answer ✔✔ X
,7) A method of incorporating data from multiple, related tables into an Excel
worksheet is called a ________. -- Answer ✔✔ Data Model
8) A slicer includes a ________ that indicates the category of the slicer items. --
Answer ✔✔ slicer header
9) An area to position fields that contain data that is summarized in a PivotTable or
PivotChart is called the ________. -- Answer ✔✔ Values area
10) An area to position fields that you want to display as columns in the PivotTable is
called ________. -- Answer ✔✔ Columns areas
11) An area to position fields that you want to display as rows in the PivotTable reports
is called the ________. -- Answer ✔✔ Rows area
12) By default, when a non-numeric field is added to a PivotTable, it is placed in the
________ area. -- Answer ✔✔ rows area
13) By using a PivotTable, you can show the same data in a table in ________. --
Answer ✔✔ more than one arrangement
14) Excel uses the column titles as the ________ for the categories of data. -- Answer
✔✔ field names
, 15) If you change the underlying data on which a PivotTable report is based, you must
also ________ or update the PivotTable to reflect the new data. -- Answer ✔✔
refresh
16) In Microsoft Access, each column is called a ________. -- Answer ✔✔ field
17) In Microsoft Access, each row is called a ________. -- Answer ✔✔ record
18) In Microsoft Access, the field used to uniquely identify a record is called a
________. -- Answer ✔✔ primary key
19) In a PivotTable, a single piece of information for every record is called a ________. -
- Answer ✔✔ field
20) In the PivotTable field section, you can rearrange existing fields by using which of the
following areas in the layout section? -- Answer ✔✔ row headers
21) The ________ is a window that lists all the fields from the source data for us in a
PivotTable and provides an areas in which you can arrange the fields in the
PivotTable. -- Answer ✔✔ PivotTable Fields pane
22) The ________ is an area where you can position fields to use for filtering the
PivotTable and thereby enabling you to display a subset of the data in the PivotTable
report. -- Answer ✔✔ Filters area
