Question 1

You can calculate the number of cells in a range that match criteria you specify using the SUMIF function. _________________________

Accepted Answer

False

Question 2

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

Accepted Answer

A structured reference can be either fully qualified or unqualified, depending on whether or not it includes the table name or column header in the reference. A fully qualified reference includes the table name and/or column header, while an unqualified reference only includes the column name.

Question 3

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

This is because calculated table columns are created using DAX formulas that automatically propagate down the entire column. Therefore, any changes made to the formula in one cell will be applied to all the cells in the column.

Question 4

In the DATEDIF function, the first date argument is the latest date. _________________________

Accepted Answer

The first date argument in the DATEDIF function is the start date, which is the earlier date. The second date argument is the end date, which is the later date.

Question 5

In a fully qualified structured reference, the table name follows the column qualifier. _________________________

Accepted Answer

In a fully qualified structured reference, the table name precedes the column qualifier.

Question 6

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.
A)IF
B)AND
C)OR
D)THIS

Accepted Answer

The OR function is the 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.

Question 7

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

Accepted Answer

Syntax errors occur when the formula is not written correctly, such as missing parentheses or using incorrect functions. Logic errors occur when the formula is written correctly, but the result is not what was intended, such as using the wrong cell references or incorrect mathematical operations.

Question 8

The IF function evaluates a(n)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 9

An error value begins with a(n)number sign followed by an error name, which indicates the type of error. _________________________

Accepted Answer

This statement is true. Error values in programming languages typically start with a hash symbol (#) followed by an error code or name that describes the type of error that occurred.

Question 10

If any logical condition listed in the function is true, the AND function returns a TRUE value. _________________________

Accepted Answer

If any logical condition listed in the function is true, the AND function returns a FALSE value. The AND function only returns TRUE if all the logical conditions listed are true.

Question 11

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

The answer of If you need to modify the formula...

Question 12

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.
A)concatenated
B)calculated
C)autofilled
D)custom

Accepted Answer

When Excel automatically fills the rest of a table column with a formula entered into an empty table column, it is called a calculated column.

Question 13

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

Accepted Answer

The answer of The ORERROR function can determine if a...

Question 14

Nesting IF functions will allow for three or more outcomes.

Accepted Answer

Nesting IF functions allows for multiple outcomes based on multiple conditions.

Question 15

Duplicate value highlighting helps to verify that columns of data have unique entries. _________________________

Accepted Answer

Duplicate value highlighting identifies and highlights any duplicate values within a column, making it easier to check for unique entries.

Question 16

To get the effect of a calculated column in a range of data, you must copy and paste the formula or use the _____ feature.
A)Concatenation
B)Merged
C)AutoFill
D)Indexed

Accepted Answer

AutoFill is the feature that allows you to quickly copy a formula to a range of cells. Simply select the cell with the formula, hover over the bottom-right corner until the crosshair appears, and drag down or across to copy the formula to the desired range of cells. This will allow you to get the effect of the calculated column without manually copying and pasting the formula.

Question 17

You cannot nest more than one IF function to test for multiple outcomes. _________________________

Accepted Answer

This statement is false. You can nest multiple IF functions to test for multiple outcomes. This is called a nested IF function.

Question 18

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. _________________________

Accepted Answer

This is the correct explanation for the VLOOKUP function.

Question 19

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

Accepted Answer

In an AND function, all the logical conditions mentioned must be true for the function to return a TRUE value. If any of the conditions are false, the entire function will return a FALSE value.

Question 20

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. _________________________

Accepted Answer

The answer of In most cases, when manually creating a...

Quiz 8: Excel 4: Working With Advanced Functions