Exam (elaborations)
MIS112 Study questions Solved 100% Correct
- Course
- Institution
MIS112 Study questions Solved 100% Correct
[Show more]
Seller
Follow
Content preview
MIS112 Study questions Solved 100%Correct
To move "Chart 1" in "Sheet1" to a new Excel worksheet named "MyChart",
which options will you use? - Answer Click on: (Chart Tools) Design tab --> Move
chart (Location) --> New Sheet (option)
Which of the following is NOT a state an Excel workbook can be in? - Answer
Which of the following is a VALID method of hiding rows or columns? - Answer Home
(ribbon tab), (then) Format (in the Cells group) --> Hide & Unhide (from the drop
down list)
Which of the following View ribbon tab options was used to display the horizontal bar
between the nonconsecutive rows containing "Astoria, OR" and "Victoria, TX"? -
Answer Split
A single element in a worksheet that can hold a value, some text, or a formula
is referred to as which of the following? - Answer cell
If you copy cell "B6" and paste it as a formula in cell "C6," will it produce the correct
total for Year 2? - Answer Yes, the formula range will be adjusted automatically
Charts are dynamic, e.g., they change as the underlying data changes. Is this an
accurate statement? - Answer Yes, by default they are dynamic.
After you create a chart, which of the following actions can you perform on it? - Answer
change the chart type, formatting, and data series
,A bar chart is essentially which of the following chart types rotated 90 degrees
clockwise? - Answer column
Which of the following is NOT true when it comes to adding new worksheets within
an existing Excel workbook? - Answer Excel does not allow you to add additional
worksheets to a workbook that has been saved previously
Which keyboard shortcut is used to select all cells in an open Excel worksheet? - Answer
ctrl + A
What are the minimum and maximum zoom ranges that can be displayed in an
open Excel worksheet (respectively)? - Answer 10%, 400%
Which of the following function(s) can be used to count error values in a range?
-all of the provided choices are valid
-ISERROR()
-ISERR()
-ISNA() - Answer all of the provided choices are valid
A formula in Excel can consist of which of the following?
-all of the choices provided are valid
-text
-cell references
-mathematical operators - Answer all of the choices provided are valid
What will be the result of this formula =IF(A1<100000,A1*5%,A1*7.5%) , if the cell
A1 has a value of 90000? - Answer 4500
, Consider the function =COUNTIF(A1:A200, ">200"). The information between the
parentheses in a function are known as the ____________ . - Answer arguments
Which of the following statements is true?
-A workbook can have at most 3 worksheets.
-A worksheet can have many workbooks.
-A workbook can have many worksheets.
-A worksheet can have at most 3 workbooks. - Answer A workbook can have
many worksheets.
Which of the following excel tabs is NOT visible in a worksheet by default?
-developer
-review
-home
-insert - Answer developer
how do you use the transpose feature? - Answer Select cells A1 through C4 in Sheet1 ->
Copy -> Go to Sheet2 -> Paste -> Transpose
What characters are NOT allowed in sheet names ? - Answer []
Which of the following is the keyboard shortcut that creates a new blank workbook
in Excel? - Answer Ctrl + N
Quick Access Toolbar - Answer A small customizable toolbar at the top of the
screen with buttons for common commands such as Save and Print.
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 KenAli. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
84146 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now