CIS105 Exam Questions with Verified Correct Answers

CIS105 Exam Questions with Verified Correct
Answers
Software developer Pito Salas is considered the inventor of ______ _______.



A. PivotTables

B. Data Model

C. PivotChart

D. Properties

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?

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

A. Data Model

The Excel ______ _______add-in helps to prepare and merge data from multiple

sources.



A. PowerPivot

B. PivotPower

C. PivotTable

D. PivotChart

A. PowerPivot

A _______________ shows the PivotTable values graphically.



A. PivotChart

B. Column

C. Cell

D. Rows

A. PivotChart

Use a __________ summarize large sets of data in a separate table without altering the

actual data.



A. PivotTable