MIS 111 Lab Final Exam Questions and Answers All Correct
7 vues 0 fois vendu
Cours
MIS 111
Établissement
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
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur Scholarsstudyguide. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €12,19. Vous n'êtes lié à rien après votre achat.
