MIS 111 Lab Final Exam Questions and Answers All Correct
8 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 ...
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
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 Scholarsstudyguide. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
