Question 1

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.

Accepted Answer

When a formula is in a calculated table column, the calculation will automatically be applied to all the cells in the column. If you make a change to the formula in one cell, the change will be reflected in all the other cells in the column.

Question 2

The ORERROR function can determine if a cell contains an error value and then display the message you choose.

Accepted Answer

The correct function for this purpose is IFERROR, not ORERROR. IFERROR checks for errors and allows you to specify a message or value if an error is found.

Question 3

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

Accepted Answer

The dialog box indicates that the MedicalRates table is the source of data for the function argument.

Question 4

The IF function evaluates a(n)$\underline { \text { single }   }$condition._________________________

Accepted Answer

The IF function evaluates a single condition and returns a value based on whether the condition is true or false.

Question 5

The COUNTAS function counts the number of cells within a range that meet multiple criteria.

Accepted Answer

The COUNTIF and COUNTIFS functions are used to count the number of cells that meet multiple criteria. The COUNTAS function does not exist in Excel.

Question 6

-According to the dialog box in the accompanying figure,the column in the MedicalRates lookup table that stores the value to be returned is the first column.

Accepted Answer

The column in the lookup table that stores the value to be returned is typically specified by the column index number, which is not necessarily the first column.

Question 7

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

Accepted Answer

Syntax errors occur when there is a mistake in the structure of the formula, such as a missing or extra bracket. Logic errors occur when the formula is correct in structure, but produces the wrong result due to incorrect or incomplete data inputs or incorrect formula logic.

Question 8

$\underline {\text { Duplicate } }$ value highlighting helps to verify that columns of data have unique entries._________________________

Accepted Answer

Duplicate value highlighting can be used to identify any duplicate entries in a column, which is useful in verifying that the data is unique.

Question 9

