CIS105 ACTUAL EXAM PAPER 2026
QUESTIONS WITH SOLUTIONS GRADED A+
●● When you are preparing to make a PivotTable, it is important to take
a look at the data you intend to use and answer a few questions about the
data and the end result. Which of the following is not a question you
would ask?
A. Which rows and columns of the data will you want included and how
is best to group the data?
B. Which numeric fields contain the values you want to use?C. Which
summarizing function would be best applied - sum, average or count?
D. Should the PivotTable be placed on a different computer or within the
same computer where the source data is located?.
Answer: D. Should the PivotTable be placed on a different computer or
within the same computer where the source data is located?
●● A __________ integrates data from multiple tables building a
relational data source inside an Excel workbook.
A. Data Model
B. PivotChart
C. PivotTable
D. PowerPivot.
,Answer: A. Data Model
●● The Excel ______ _______add-in helps to prepare and merge data
from multiple sources.
A. PowerPivot
B. PivotPower
C. PivotTable
D. PivotChart.
Answer: A. PowerPivot
●● A _______________ shows the PivotTable values graphically.
A. PivotChart
B. Column
C. Cell
D. Rows.
Answer: A. PivotChart
●● Use a __________ summarize large sets of data in a separate table
without altering the actual data.
A. PivotTable
, B. Background
C. Properties
D. PowerPivot.
Answer: A. PivotTable
●● When you place _______, data can be isolated depending on your
selection.
A. numbers
B. letters
C. a filter
D. ribbons.
Answer: C. a filter
●● The _____ ______ _______ task pane will present options to define
aspects of the PivotTable report layout.
A. Fields Table Charts
B. PivotChart Fields
C. Data Table Fields
D. PivotTable Fields.
Answer: D. PivotTable Fields
QUESTIONS WITH SOLUTIONS GRADED A+
●● When you are preparing to make a PivotTable, it is important to take
a look at the data you intend to use and answer a few questions about the
data and the end result. Which of the following is not a question you
would ask?
A. Which rows and columns of the data will you want included and how
is best to group the data?
B. Which numeric fields contain the values you want to use?C. Which
summarizing function would be best applied - sum, average or count?
D. Should the PivotTable be placed on a different computer or within the
same computer where the source data is located?.
Answer: D. Should the PivotTable be placed on a different computer or
within the same computer where the source data is located?
●● A __________ integrates data from multiple tables building a
relational data source inside an Excel workbook.
A. Data Model
B. PivotChart
C. PivotTable
D. PowerPivot.
,Answer: A. Data Model
●● The Excel ______ _______add-in helps to prepare and merge data
from multiple sources.
A. PowerPivot
B. PivotPower
C. PivotTable
D. PivotChart.
Answer: A. PowerPivot
●● A _______________ shows the PivotTable values graphically.
A. PivotChart
B. Column
C. Cell
D. Rows.
Answer: A. PivotChart
●● Use a __________ summarize large sets of data in a separate table
without altering the actual data.
A. PivotTable
, B. Background
C. Properties
D. PowerPivot.
Answer: A. PivotTable
●● When you place _______, data can be isolated depending on your
selection.
A. numbers
B. letters
C. a filter
D. ribbons.
Answer: C. a filter
●● The _____ ______ _______ task pane will present options to define
aspects of the PivotTable report layout.
A. Fields Table Charts
B. PivotChart Fields
C. Data Table Fields
D. PivotTable Fields.
Answer: D. PivotTable Fields
