Q: 3
What does the AVERAGE function do in Excel?
Options
Discussion
Hmm, I picked A. Not sure why everyone else is picking B, but A seemed right to me.
Don't think it's A or C here. B matches the exact behavior of the AVERAGE function in Excel-just calculates the mean across numbers in a range. The other two look like distractors for ROW/MATCH and VLOOKUP. Pretty straightforward unless there's a trick I'm missing. B.
B had something like this in a mock. The AVERAGE function just computes the mean, nothing fancy here.
Option B Similar question popped up in the official guide, pretty sure it's this, but check practice tests to confirm.
I don’t think it’s A. B fits since the AVERAGE function in Excel literally computes the arithmetic mean of a range. A is more about finding a position, which MATCH or ROW would do, and C is clearly for VLOOKUP or similar. Unless they're asking about a custom formula, it's B all day-unless I missed some sneaky wording.
B makes sense here, since the Excel AVERAGE function literally finds the mean of a range of numbers. C is about lookup and A is more like MATCH or ROW, not related to averages. Pretty confident but correct me if I'm missing something.
Its B, the AVERAGE function just calculates the mean of selected numbers. Option A is a trap, that's about position not calculation. Pretty sure on this one unless they meant something more specific.
B
Is the question specifically asking about the built-in AVERAGE or does it mean "average" in general? That could change things.
Be respectful. No spam.