Exam (elaborations)
MIS 112 Test Questions with All Correct Answers
- Course
- Institution
MIS 112 Test Questions with All Correct Answers
[Show more]
Content preview
MIS 112 Test Questions with AllCorrect 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Scholarsstudyguide. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
83637 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now