MIS 112 Exam Questions With Correct
Answers.
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) X...
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
When importing a text file into Excel, the ______ helps specify how the data will be imported.
a) Text Import Wizard
b) External Data Wizard
c) CSV Wizard
d) Text Preview Panel - answer✔✔CSV Wizard
The HYPERLINK function syntax has two arguments. Which argument has the jump text or
numeric value that is displayed in the cell?
What formula displays the value of B5 stored in a file named "example.xslx" in a different
directory called "TEST" in the "C:/" drive?
a) =HYPERLINK("C:\TEST\example.xslx"B5)
B) =HYPERLINK("C:\TEST\example",BC)
=HYPERLINK("C:\TEST\example.xslx",B5) -
answer✔✔=HYPERLINK("C:\TEST\example.xslx",B5)
When working with data returned from a Query Wizard, refreshing a query occasionally
produces undesired results. If this occurs, you can use the . ________ button to reverse the
change. In other words to "un-refresh" the data.
a) Unrefresh
b) Cycle
c) Undo
d) Cancel - answer✔✔Undo
In Step 2 of the Query Wizard, you specify which data rows should be included in your query
output. How is the criteria entered?
a) a criterion for each column
b) you drag and drop the rows you want
c) you use a checkbox to pick criteria
d) criteria are automatically copied from cell $A$! of your current workbook sheet. -
answer✔✔A criterion for each column
To open an HTMML file stored on a Web server using Excel, what needs to be done?
a) Copy the URL and paste it into the Name Field in Open dialog box.
b) Excel cant open an HTML file stored on a Web server.
c) Type the name of the hTML file in the Name Field in the Open dialog box
d) Choose File --- Open -- Get External Data -- from web - answer✔✔Copy the URL and paste it
into the Name Field in Open dialog box.
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 Thebright. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
