MIS 111 Lab Exam Questions with All Correct Answers
5 views 0 purchase
Course
MIS 111 Lab
Institution
MIS 111 Lab
MIS 111 Lab Exam Questions with All Correct Answers
There are two options if you want to save an Excel workbook, so that it can be viewed on the World Wide Web. What are the two options? - Answer-An HTML file and a single-file web page
The last step in the Query Wizard, "Finish", lets you do...
MIS 111 Lab Exam Questions with
All Correct Answers
There are two options if you want to save an Excel workbook, so that it can be viewed
on the World Wide Web. What are the two options? - Answer-An HTML file and a
single-file web page
The last step in the Query Wizard, "Finish", lets you do which of the following? -
Answer-Save a query so that you can reuse it
Which of the following can be retrieved from a web page using web queries? - Answer-
data in a table
Which one of the following is NOT a formatting option in the Web Query Options dialog
box? - Answer-XML formatting
The HYPERLINK function syntax has two arguments. Which argument has the jump
text or numeric value that is displayed in the cell? - Answer-Friendly_name
Which function is used to create a shortcut that opens a document stored on a network
server, an intranet, or the Internet? - Answer-HYPERLINK()
A pivote table calculated field consists of a calculation that involves other _______. -
Answer-fields
Which of the following statements is FALSE? - Answer-A pivot chart is always based on
a pivot table, i.e., changes to the pivot chart must be made by changing the underlying
table
Which of the following is one of the ways to create a Pivot Chart? - Answer-Insert (tab) -
> Charts (group) -> PivotChart
Please refer to the attached workbook. The ______ , ________ and ________fields are
in the Column, Rows and Values sections respectively. - Answer-branch, date and
amount
Which of the following is FALSE about Pivot Table Slicers? - Answer-None of the
answers provided is false
The function of value filter in a pivot table is to ___________. - Answer-read the data
and select those rows with cells that match your criteria
, What is one of the DRAWBACKS of using a pivot table? - Answer-A Pivot Table does
not update automatically when information changes in source data
When do you use the following sequence of commands: PivotTable Tools -> Analyze ->
PivotTable -> Options -> Generate GetPivot Data? - Answer-prevent Excel from using
GETPIVOTDATA function
What function helps ensure that the formula will continue to reference the intended cells
if the pivot table layout is changed? - Answer-GETPIVOTDATA
Please refer to the attached workbook. What happens if the following value filter is
added to the existing report? Value filter: Sum of Sales does not equal 5000. - Answer-
Nothing happens. Both the records remain.
What is the primary purpose of "Protected View?" - Answer-Protect you from malware
Which of the following is the keyboard shortcut that creates a new blank workbook in
Excel? - Answer-Ctrl + N
Which keyboard shortcuts can be used to move the active cell one colunn to the left? -
Answer-Left arrow or Shift + Tab
You enter "(500)" into an unformatted cell in an Excel worksheet (without quotation
marks). Which of the following will be generated by your entry? - Answer-a negative
number
Which of the following formulas will display both the current date and time when entered
into a cell in an Excel worksheet? - Answer-= NOW()
Which of the following procedures will NOT close your Excel workbook? - Answer-Ctrl +
S
Which of the following is the file format of the Excel 97-2003 workbook? - Answer-.xls
Which of the following keyboard shortcuts will add the current time to a cell in an Excel
worksheet? - Answer-Ctrl + Shift + :
Which of the following is NOT a state an Excel workbook can be in? - Answer-expanded
A chart in an Excel worksheet provides a visual representation of which of the
following? - Answer-numeric values
Must a chart be embedded in the same worksheet as its data source? - Answer-No, a
chart an be embedded or placed in a sheet separate from that of its data source.
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 $12.59. You're not tied to anything after your purchase.
