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 EXAM QUESTIONS AND ANSWERS 2024 NEW UPDATE $12.39
Add to cart
Quickly navigate to
Preview
  2.  
  3. MIS 112
  4.  
  5. MIS 112

Exam (elaborations)

MIS 112 EXAM QUESTIONS AND ANSWERS 2024 NEW UPDATE

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

MIS 112 EXAM QUESTIONS AND ANSWERS 2024 NEW UPDATE Which of the following is an advantage of using Excel tables? - Answer-Using table and column names in formulas provides greater flexibility as extending a table does not require re-writing of formulas When you apply currency formatting to a T...

[Show more]

Preview 2 out of 13  pages

Document information

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

Subjects

Written for

  • MIS 112
  • MIS 112

Seller

avatar-seller
Scholarsstudyguide

Reviews received

Content preview

MIS 112 EXAM QUESTIONS AND
ANSWERS 2024 NEW UPDATE

Which of the following is an advantage of using Excel tables? - Answer-Using table and
column names in formulas provides greater flexibility as extending a table does not
require re-writing of formulas

When you apply currency formatting to a Table column and then add a new row to the
table, what happens to data entered in the new cell? - Answer-Excel applies currency
formatting to the new value in that column cell.

Examine the 6th argument in the formula below. What kind of argument is it?=SUM(B1,
5, 6, 7, SQRT(4), A1:A5, TRUE) - Answer-a range reference

Examine the attached image. What will the result of the following formula be?
="Section " &mysection - Answer-Section B

The Excel function: ISERR() returns TRUE if the cell contains any error value except
which of the following? - Answer-#N/A

Examine the attached worksheet. We want to display in cells H2 to H8 the names of the
items whose quantity purchased is greater than the Average quantity reported in cell
B10. If the quantity purchased is equal or lower, we want to display 0. Which formula,
entered in H2 and extended to H8, will achieve this?
Formulas_Test_v2.xlsx - Answer-=IF(B2>$B$10, A2,0)

Which operator in Excel combines multiple range references into a single reference
(e.g., if I want to sum up the values in non-contiguous cell-ranges across the
worksheet)? - Answer-"," (comma)

In Excel, what does the MODE function in a range return? - Answer-most frequently
occurring value in a range

Please select the Excel function which allows us to answer the question: "How many
days of stock data do I have?" You may refer to the image in the question. - Answer-
COUNT()

What does the Excel keyboard shortcut Ctrl+Alt+F9 do? - Answer-forces a complete
recalculation of all formulas in all open workbooks.

, What type of cell reference does the formula in E2 use? (refer to the attached image,
the formula is highlighted) - Answer-absolute

rng_range_names.xlsx Please see the attached workbook. What is the scope of the
range name 'months'? - Answer-sheet 1

Which of the following function(s) can be used to count error values in a range? -
Answer-all of the provided choices are valid

The formula in the attached image shows an example of which of the following? -
Answer-a circular reference warning

formulas_cell_references.xlsx Examine the attached Excel file. When the formula in
"D2" is copied to the cells below it, cell "D3" will contain what formula? - Answer-
=(B3*C3)*$B$7

A formula in Excel can consist of which of the following? - Answer-all of the choices
provided are valid

The =SUM() function does which of the following in Excel? - Answer-Allows you to total
up numbers in a specified range of cells

Which of the following does the function =NOW() return? - Answer-current date and
time

What is the purpose of the Text to Columns command? - Answer-It parses strings into
their component parts.

What function removes leading and trailing spaces from a cell? - Answer-TRIM

external_ex1.xlsx Please use the attached workbook as an external data source. The
workbook has a table called 'Employee'. When you import data, after selecting all the
columns from the table using the query wizard (Data(tab) -> Get External Data (group) -
> From Other Sources -> From Microsoft Query), how will you filter the records to
retrieve those that have a value greater than 21 for 'Age' column. - Answer-From the
Column to Filter list, select Age. In the right panel, select 'is greater than' from the first
drop-down list and then select '21.0' from the second drop-down list

The HYPERLINK function syntax has two arguments. Which argument has the path and
file name to the document to be opened? - Answer-Link_location

If you place the link target in cell C1 on the same worksheet, how will you use an
absolute reference to that cell as the link_location in the HYPERLINK formulas? -
Answer-=HYPERLINK($C$1)

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.39. 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.39
  • (0)
Add to cart
Added