PREMIUM
Join our WhatsApp Channel
Daily MCQs, Past Papers & Jobs for PPSC, FPSC, CSS
Daily MCQs • Past Papers • Jobs for PPSC, FPSC, CSS
Join Channel

Which of the following is NOT a valid Excel formula syntax?

A. =SUM(A1:A10)
B. SUM(Sales)/(10-5)
C. =AVERAGE(B1:B5)
D. =MAX(C1:C8)
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 =.

0 comments

Leave a Reply

Join Our WhatsApp Channel ×