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 Final Exam Questions and Answers All Correct CA$18.02   Add to cart
Quickly navigate to
Preview
  2.  
  3. MIS 111
  4.  
  5. MIS 111

Exam (elaborations)

MIS 111 Lab Final Exam Questions and Answers All Correct

 7 views  0 purchase
  • Course
  • MIS 111
  • Institution
  • MIS 111

MIS 111 Lab Final Exam Questions and Answers All Correct Which of the following is one of the conditional formatting rules? - Answer-All the other options are correct Which rule category does the following conditional formatting rule belong to? "Highlight cells containing a value greater than ...

Preview 2 out of 11  pages

Document information

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

Subjects

  • mis 111
  • mis 111 lab final exam
  • mis 111 lab final exam questions and answers

Written for

  • MIS 111
  • MIS 111

Seller

avatar-seller
Scholarsstudyguide

Reviews received

Content preview

MIS 111 Lab Final Exam Questions
and Answers All Correct
Which of the following is one of the conditional formatting rules? - Answer-All the other
options are correct

Which rule category does the following conditional formatting rule belong to? "Highlight
cells containing a value greater than 25" - Answer-Highlight Cells rules

Please see the attached workbook, Sheet1. What happens when you apply a theme on
Sheet1 of the Excel sheet by going to Page -> Layout -> Themes - Answer-The theme
is applied to all the sheets in the workbook

The HLOOKUP function searches for data in ______. - Answer-rows

Please see the attached workbook. What value of Discount is returned when you use an
VLOOKUP function with a quantity entered (i.e., value looked up) of 1001 and a range-
lookup parameter of FALSE? - Answer-None of the other answers are correct

What of the following is FALSE about filtering a table? - Answer-When you copy data
from a filtered table, both visible data and rows hidden by filtering are copied.

Which of the following types of Cell Formating can be achieved using the Format Cells
feature of Excel? - Answer-All the other options are correct

To add rows or columns within the table, right-click and choose Insert from the shortcut
menu. Which of the following commands is NOT displayed on this menu? - Answer-
Table column above

Which function returns the relative position (in a range / table) of a cell corresponding to
a specified value? - Answer-=MATCH()

What value should be given to the 'match_type' argument in the MATCH function if you
want the MATCH function to find the first value exactly equal to lookup_value? -
Answer-0

Which of the following functions looks in a one-row or one-column range
(lookup_vector) for a value (lookup_value) and returns a value from the same position in
a second one-row or one-column range (result_vector). - Answer-LOOKUP

Which of the following is NOT one of the VLOOKUP function arguments? - Answer-
row_index_num

, Please see the attached workbook. The worksheet contains a table of student data
(starting in row 13) named as "Students". If you were to use a lookup formula to get the
exact value for salary field in row 2, which of the following formulas would you use? -
Answer-=VLOOKUP(C2,Students,4,FALSE)

Which of the following concepts are useful in understanding relationships between cells
and formulas? - Answer-cell dependents

When entering / editing an Array formula, press _________ to enter the formula (or
Excel does not recognize the formula as an Array formula). - Answer-ctrl+shift+enter

Which of the following is NOT one of the buttons in the Spelling dialog box in Excel? -
Answer-conditional formatting

In order to delete information using Find and Replace in Excel, enter the text to be
deleted in the ________ field and leave the Replace With field _____. - Answer-find
what, empty

A #REF! error occurs in Excel when a formula uses a / an ________ cell reference -
Answer-invalid

Which of the following error codes indicates that a formula refers to a cell that is invalid?
This type of error can occur if a referenced cell is deleted from the worksheet. - Answer-
#REF!

Which of the following options, when used as a formula in the Custom Data Validation
criteria for cell range A1:A10, enables the user to enter a value in A1:A10 only if it's
greater than or equal to the value in A1? - Answer-=A1>=$A$1

Data validation on a cell or range can do which of the following? - Answer-All of the
options provided are valid

______ cells are by default disregarded when data validation rules are created. These
cells can be included in the validation rule by unchecking the: "Ignore blank" checkbox. -
Answer-None of the options provided is valid

How do you set up a data validation (using the data validation dialog box) that restricts
data entry to a time less than a specified time? - Answer-Click the Settings tab (in the
Data Validation box). In the Allow box, select 'Time'. In the Data box, select 'less than'
and enter the end time.

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

Which of the following file types can Excel import? - Answer-all of the file types

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