Correct Answer:
B. SUM(Sales)/(10-5)
Correct answer: SUM(Sales)/(10-5). SUM(Sales)/(10-5) is not valid Excel syntax, as it has no equals sign.
Background: Every Excel formula must start with =, so this is treated as plain text.
- =SUM(A1:A10): =SUM(A1:A10) is correct, adding A1 to A10.
- =AVERAGE(B1:B5): =AVERAGE(B1:B5) is correct: it starts with = and averages B1 to B5.
- =MAX(C1:C8): =MAX(C1:C8) is correct: it starts with = and takes the largest in C1 to C8.
Did you know? Excel formulas always begin with =.
Memory trick: No equals sign, no formula: every formula starts with =.
Leave a Reply
You must be logged in to post a comment.