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 112 Midterm Exam Questions with Correct Answers $12.99
Add to cart
Quickly navigate to
Preview
  2.  
  3. MIS 112
  4.  
  5. MIS 112

Exam (elaborations)

MIS 112 Midterm Exam Questions with Correct Answers

 0 purchase
  • Course
  • MIS 112
  • Institution
  • MIS 112

MIS 112 Midterm Exam Questions with Correct Answers What 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 Which of the following types of data may NOT be contained in a cell in an Excel worksheet - Answer-objects...

[Show more]

Preview 2 out of 5  pages

Document information

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

Subjects

Written for

  • MIS 112
  • MIS 112

Seller

avatar-seller
Scholarsstudyguide

Reviews received

Content preview

MIS 112 Midterm Exam Questions
with Correct Answers
What 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

Which of the following types of data may NOT be contained in a cell in an Excel
worksheet - Answer-objects

In Excel, the Ctrl + Spacebar (keyboard shortcut) is used to ______ - Answer-select a
column

Examine the attached file. if you copy the whole cell "B8" (not only its formula) and
paste it into cell "D8" (shaded in green), will it produce the correct total sales value for
quarter 3? #5 - Answer-yes

Examine the attached file. 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) #6 - Answer-=C20/F8

Examine the attached file. What is the total widget sales for the west region for the year
#7 - Answer-$5,129

Which of the following command sequences will allow you to save a copy of your
workbook with a different name - Answer-file, save as

What procedure will NOT close your Excel workbook - Answer-Ctrl + S

What option scrolls the screen so that the active cell is visible - Answer-Ctrl+Backspace

A single element in a worksheet that can hold a value, some text, or a formula is
referred to as what - Answer-cell

does deleting a cell by pressing the delete key also delete the conditional formatting on
a cell - Answer-no

Abar chart is essentially what chart type rotated 90 degrees clockwise - Answer-column

after you have selected the data to create a chart, what is the correct sequence of
options needed to create a clustered column chart - Answer-insert --> charts --> column
--> clustered column

, must a chart be embedded in the same worksheet as its data source - Answer-no, a
chart can be embedded or placed in a sheet separate from that of its data source

examine the survey results in the attached workbook (in Sheet2). what type of chart
would be most suitable to represent the survey response data #8 - Answer-pie

examine the attached workbook. how can you resize the chart title in chart 1 of sheet 1.
#19 - Answer-change font size

which of the following options is NOT available after right clicking on an Excel
worksheet tab - Answer-changing the font color in the worksheet


which of the following is the keyboard shortcut that creates a new blank workbook in
excel - Answer-Ctrl + N

please refer to the figure. in an excel worksheet, what column name comes directly after
column Z? #1 - Answer-AA

please refer to the figure. which of the following Excel tabs is NOT visible in a worksheet
by default? #2 - Answer-developer

please refer to the figure. what excel element is shown in the red box? #3 - Answer-
quick access toolbar

which of the following shortcuts allows you to enter the same data into multiple selected
cells? Example: In a new Excel worksheet select cells A1:B4 and type "MIS111." The
text is initially entered into cell A1. What could you do to replicate the same text
"MIS111" in all the selected cells? - Answer-Ctrl+Enter

what characters are NOT allowed in sheet names - Answer-[]

after pressing "Alt + H" while in an open Excel worksheet, a number of key tips are
displayed. which ribbon tab do these key tips relate to - Answer-home

while comparing two sheets using the "view side by side" feature, there is an option
which lets you scroll the two sheets in sync. what is that option called? - Answer-
synchronous scrolling

please refer to the figure. within the "number" tab, how many categories are available
for displaying numbers? #4 - Answer-12

True of False: A workbook can have many worksheets - Answer-True

what option moves the active cell right one screen - Answer-Alt+PgDn

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

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 documents were sold in the last 30 days

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

Start selling
$12.99
  • (0)
Add to cart
Added