question

Two common categories of formula errors in Excel are syntax errors and logic errors.

answer

True

question

Duplicate value highlighting helps to verify that columns of data have unique entries.

answer

True

question

Using the VLOOKUP function, an exact match lookup occurs when the value entered must match one of the values in _____ of the lookup table.

answer

First column

question

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.

answer

OR

question

The _____ function adds the values in a range that match criteria you specify.

answer

SUMIF

question

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

answer

qualified

question

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

answer

qualifier

question

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

answer

Conditional

question

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

answer

#N/A

question

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

answer

Structured

question

Nesting IF functions will allow for three or more outcomes.

answer

True

question

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

answer

Rule

question

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.

answer

Green Triangle

question

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

answer

Rules

question

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

answer

Organized

question

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

answer

Number sign

question

When using VLOOKUP, the _____argument is optional.

answer

range_lookup

question

Given the flowchart in the accompanying figure, the Perf Rating of _____ yields a Bonus value of 0.

answer

1

question

The IF function evaluates a(n) single condition

answer

True

question

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

answer

functions

question

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

answer

nest

question

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

answer

m

question

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

answer

AND

question

The _____ function calculates the difference between two dates and shows the result in months, days, or years.

answer

DATEDIF

question

If a formula is in a calculated table column, you need to make a change in only one cell and the change will automatically be copied to all the cells in the column.

answer

True

question

If any logical condition listed in the function is true, the AND function returns a TRUE value.

answer

False

question

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

answer

IF

question

If you are not sure of a tables name, click in the table, click the ___ tab on the ribbon, and then click the table name box in the Properties group.
Table tools design.

answer

Table Tools Design

question

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

answer

Logical

question

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

answer

AVERAGEIF

question

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

answer

VLOOKUP

question

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

answer

cell and range addresses

question

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

answer

AutoFill

question

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

answer

Click

question

A formula that includes a structured reference can be fully qualified or unqualified

answer

True

question

According to the dialog box in the accompanying figure, the MedicalRates table is the one from which the data in your function argument will be obtained.

answer

True

question

You can calculate the number of cells in a range that match criteria you specify using the SUMIF function.

answer

False

question

All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.

answer

True

question

The Conditional Formatting button provides access to the _____.

answer

Manage Rules option

question

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

answer

COUNTIF

question

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.

answer

Calculated

question

You can include up to _____ logical conditions in the AND function.

answer

255

question

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

answer

VLOOKUP

question

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:

answer

Styles

question

______ 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:

answer

Structured

question

If all of the logical conditions are true, the AND function returns the logical value ______:

answer

TRUE

question

The VLOOKUP function searches vertically down the first column of the lookup table for the value you entered, and then retrieves the corresponding value from another column of the table.

answer

True

question

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

answer

True

question

Given the flowchart in the accompanying figure, the Perf Rating of _____ yields a Bonus value of 2500.

answer

2