Exam (elaborations)
MIS112 Study questions Solved 100% Correct
- Course
- Institution
MIS112 Study questions Solved 100% Correct
[Show more]
Content preview
MIS112 Study questions Solved 100% CorrectWhich of the following methods is a VALID way to get into cell edit mode? - Answer
Selecting the cell that you want to edit, and then clicking in the Formula bar
In Row 2 (Col B), which of the following formatting types has been applied to
"3419.25041" to make it appear as "$3,419.25" ? - Answer Currency
Which keyboard shortcuts can be used to move the active cell one column to the left? -
Answer Left arrow or Shift + Tab
You select a cell with data "120" in an Excel worksheet and press the "Delete" key on
your keyboard. Which of the following holds TRUE? - Answer only the contents of the
cell are removed (not formatting)
What happens if you try to store a number greater than 15 digits in Excel ? - Answer
Replace the digits exceeding 15 with the number zero
What is metadata? - Answer Descriptive information about a workbook
Which of the following is the file format of the Excel 97-2003 workbook? - Answer .xls
What is the name of the company that created Excel? - Answer Microsoft
In the attached Excel workbook PS1_Comments_Calculation.xlsx , which of the following
formulas can be used to calculate Sophie's total score in both the exams? - Answer
=B4+C4
,To calculate the percentage of the total widget sales made by the top 5 employees,
which of the following formulae would you enter in cell "C22" (shaded purple) - Answer
=C20/F8
In the Top Salespersons list, which feature can be used to populate the numbers "3,"
"4," and "5" in cells "A17," "A18," and "A19," respectively? - Answer autofill
Does deleting a cell by pressing the Delete key also delete the conditional formatting on
the cell? - Answer no
When a range of cells is selected, which of the following occurs? - Answer all selected
cells are bounded by a selection box, and all but the active cell in the range are
highlighted/shaded
Which type of chart does not allow format changes to the Plot area?
-Treemap
-None of the (other) options provided is correct
-Thermometer chart
-Bar chart - Answer None of the (other) options provided is correct
how do you access cell formatting options? - Answer Ctrl+1
After you have selected the data to create a chart, which of the following is the correct
sequence of options needed to create a clustered column chart? - Answer Insert -->
Charts --> Column --> Clustered Column
A chart in an Excel worksheet provides a visual representation of which of the following?
- Answer numeric values
, Examine the attached workbook. If you want to remove chart labels, where do you find
the options to do so within the Design tab (Chart Tools)? - Answer Add Chart Element >
Data Labels
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
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 Examsplug. 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)
79271 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now