CIS105 Exam Verified Exam Questions and Answers Latest update 2026/2027

CIS105 Exam
Verified Exam Questions and Answers Latest update 2026/2027

Question:
Solutions
Software developer Pito Salas is considered the inventor of .
A. PivotTables

B. Data Model

C. PivotChart

D. Properties -
Answer:
A. PivotTables
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?

Question:
A. Which rows and columns of the data will you want included and how is best to group the
data?
Answer:
D. Should the PivotTable be placed

Question:
B. Which numeric fields contain the values you want to use?C. Which summarizing function
would be best applied - sum, average or count?
Answer:
on a different computer or within the same computer where the source data is located?

Question:
D. Should the PivotTable be placed on a different computer or within the same computer where
the source data is located? -
Answer:
A integrates data from multiple tables building a relational data source inside an
Excel workbook.

, Question:
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.

Question:
A. PowerPivot

B. PivotPower

C. PivotTable

D. PivotChart -
Answer:
A. PowerPivot
A shows the PivotTable values graphically.

Question:
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.