# Quiz 5

## Unlock all answers in this set

question
Two common categories of formula errors in Excel are syntax errors and logic errors.
True
question
Duplicate value highlighting helps to verify that columns of data have unique entries.
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.
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.
OR
question
The _____ function adds the values in a range that match criteria you specify.
SUMIF
question
If you are creating a calculated column or formula within an Excel table, you can use the _____ structured reference in the formula.
qualified
question
When you want to reference an entire column of data in a table, you create a column _____.
qualifier
question
The COUNTIF function is sometimes referred to as a(n) _____ count.
Conditional
question
The _____ error value means that a value is not available to a function or formula.
#N/A
question
When you create a calculated column, you can use _____ references to create the formula.
Structured
question
Nesting IF functions will allow for three or more outcomes.
True
question
Each time you create a conditional format, you are defining a conditional formatting _____.
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.
Green Triangle
question
You can edit existing conditional formatting _____ from the Conditional Formatting Rules Manager dialog box.
Rules
question
The major difference between HLOOKUP and VLOOKUP functions is the way the lookup tables are _____.
Organized
question
An error value begins with a(n) _____ followed by an error name that indicates the type of error.
Number sign
question
When using VLOOKUP, the _____argument is optional.
range_lookup
question
Given the flowchart in the accompanying figure, the Perf Rating of _____ yields a Bonus value of 0.
1
question
The IF function evaluates a(n) single condition
True
question
Lookup _____ allow you to use tables of data to "look up" values and insert them in another worksheet location.
functions
question
You can _____ IF functions to allow for three or more outcomes.
nest
question
With the DATEDIF function, the ____ interval code means months.
m
question
You could test two or more conditions and determine whether all conditions are true using the _____ function.
AND
question
The _____ function calculates the difference between two dates and shows the result in months, days, or years.
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.
True
question
If any logical condition listed in the function is true, the AND function returns a TRUE value.
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
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.
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
Logical
question
The _____ function calculates the average of values in a range that match criteria you specify.
AVERAGEIF
question
You can use a _____ function to return a value from a table that is based on an approximate match lookup.
VLOOKUP
question
You can use ______ to reference cells within an Excel table.
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.
AutoFill
question
______ just above the header row of an Excel table to select the column data but not the header.
Click
question
A formula that includes a structured reference can be fully qualified or unqualified
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.
True
question
You can calculate the number of cells in a range that match criteria you specify using the SUMIF function.
False
question
All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.
True
question
The Conditional Formatting button provides access to the _____.
Manage Rules option
question
The ______ function calculates the number of cells in a range that match criteria you specify.
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.
Calculated
question
You can include up to _____ logical conditions in the AND function.
255
question
The _____ function searches vertically down the first column of the lookup table.
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:
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:
Structured
question
If all of the logical conditions are true, the AND function returns the logical value ______: