ms excel formula mcq questions and answers

MS Excel formulas are a very important topic. If you do not learn MS Excel formulas, you will not be able to use Excel properly. That’s why this MCQ test has been created. In this test, you will find all types of questions related to MS Excel formulas. After completing the MCQ test, you will also be shown the correct and incorrect answers along with detailed solutions.

Q1. What is the correct formula to find the sum of all numbers from B2 to B6 in MS Excel?

=SUM(2B:6B)

=SUM(B2:B6)

none of these

✅ Correct Answer: =SUM(B2:B6)

In MS Excel, we use the SUM formula to add numbers. We write =SUM and then provide the range inside brackets.

Q2. Which is the correct formula to calculate the average of some numbers?

=AVERAGE(B2:B6)

=AVE(B2:B6)

=AV(B2:B6)

=sum(B2:B6)

✅ Correct Answer: =AVERAGE(B2:B6)

To calculate the average, we use the AVERAGE formula and provide the range of values inside brackets.

Q3. Which formula should be used to find the smallest number from the numbers in the range B6 to B19?

max

min

average

only 1 and 3

✅ Correct Answer: min

To find the smallest number from a range, we use the MIN formula. Example: =MIN(B2:B6)

Q4. If you want to apply a condition on data, like students scoring below 50 marks will be fail, then which formula will you use?

=if(A1>50,'Pass','Fail')

=else(A1>50,'Pass','Fail')

=co(A1>50,'Pass','Fail')

=logic(A1>50,'Pass','Fail')

✅ Correct Answer: =if(A1>50,'Pass','Fail')

When we need to apply a condition, we use the IF formula. It checks the condition and returns different values based on the result.

Q5. Which is the correct formula to find the largest number from the data in the range B7 to B19?

=MAX(B7:B19)

=MIN(B7:B19)

=MAX(B8:B18)

none of these

✅ Correct Answer: =MAX(B7:B19)

To find the largest number in a range, we use the MAX formula.

Q6. What output will the formula =COUNT(A1:A7) give?

Total number of cells

Count of numeric values only

Count of text only

Count of empty cells

✅ Correct Answer: Count of numeric values only

The COUNT formula counts only numeric values present in the given range.

Q7. Which of the following formulas is NOT used in MS Excel?

COUNT

SUM

AVERAGE

ALO

✅ Correct Answer: ALO

There is no formula named ALO in MS Excel.

Q8. Which of the following formulas is used for Logical Functions?

SUM()

SUB()

IF()

MOD()

✅ Correct Answer: IF()

The IF formula is used for logical functions. It applies conditions and returns results like Pass or Fail.

Q9. What will the formula =A1 - B1 do?

Subtract A1 from B1

Subtract B1 from A1

It will multiply

It will divide

✅ Correct Answer: Subtract B1 from A1

The value in cell B1 is subtracted from A1. For example, 50 - 40 = 10.

Q10. Where is the PMT() formula used?

Loan EMI

Depositing fees

Removing text

All of these

✅ Correct Answer: Loan EMI

The PMT() formula is used to calculate loan EMI.