Q1. MS Excel is a:

A) Word processing software
B) Spreadsheet software
C) Presentation software
D) Antivirus software

Answer: B) Spreadsheet software
Explanation:

MS Excel is used for calculations, data analysis, tables, and charts.

Q2. A file in Excel is called:

A) Document
B) Workbook
C) Slide
D) Page

Answer: B) Workbook
Explanation:

An Excel file is called a Workbook, which contains one or more worksheets.

Q3. A single page in Excel is called:

A) Workbook
B) Worksheet
C) Slide
D) Paragraph

Answer: B) Worksheet
Explanation:

Worksheet is a single spreadsheet page inside a workbook.

Q4. The intersection of row and column is called:

A) Box
B) Cell
C) Table
D) Formula

Answer: B) Cell
Explanation:

A cell is formed where a row and a column meet.

Q5. Which symbol is used to start a formula in Excel?

A) +
B) =
C) @
D) #

Answer: B) =
Explanation:

Every formula in Excel starts with the equal (=) sign.

Q6. Which function is used for addition?

A) COUNT()
B) SUM()
C) AVG()
D) MAX()

Answer: B) SUM()
Explanation:

SUM() adds numbers in selected cells.

Q7. Which function is used to find average?

A) SUM()
B) COUNT()
C) AVERAGE()
D) MIN()

Answer: C) AVERAGE()
Explanation:

AVERAGE() calculates the mean value of numbers.

Q8. Which function finds the highest value?

A) MIN()
B) MAX()
C) SUM()
D) IF()

Answer: B) MAX()
Explanation:

MAX() returns the largest number from selected cells.

Q9. Which function finds the smallest value?

A) MIN()
B) MAX()
C) COUNT()
D) SUM()

Answer: A) MIN()
Explanation:

MIN() returns the smallest number from selected cells.

Q10. Which function counts numerical entries?

A) COUNT()
B) SUM()
C) MAX()
D) AVG()

Answer: A) COUNT()
Explanation:

COUNT() counts the number of cells containing numbers.

Q11. Which chart is used to show trends over time?

A) Pie Chart
B) Line Chart
C) Bar Chart
D) Area Chart

Answer: B) Line Chart
Explanation:

Line charts are best for showing changes over time.

Q12. Which chart is best for percentage distribution?

A) Pie Chart
B) Line Chart
C) Scatter Chart
D) Column Chart

Answer: A) Pie Chart
Explanation:

Pie chart shows percentage contribution of each part.

Q13. Which shortcut key saves workbook?

A) Ctrl + P
B) Ctrl + S
C) Ctrl + C
D) Ctrl + X

Answer: B) Ctrl + S
Explanation:

Ctrl + S saves the current workbook.

Q14. Which option changes cell appearance automatically?

A) Conditional Formatting
B) Hyperlink
C) Sheet Rename
D) Print Preview

Answer: A) Conditional Formatting
Explanation:

Conditional Formatting changes cell format based on conditions.

Q15. Which function is used for logical testing?

A) IF()
B) SUM()
C) MAX()
D) MIN()

Answer: A) IF()
Explanation:

IF() checks conditions and returns results based on True or False.

Q16. Which option is used to sort data alphabetically?

A) Filter
B) Sort
C) Chart
D) Hyperlink

Answer: B) Sort
Explanation:

Sort arranges data in ascending or descending order.

Q17. Which option hides unwanted data temporarily?

A) Formula
B) Filter
C) Rename
D) Chart

Answer: B) Filter
Explanation:

Filter displays only selected data based on conditions.

Q18. Which key moves to next cell?

A) Enter
B) Tab
C) Esc
D) Shift

Answer: B) Tab
Explanation:

Tab key moves the cursor to the next cell horizontally.

Q19. Which feature links a cell to webpage?

A) Hyperlink
B) Formula
C) Filter
D) Chart

Answer: A) Hyperlink
Explanation:

Hyperlink connects Excel cells to websites or files.

Q20. Which option is used to rename worksheet?

A) Double click sheet name
B) Ctrl + R
C) Print
D) Formula Bar

Answer: A) Double click sheet name
Explanation:

Double-clicking the sheet tab allows renaming.

Q21. Which option fills data automatically?

A) Auto Fill
B) Filter
C) Sort
D) Rename

Answer: A) Auto Fill
Explanation:

Auto Fill copies formulas or continues data patterns automatically.

Q22. Cell reference A1 means:

A) Row A Column 1
B) Column A Row 1
C) Area 1
D) Sheet A

Answer: B) Column A Row 1
Explanation:

Excel identifies cells by column letter first, then row number.

Q23. Which formula calculates GPA?

A) SUM only
B) Average-based formula
C) MAX only
D) COUNT only

Answer: B) Average-based formula
Explanation:

GPA is usually calculated using average of grade points.

Q24. Which bar shows formula content?

A) Title Bar
B) Formula Bar
C) Status Bar
D) Tool Bar

Answer: B) Formula Bar
Explanation:

Formula Bar displays and edits formulas of selected cells.

Q25. Which shortcut selects all cells?

A) Ctrl + A
B) Ctrl + S
C) Ctrl + P
D) Ctrl + Z

Answer: A) Ctrl + A
Explanation:

Ctrl + A selects the entire worksheet data.

Q26. Which option merges multiple cells?

A) Merge & Center
B) Hyperlink
C) Filter
D) Count

Answer: A) Merge & Center
Explanation:

Merge & Center combines cells into one larger cell.

Q27. Which extension is used for Excel file?

A) .docx
B) .pptx
C) .xlsx
D) .jpg

Answer: C) .xlsx
Explanation:

Excel files are commonly saved with .xlsx extension.

Q28. Which option is used before printing?

A) Print Preview
B) Formula
C) Sort
D) Hyperlink

Answer: A) Print Preview
Explanation:

Print Preview shows how the sheet will look when printed.

Q29. Which function is used to find text length?

A) LEN()
B) SUM()
C) IF()
D) MAX()

Answer: A) LEN()
Explanation:

LEN() returns the number of characters in text.

Q30. Which function returns current date?

A) TODAY()
B) SUM()
C) DATEONLY()
D) NOWONLY()

Answer: A) TODAY()
Explanation:

TODAY() displays the current system date.