The $\underline {\text { 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._________________________

Accepted Answer

The VLOOKUP function does exactly what is described in the statement - it searches for a value in the first column of a table and retrieves a corresponding value from another column in the same row.

Question 10

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

Accepted Answer

This is the definition of an AND function. All conditions must be true for the function to return true.

Question 11

In a fully qualified structured reference,the table name $\underline {\text { follows } }$ the column qualifier._________________________

Accepted Answer

The answer of In a fully qualified structured reference,the table...

Question 12

You $\underline {\text { cannot }}$ nest more than one IF function to test for multiple outcomes._________________________

Accepted Answer

You can nest multiple IF functions in Excel to test for multiple outcomes, allowing for complex conditional logic.

Question 13

An error value begins with a(n)$\underline { \text { number sign } }$ followed by an error name,which indicates the type of error._________________________

Accepted Answer

This statement is true. Error values in programming often begin with a number sign (#) followed by an error name or code that indicates the type of error that occurred.

Question 14

In the DATEDIF function,the first date argument is the $\underline {\text { latest } }$ date._________________________

Accepted Answer

The first date argument in the DATEDIF function is the start date, not the latest date.

Question 15

Nesting IF functions will allow for three or more outcomes.

Accepted Answer

Nesting IF functions allows for multiple conditions to be evaluated and can result in three or more possible outcomes.

Question 16

In most cases,when manually creating a conditional formatting formula,the formula should use $\underline {\text { absolute } }$references and point to the first row of data in a table._________________________

Accepted Answer

When creating a conditional formatting formula, relative references are often used to apply the formatting to each cell in the range based on its own value, rather than using absolute references which would fix the reference to a specific cell.

Question 17

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.

Accepted Answer

In most spreadsheet software, when you modify the formula in one cell of a calculated column, the change automatically applies to all cells in that column.

Question 18

If any logical condition listed in the function is true,the $\underline{\text { AND }}$ function returns a TRUE value._________________________

Accepted Answer

The answer of If any logical condition listed in the...

Question 19

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

Accepted Answer

A structured reference can be fully qualified, meaning it includes the table name, or unqualified, meaning it uses only the column or row name within the table.

Question 20

You can calculate the number of cells in a range that match criteria you specify using the $\underline {\text { SUMIF }}$function._________________________

Accepted Answer

The answer of You can calculate the number of cells...

Quiz 8: Working With Advanced Functions

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.

The ORERROR function can determine if a cell contains an error value and then display the message you choose.

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

The IF function evaluates a(n) $\underline { \text { single } }$ condition._________________________

The COUNTAS function counts the number of cells within a range that meet multiple criteria.

-According to the dialog box in the accompanying figure,the column in the MedicalRates lookup table that stores the value to be returned is the first column.

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

$\underline {\text { Duplicate } }$ value highlighting helps to verify that columns of data have unique entries._________________________

The $\underline {\text { 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._________________________

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

In a fully qualified structured reference,the table name $\underline {\text { follows } }$ the column qualifier._________________________

You $\underline {\text { cannot }}$ nest more than one IF function to test for multiple outcomes._________________________

An error value begins with a(n) $\underline { \text { number sign } }$ followed by an error name,which indicates the type of error._________________________

In the DATEDIF function,the first date argument is the $\underline {\text { latest } }$ date._________________________

Nesting IF functions will allow for three or more outcomes.

In most cases,when manually creating a conditional formatting formula,the formula should use $\underline {\text { absolute } }$ references and point to the first row of data in a table._________________________

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.

If any logical condition listed in the function is true,the $\underline{\text { AND }}$ function returns a TRUE value._________________________

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

You can calculate the number of cells in a range that match criteria you specify using the $\underline {\text { SUMIF }}$ function._________________________

Quiz 8: Working With Advanced Functions

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.

The ORERROR function can determine if a cell contains an error value and then display the message you choose.

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

The IF function evaluates a(n) single ‾\underline { \text { single } } single ​ condition._________________________

The COUNTAS function counts the number of cells within a range that meet multiple criteria.

-According to the dialog box in the accompanying figure,the column in the MedicalRates lookup table that stores the value to be returned is the first column.

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

Duplicate ‾\underline {\text { Duplicate } } Duplicate ​ value highlighting helps to verify that columns of data have unique entries._________________________

The VLOOKUP ‾\underline {\text { VLOOKUP } } 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._________________________

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

In a fully qualified structured reference,the table name follows ‾\underline {\text { follows } } follows ​ the column qualifier._________________________

You cannot ‾\underline {\text { cannot }} cannot ​ nest more than one IF function to test for multiple outcomes._________________________

An error value begins with a(n) number sign ‾\underline { \text { number sign } } number sign ​ followed by an error name,which indicates the type of error._________________________

In the DATEDIF function,the first date argument is the latest ‾\underline {\text { latest } } latest ​ date._________________________

Nesting IF functions will allow for three or more outcomes.

In most cases,when manually creating a conditional formatting formula,the formula should use absolute ‾\underline {\text { absolute } } absolute ​ references and point to the first row of data in a table._________________________

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.

If any logical condition listed in the function is true,the AND ‾\underline{\text { AND }} AND ​ function returns a TRUE value._________________________

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

You can calculate the number of cells in a range that match criteria you specify using the SUMIF ‾\underline {\text { SUMIF }} SUMIF ​ function._________________________

The IF function evaluates a(n) $\underline { \text { single } }$ condition._________________________

$\underline {\text { Duplicate } }$ value highlighting helps to verify that columns of data have unique entries._________________________

The $\underline {\text { 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._________________________

In a fully qualified structured reference,the table name $\underline {\text { follows } }$ the column qualifier._________________________

You $\underline {\text { cannot }}$ nest more than one IF function to test for multiple outcomes._________________________

An error value begins with a(n) $\underline { \text { number sign } }$ followed by an error name,which indicates the type of error._________________________

In the DATEDIF function,the first date argument is the $\underline {\text { latest } }$ date._________________________

In most cases,when manually creating a conditional formatting formula,the formula should use $\underline {\text { absolute } }$ references and point to the first row of data in a table._________________________

If any logical condition listed in the function is true,the $\underline{\text { AND }}$ function returns a TRUE value._________________________

You can calculate the number of cells in a range that match criteria you specify using the $\underline {\text { SUMIF }}$ function._________________________