MS Excel MCQs with Answers 2026

1. MS Excel is used for:

a) Word processing    b) Spreadsheet calculations and data analysis ✅    c) Presentations    d) Email

2. The default file extension of Excel is:

a) .xlsx ✅    b) .docx    c) .pptx    d) .csv

3. The intersection of a row and column is called:

a) Table    b) Cell ✅    c) Range    d) Sheet

4. Each Excel workbook contains one or more:

a) Documents    b) Worksheets (sheets) ✅    c) Slides    d) Pages

5. Every formula in Excel starts with:

a) #    b) @    c) = (equal sign) ✅    d) dollar

6. =SUM(A1:A10) will:

a) Count cells    b) Add all values from A1 to A10 ✅    c) Find average    d) Find maximum

7. =AVERAGE(B1:B5) calculates the:

a) Sum    b) Count    c) Average of values in B1 to B5 ✅    d) Maximum

8. =COUNT(A1:A10) returns:

a) Sum of values    b) Number of cells containing numbers ✅    c) Average    d) Maximum value

9. Which feature sorts data alphabetically or numerically?

a) Filter    b) Sort ✅    c) Merge    d) Format

10. Which feature shows only data meeting specific criteria?

a) Sort    b) Filter ✅    c) Merge    d) Group

11. A cell reference that does NOT change when copied is:

a) Relative reference    b) Absolute reference () ✅    c) Mixed reference    d) Named reference

12. Ctrl+; in Excel inserts:

a) Current time    b) Current date ✅    c) Formula    d) Cell reference

13. F2 key in Excel is used to:

a) Print    b) Edit the active cell ✅    c) Save    d) Delete

14. Which chart type is best for showing trends over time?

a) Pie chart    b) Bar chart    c) Line chart ✅    d) Scatter plot