mis exam 3

Lookup _____ allow you to use tables of data to "look up" values and insert them in another worksheet location.

Functions

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

You can use _____ to reference cells within an Excel table.

cell and range addresses

For conditional formatting, a formula must be in the form of a(n) _____ test that results in a true or false value.

logical

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

The major difference between HLOOKUP and VLOOKUP functions is the way the lookup tables are _____.

organized

If you are creating a calculated column or formula within an Excel table, you can use the _____ structured in the formula

unqualified

The _____ error value means that a value is not available to a function or formula.

#N/A

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 include up to _____ logical conditions in the AND function.

255

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")

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

The _____ function calculates the difference between two dates and shows the result in months, days, or years. a. nested IF b. CALIF

DATEDIF

On a lark, for a year-end trivia contest, your boss wants you to calculate the length of service in complete days. What is the correct formula?

DATEDIF(C2, $AE$2, "d")

For a separate service recognition program, you need to calculate the length of service in complete years. What is the correct formula?

DATEDIF(C2,$AE$2,"y")

_____ just above the header row of an Excel table to select the column data but not the header.

Double-Click

What value is returned assuming that G2 contains the value PT and M2 contains the value 2?

FALSE

If you omit the range_lookup value from a LOOKUP function, which of the following is true?

It is considered an approximate match

In the Edit Formatting Rule dialog box, click the _____ button to open the Format Cells dialog box.

Format

With the DATEDIF function, the _____ interval code means months.

M

You can _____ IF functions to allow for three or more outcomes.

Nest

An error value begins with a(n) _____ followed by an error name that indicates the type of error.

Number Sign

When you want to reference an entire column of data in a table, you create a column _____

Qualifier

When using VLOOKUP, the _____argument is optional.

Range_Lookup

The Conditional Formatting button provides access to the _____

Replicate Values Conditional Format

Each time you create a conditional format, you are defining a conditional formatting _____

Rule

You can edit existing conditional formatting _____ from the Conditional Formatting Rules Manager dialog box.

Rules

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 adds the values in a range that match criteria you specify.

SUMIF

When you create a calculated column, you can use _____ references to create the formula.

Structured

_____ 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

To change the background fill color of duplicate values, in the _____ group on the Home tab, click the Conditional Formatting button, and then click Manage Rules.

Styles

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 all of the logical conditions are true, the AND function returns the logical value _____.

True

What value is returned assuming that G2 contains the value FT and M2 contains the value 2?

True

The _____ function searches vertically down the first column of the lookup table.

VLOOKUP

You can use a _____ function to return a value from a table that is based on an approximate match lookup.

VLOOKUP

You implement the VLOOKUP formula at your colleague's suggestion, but you get the #VALUE! error as the result of the formula. Which of the following is likely true?

You might have entered a number for the col_index_num instead of a letter.

The COUNTIF function is sometimes referred to as a(n) _____ count.

Conditional

The _____ function calculates the average of values in a range that match criteria you specify.

AVERAGEIF

You could test two or more conditions and determine whether all conditions are true using the _____ function.

And

To get the effect of a calculated column in a range of data, you must copy and paste the formula or use the _____ feature.

AutoFill

The _____ function calculates the number of cells in a range that match criteria you specify.

COUNTIF

When Excel automatically fills the rest of a table column with a formula entered into an empty table column, this is referred to as a(n) _____ column.

Calculated