The _____ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if all the logical conditions are FALSE. |
OR |
If you edit a cell in a calculated column so it is no longer consistent with the other formulas in the column, a _____ appears in the upper-left corner of the cell. |
green triangle |
The _____ function is a logical function that evaluates a condition and then returns one value if the condition is true and another value if the condition is false. |
IF |
You could test two or more conditions and determine whether all conditions are true using the _____ function. |
AND |
You can include up to _____ logical conditions in the AND function |
255 |
The _____ function calculates the difference between two dates and shows the result in months, days, or years. |
DATEDIF |
_____ references make it easier to create formulas that use portions or all of an Excel table because the names of headers are usually simpler to identify than cell addresses. |
Structured |
When you create a calculated column, you can use _____ references to create the formula. |
structured |
You can _____ IF functions to allow for three or more outcomes. |
nest |
When using VLOOKUP, the _____argument is optional. |
range_lookup |
Using the VLOOKUP function, an exact match lookup occurs when the value entered must match one of the values in _____ of the lookup table. |
the first column |
If you see _____ as the result of a VLOOKUP formula, you might have entered a letter for the col_index_num instead of a number. |
#NAME? |
You can use a _____ function to return a value from a table that is based on an approximate match lookup. |
VLOOKUP |
An error value begins with a(n) _____ followed by an error name that indicates the type of error. |
number sign |
The major difference between HLOOKUP and VLOOKUP functions is the way the lookup tables are _____. |
organized |
The _____ error value means that a value is not available to a function or formula. |
#N/A |
You can edit existing conditional formatting rules from the Conditional Formatting _____ dialog box. Click the Edit Rule button and make the appropriate changes. |
Rules Manager |
The _____ function calculates the number of cells in a range that match criteria you specify. |
COUNTIF |
The _____ function adds the values in a range that match criteria you specify. |
SUMIF |
The _____ function calculates the average of values in a range that match criteria you specify. |
AVERAGEIF |
Case 8-1Evaluate the formula =AND(G2="FT",M2>=1) based upon the information provided. What value is returned assuming that G2 contains the value PT and M2 contains the value 2? |
FALSE |
Case 8-1Evaluate the formula =AND(G2="FT",M2>=1) based upon the information provided. What value is returned assuming that G2 contains the value FT and M2 contains the value 2? |
True |
Case 8-2Your boss in the human resources department asks you to write a function that calculates the length of time that employees have been with the firm, using the DATEDIF function. Assume that C2 contains the hire date for a given employee and that cell $AE$2 contains the cut-off date against which to compare the hire date to determine length of service. For one service recognition program, you need to calculate the length of service in complete months. What is the correct formula? |
=DATEDIF(C2, $AE$2, "m") |
Case 8-3You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use. Which of the following is an effective alternative for the use of extensive nested IF functions? |
lookup table |
Case 8-3You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use. If you omit the range_lookup value from a LOOKUP function, which of the following is true? |
It is considered an approximate match. |
Module 8 Quiz
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price