What does the `=AVERAGE(10, 20, 30)` function return?
A
20 B
60 C
30 D
10
Analysis & Theory
`AVERAGE(10, 20, 30)` returns (10+20+30)/3 = 20.
Which of the following is the correct syntax to find the average of values in cells A1 through A5?
A
AVERAGE(A1:A5) B
=AVERAGE(A1:A5) C
=AVERAGE(A1 A5) D
AVG(A1:A5)
Analysis & Theory
The correct syntax is `=AVERAGE(A1:A5)`; formulas in Excel must begin with `=`.
Which function is used to find the average excluding empty cells?
A
COUNT B
AVERAGE C
AVERAGEA D
AVERAGEIF
Analysis & Theory
`AVERAGEIF` can exclude specific cells based on a condition.
What will `=AVERAGEA(TRUE, FALSE, 10)` return?
A
10 B
5 C
3.67 D
4
Analysis & Theory
`AVERAGEA` treats TRUE as 1 and FALSE as 0, so average = (1+0+10)/3 = 3.67.
What is the difference between `AVERAGE` and `AVERAGEA` in Excel?
A
`AVERAGEA` ignores text B
`AVERAGE` includes logical values C
`AVERAGEA` includes logical values and text as 0 D
No difference
Analysis & Theory
`AVERAGEA` includes logical values (TRUE=1, FALSE=0) and treats text as 0.
Which function calculates average **only if a condition is met**?
A
AVERAGE B
AVERAGEIF C
AVERAGEA D
SUMIF
Analysis & Theory
`AVERAGEIF(range, criteria, [average_range])` calculates average for cells that meet a condition.
What does `=AVERAGE(B2:B6)` return if B2 to B6 contain the numbers 5, blank, 15, 10, 20?
A
10 B
12.5 C
13.33 D
15
Analysis & Theory
Blank cells are ignored: (5+15+10+20)/4 = 50/4 = 12.5.
Which of the following will give an error in Excel?
A
=AVERAGE("text", 10) B
=AVERAGEA("text", 10) C
=AVERAGE(TRUE, FALSE) D
=AVERAGE(#DIV/0!)
Analysis & Theory
`#DIV/0!` will cause the entire formula to error unless handled with `IFERROR`.
If all selected cells are blank, what does `=AVERAGE()` return?
A
0 B
Blank C
#DIV/0! D
Error
Analysis & Theory
If all selected cells are blank, `=AVERAGE()` returns `#DIV/0!` because there are no valid numbers to average.
Which function allows averaging multiple ranges based on multiple conditions?
A
AVERAGE B
AVERAGEIF C
AVERAGEIFS D
IFAVERAGE
Analysis & Theory
`AVERAGEIFS` averages values that meet **multiple criteria**.