FREE Google Sheets Syntax Questions and Answers
Which function determines whether a range is true or false based on one or more conditions?
Correct Answer: SUMIFS
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 Answer: AVERAGEIFS
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, ...)
In which format are the numbers with the dollar ($) symbol represented? (For instance, $1,000.00)
Correct Answer: Currency
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."
Which function determines whether a condition is true or false before calculating the sum of values in a range?
Correct Answer: SUMIF
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])
What function is employed to calculate the arithmetic mean, or average?
Correct Answer: AVERAGE
The AVERAGE() function is used to calculate the average (arithmetic mean).
Syntax:
=AVERAGE(value1, [value2, ...])
Which Google Sheets function adds the values within a range?
Correct Answer: SUM
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 Answer: AVERAGEIF
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])