100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
MIS 111 Lab Exam Questions with All Correct Answers CA$18.16   Add to cart
Quickly navigate to
Preview
  2.  
  3. MIS 111 Lab
  4.  
  5. MIS 111 Lab

Exam (elaborations)

MIS 111 Lab Exam Questions with All Correct Answers

 8 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...

[Show more]

Preview 2 out of 10  pages

Document information

  • August 29, 2024
  • 10
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • mis 111
  • mis 111 lab exam
  • mis 111 lab exam questions with all correct answer

Written for

  • MIS 111 Lab
  • MIS 111 Lab

Seller

avatar-seller
Scholarsstudyguide

Reviews received

Content preview

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

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

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

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 CA$18.16. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

71184 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
CA$18.16
  • (0)
  Add to cart