MIS 112 Test Questions with All
Correct Answers
If a pivot chart is created and the underlying table is deleted, what occurs?
a) the pivot chart is also deleted.
b) the pivot chart remains
c) the data the chart is based on is invalid since the pivot table has vanished.
d) the chart is not deleted, but it no longer contains the data from the underlying table. -
Answer-the pivot chart remains
A pivot table and a pivot chart are joined in a two-way link, if you make a structural or
filtering changes to one, the other ________
a) also changes
b) remains unchanged
c) shows a sparkline graphic to highlight the change.
d) can be eliminated to avoid duplicates - Answer-
Please refer to the attached workbook. What happens if the following value filter is
added to the existing report? Value filter: Sum of Sales is less than 5000.
a) Only record one corresponding to the 'CA' state remains.
b) Only one record corresponding to 'AZ' remains.
c) both records remain.
d) No records remain as they don't satisfy the condition specified. - Answer-
Please refer to the attached workbook. How many Savings type accounts were opened
in Central and West side branches (combined)?
a) 99
b) 35
c) 61
d) 134 - Answer-
In the attached image, how would you modify the pivot table to include only Joseph and
Lawrence from the Middle region and nothing else?
(PINK and RED chart/ middle/ middle total/ north total/ west)
a) select the required cells and right-click, point to filter, and click Keep Only Selected
items.
, b) select the required cells and then right-click, point to Filter, and click conditional
formatting.
c) set "Date Filter" accordingly
d) Refresh the pivot table data source - Answer-
If you click outside of the layout area (of a PivotTable report), the PivotTable Field List
a) Increases the size
b) goes away
c) decreases in size
d) turns blue - Answer-goes away
Where do you find the command to add a pivot table on your worksheet?
a) Excel Ribbon: Insert (tab) ------- Charts
b) Excel Ribbon: Insert (tab) ------- Tables
c) Excel Ribbon: Insert (tab) ------- Illustrations
d) Excel Ribbon: Insert (tab) ------- Links - Answer-
What function helps ensure that the formula will continue to reference the intended cells
if the pivot table layout is changed?
a) GETPIVOTDATA
b) PUTPIVOTDATA
c) EXTENDPIVOTDATA
d) REFPIVOTDATA - Answer-GETPIVOTDATA
A calculated item must reside in the ________ labels, ______ labels or ___________
area of a pivot table.
a) column, row, values
b) column, row, default
c) column, row, filter
d) None of the answers provided is correct - Answer-column, row, filter
You ask your customers to provide you with inventory usage data to help you plan your
production schedule. which of the following file formats will you ask them to provide in
(so that data can be easily immported into Excel?)
a) Microsoft Word
b) XML
c) microsoft power point
d) PDF - Answer-XML
Correct Answers
If a pivot chart is created and the underlying table is deleted, what occurs?
a) the pivot chart is also deleted.
b) the pivot chart remains
c) the data the chart is based on is invalid since the pivot table has vanished.
d) the chart is not deleted, but it no longer contains the data from the underlying table. -
Answer-the pivot chart remains
A pivot table and a pivot chart are joined in a two-way link, if you make a structural or
filtering changes to one, the other ________
a) also changes
b) remains unchanged
c) shows a sparkline graphic to highlight the change.
d) can be eliminated to avoid duplicates - Answer-
Please refer to the attached workbook. What happens if the following value filter is
added to the existing report? Value filter: Sum of Sales is less than 5000.
a) Only record one corresponding to the 'CA' state remains.
b) Only one record corresponding to 'AZ' remains.
c) both records remain.
d) No records remain as they don't satisfy the condition specified. - Answer-
Please refer to the attached workbook. How many Savings type accounts were opened
in Central and West side branches (combined)?
a) 99
b) 35
c) 61
d) 134 - Answer-
In the attached image, how would you modify the pivot table to include only Joseph and
Lawrence from the Middle region and nothing else?
(PINK and RED chart/ middle/ middle total/ north total/ west)
a) select the required cells and right-click, point to filter, and click Keep Only Selected
items.
, b) select the required cells and then right-click, point to Filter, and click conditional
formatting.
c) set "Date Filter" accordingly
d) Refresh the pivot table data source - Answer-
If you click outside of the layout area (of a PivotTable report), the PivotTable Field List
a) Increases the size
b) goes away
c) decreases in size
d) turns blue - Answer-goes away
Where do you find the command to add a pivot table on your worksheet?
a) Excel Ribbon: Insert (tab) ------- Charts
b) Excel Ribbon: Insert (tab) ------- Tables
c) Excel Ribbon: Insert (tab) ------- Illustrations
d) Excel Ribbon: Insert (tab) ------- Links - Answer-
What function helps ensure that the formula will continue to reference the intended cells
if the pivot table layout is changed?
a) GETPIVOTDATA
b) PUTPIVOTDATA
c) EXTENDPIVOTDATA
d) REFPIVOTDATA - Answer-GETPIVOTDATA
A calculated item must reside in the ________ labels, ______ labels or ___________
area of a pivot table.
a) column, row, values
b) column, row, default
c) column, row, filter
d) None of the answers provided is correct - Answer-column, row, filter
You ask your customers to provide you with inventory usage data to help you plan your
production schedule. which of the following file formats will you ask them to provide in
(so that data can be easily immported into Excel?)
a) Microsoft Word
b) XML
c) microsoft power point
d) PDF - Answer-XML
