New Perspectives Microsoft Office

Computing

Quiz 8 :

Working With Advanced Functions

Quiz 8 :

Working With Advanced Functions

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

Answer:

True

Tags
arrow
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
Answer:

Answer:

True

Tags
arrow
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
Answer:

Answer:

False

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