Question 1

The IF function results in two values._________________________

Accepted Answer

one value
only one value

Question 2

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

Accepted Answer

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

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Use to reference cells within an Excel table

Accepted Answer

Cell and range addresses are how cells are referenced within an Excel table.

Question 4

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

Accepted Answer

earliest

Question 5

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

Accepted Answer

OR

Question 6

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

Accepted Answer

This statement is true. Error values in Excel typically begin with a number sign (#) followed by an error name such as #DIV/0! for a divide by zero error or #VALUE! for a cell reference error.

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Excel table column containing data derived from other columns

Accepted Answer

A calculated column is a column in an Excel table that contains a formula that performs calculations using data in other columns of the table. It allows you to create new data based on existing data in the table.

Example: If you had columns for length and width, you could create a calculated column to calculate the area by multiplying length x width.

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Adds the values in a range that meet criteria you specify

Accepted Answer

SUMIF adds the values in a range that meet specific criteria that you specify.

Question 9

The #VALUE! error value can occur when a cell used by the function was deleted from the worksheet._________________________

Accepted Answer

#REF!

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-You can calculate the number of cells in a range that match criteria you specify using this function

Accepted Answer

The function that allows you to count the number of cells in a range that match a specific criteria is COUNTIF.

Question 11

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

Accepted Answer

precedes
comes before

Question 12

If you use a structured reference outside a table or in another worksheet to reference an Excel table or portion of the table,you need to use a fully unqualified reference._________________________

Accepted Answer

qualified

Question 13

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

Accepted Answer

Duplicate value highlighting is a feature in excel that helps to identify duplicate entries in a column which are useful in verifying that columns of data have unique entries.

Question 14

When manually creating a conditional formatting formula,if the formula references a cell or range outside the table,relative references should be used._________________________

Accepted Answer

absolute

Question 15

In an unqualified structured reference,only the column qualifier appears in the reference._________________________

Accepted Answer

In an unqualified structured reference, only the column qualifier (e.g. [Column1]) appears in the reference, and the formula will assume that the reference is in the same row as the formula.

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Use to calculate the average of values in a range that meet criteria you specify

Accepted Answer

AVERAGEIF is specifically designed to calculate the average of values in a range that meet a certain criteria, which is exactly what the given definition describes.

Question 17

You use the MEANIF function to calculate the average of values in a range that meet criteria you specify._________________________

Accepted Answer

AVERAGEIF

Question 18

The #REF! error value can occur when you supply a range of values to a function that requires a single value._________________________

Accepted Answer

#VALUE!

Question 19

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

relative

Question 20

You cannot nest more than one IF function._________________________

Accepted Answer

can

Quiz 7: Using Advanced Functions and Conditional Formatting