0%

#### Which function determines whether a condition is true or false before calculating the sum of values in a range?

Correct! Wrong!

To calculate the sum of values in a range based on a true or false condition - SUMIF() function is used.

Syntax:
=SUMIF(range, criterion, [sum_range])

#### In which format are the numbers with the dollar (\$) symbol represented? (For instance, \$1,000.00)

Correct! Wrong!

The numbers denoted by the dollar (\$) sign are represented by the currency. To do this, choose the cells that have the numbers in them, click "Format Menu," then choose "Number" from the list, and finally click "Currency."

Correct! Wrong!

To add up numbers in a range - SUM() function is used.

Example: = SUM (B2:B10)

#### Based on a true or false condition, which function is used to find the average (arithmetic mean) of a range?

Correct! Wrong!

The AVERAGEIF() function is used to calculate the average (arithmetic mean) of a range based on a true or false condition.

Syntax:
=AVERAGEIF(criteria_range, criterion, [average_range])

#### Which function determines whether a range is true or false based on one or more conditions?

Correct! Wrong!

To calculate the sum of a range based on one or more true or false conditions - SUMIFS() function is used.
Syntax:
=SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, ...], [criterion2, ...])

#### In order to determine the average (arithmetic mean) of a range given one or more true or false conditions, which function is used?

Correct! Wrong!

The AVERAGEIF() function is used to calculate the average (arithmetic mean) of a range based on one or more true or false conditions.

Syntax:

=AVERAGEIFS(average_range, criteria_range1, criterion1, ...)

Correct! Wrong!