CIS105 UPDATED ACTUAL Questions and CORRECT Answers

CIS105 UPDATED ACTUAL Questions
and CORRECT Answers
Software developer Pito Salas is considered the inventor of ______ _______.


A. PivotTables
B. Data Model
C. PivotChart

D. Properties - CORRECT 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? - CORRECT 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 - CORRECT 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 - CORRECT ANSWER - A. PowerPivot


A _______________ shows the PivotTable values graphically.


A. PivotChart
B. Column
C. Cell

D. Rows - CORRECT 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 - CORRECT ANSWER - A. PivotTable


When you place _______, data can be isolated depending on your selection.


A. numbers
B. letters
C. a filter

D. ribbons - CORRECT ANSWER - C. a filter