# New Perspectives Microsoft Office

Computing

## Quiz 8 :Working With Advanced Functions

Question Type
Showing 1 - 20 of 75
All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.
Free
True False

True

Tags
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.
Free
True False

True

Tags
If you need to modify the formula in a calculated column,you edit the formula in one cell of the column and then you modify the formulas in the remaining cells in that table column.
Free
True False

False

Tags
A formula that includes a structured reference can be fully qualified or unqualified.
True False
Tags
The ORERROR function can determine if a cell contains an error value and then display the message you choose.
True False
Tags
Nesting IF functions will allow for three or more outcomes.
True False
Tags
Two common categories of formula errors in Excel are syntax errors and logic errors.
True False
Tags
The IF function evaluates a(n)single condition._________________________
True False
Tags
In a fully qualified structured reference,the table name follows the column qualifier._________________________
True False
Tags
In the DATEDIF function,the first date argument is the latest date._________________________
True False
Tags
You cannot nest more than one IF function to test for multiple outcomes._________________________
True False
Tags
If any logical condition listed in the function is true,the AND function returns a TRUE value._________________________
True False
Tags
Duplicate value highlighting helps to verify that columns of data have unique entries._________________________
True False
Tags
In most cases,when manually creating a conditional formatting formula,the formula should use absolute references and point to the first row of data in a table._________________________
True False
Tags
An error value begins with a(n)number sign followed by an error name,which indicates the type of error._________________________
True False
Tags
You can calculate the number of cells in a range that match criteria you specify using the SUMIF function._________________________
True False
Tags
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._________________________
True False
Tags
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.
Multiple Choice