# New Perspectives Microsoft Office

Computing

## Quiz 8 : Working With Advanced Functions Looking for Microsoft Office Homework Help?

## Quiz 8 :Working With Advanced Functions

Question Type  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  