What is the value when Excel calculate the average of three cells with values of 10, blank, and 8?
A)6
B)9
C)10
D)none; Excel cannot calculate an average in a range that includes a blank cell

Name: What is the value when Excel calculate the average of three cells with values of 10, blank, and 8? A)6 B)9 C)10 D)none; Excel cannot calculate an average in a range that includes a blank cell
Brand: Quizplus
Rating: 4.8 (33 reviews)

Question

Quizplus · Accepted Answer

Excel calculates the average by ignoring blank cells, so the average of 10 and 8 is (10+8)/2 = 9.

What Is the Value When Excel Calculate the Average of Three