CIS105 EXAM ACTUAL TEST PAPER WITH FULL SOLVED QUESTIONS AND CORRECT ANSWERS GRADED A PLUS

CIS105 EXAM ACTUAL TEST PAPER WITH
FULL SOLVED QUESTIONS AND CORRECT
ANSWERS GRADED A PLUS


◉ 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?


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