KCSA – MS Excel MCQs

Kashmir Civil Services Academy

MS Excel MCQs (With Answers & Explanations)

1. MS Excel is a?

A. Word processor
B. Spreadsheet software
C. Database software
D. Presentation software
Correct Answer: B
Explanation: MS Excel is used to create spreadsheets and perform calculations.

2. What is a worksheet?

A. Entire Excel file
B. Single page in Excel
C. Toolbar
D. Formula bar
Correct Answer: B
Explanation: A worksheet is a single spreadsheet page.

3. Excel file is saved with extension?

A. .docx
B. .pptx
C. .xlsx
D. .txt
Correct Answer: C
Explanation: Default Excel file extension is .xlsx.

4. Intersection of row and column is called?

A. Table
B. Cell
C. Range
D. Box
Correct Answer: B
Explanation: A cell is formed where a row and column meet.

5. Which symbol starts a formula?

A. +
B. @
C. #
D. =
Correct Answer: D
Explanation: All Excel formulas begin with = sign.

6. Which function adds numbers?

A. COUNT B. SUM C. AVG D. ADD
Correct Answer: B
SUM adds values.

7. Which function counts numbers?

A. COUNT B. SUM C. MAX D. IF
Correct Answer: A
COUNT counts numeric cells.

8. Which key edits a cell?

A. F1 B. F2 C. F5 D. F12
Correct Answer: B
F2 edits active cell.

9. Which chart shows comparison?

A. Pie B. Line C. Column D. Area
Correct Answer: C
Column chart compares values.

10. Excel has how many columns?

A. 256 B. 1024 C. 16384 D. Unlimited
Correct Answer: C
Excel supports 16,384 columns.

11. Freeze Panes is used to?

A. Lock file B. Hide rows C. Keep rows visible D. Protect sheet
Correct Answer: C
Keeps rows/columns visible.

12. Which function finds highest value?

A. MIN B. MAX C. SUM D. COUNT
Correct Answer: B
MAX returns largest value.

13. Which function gives average?

A. MEAN B. AVG C. AVERAGE D. MID
Correct Answer: C
AVERAGE calculates mean.

14. What is cell reference?

A. Cell color B. Cell address C. Cell value D. Cell size
Correct Answer: B
Cell address like A1.

15. Which is absolute reference?

A. A1 B. $A1 C. A$1 D. $A$1
Correct Answer: D
$A$1 is absolute.

16. Excel supports?

A. Calculations B. Charts C. Data analysis D. All
Correct Answer: D
Excel supports all.

17. Shortcut to save file?

A. Ctrl+C B. Ctrl+S C. Ctrl+V D. Ctrl+X
Correct Answer: B
Ctrl+S saves file.

18. Which tool sorts data?

A. Filter B. Sort C. Freeze D. Protect
Correct Answer: B
Sort arranges data.

19. Which tool filters data?

A. Sort B. Pivot C. Filter D. Chart
Correct Answer: C
Filter hides unwanted data.

20. Which bar shows formula?

A. Status bar B. Formula bar C. Title bar D. Tool bar
Correct Answer: B
Formula bar displays formulas.

21. Pivot Table is used for?

A. Formatting B. Data analysis C. Printing D. Saving
Correct Answer: B
Pivot tables summarize data.

22. Which function checks condition?

A. SUM B. IF C. COUNT D. MAX
Correct Answer: B
IF applies logical test.

23. Which function counts non-empty cells?

A. COUNT B. COUNTA C. COUNTBLANK D. SUM
Correct Answer: B
COUNTA counts non-empty cells.

24. Which function finds smallest value?

A. MIN B. MAX C. AVG D. MID
Correct Answer: A
MIN returns smallest value.

25. Conditional formatting is used to?

A. Delete data B. Highlight data C. Sort data D. Print data
Correct Answer: B
Highlights cells based on condition.

26. Which chart shows proportion?

A. Bar B. Column C. Pie D. Line
Correct Answer: C
Pie chart shows proportion.

27. Workbook contains?

A. One sheet B. Charts C. Worksheets D. Rows
Correct Answer: C
Workbook has multiple worksheets.

28. What is range?

A. Single cell B. Multiple cells C. Column D. Row
Correct Answer: B
Range is group of cells.

29. Which key deletes cell content?

A. Backspace B. Delete C. Esc D. Enter
Correct Answer: B
Delete removes content.

30. What does VLOOKUP do?

A. Sort data B. Vertical search C. Horizontal search D. Sum values
Correct Answer: B
VLOOKUP searches vertically.

31. Which function joins text?

A. JOIN B. CONCAT C. TEXT D. MID
Correct Answer: B
CONCAT joins text.

32. Which tool protects worksheet?

A. Freeze B. Lock C. Protect Sheet D. Filter
Correct Answer: C
Protect Sheet secures worksheet.

33. Which view shows page layout?

A. Normal B. Page Layout C. Custom D. Data
Correct Answer: B
Page Layout view.

34. Which function removes spaces?

A. TRIM B. MID C. LEFT D. RIGHT
Correct Answer: A
TRIM removes extra spaces.

35. Which key inserts new sheet?

A. Shift+F11 B. Ctrl+N C. Ctrl+S D. F2
Correct Answer: A
Shift+F11 inserts sheet.

36. Which function converts text to number?

A. VALUE B. TEXT C. NUM D. FIX
Correct Answer: A
VALUE converts text to number.

37. What is Pivot Chart?

A. Normal chart B. Chart linked to pivot C. 3D chart D. Pie chart
Correct Answer: B
Pivot chart linked to pivot table.

38. Which function finds length of text?

A. LEN B. MID C. COUNT D. TEXT
Correct Answer: A
LEN counts characters.

39. Which option hides rows?

A. Delete B. Hide C. Filter D. Lock
Correct Answer: B
Hide hides rows.

40. Which function rounds number?

A. FIX B. ROUND C. FLOOR D. CEIL
Correct Answer: B
ROUND rounds numbers.

41. Which chart shows trend?

A. Pie B. Line C. Bar D. Area
Correct Answer: B
Line chart shows trend.

42. Which function extracts middle text?

A. LEFT B. RIGHT C. MID D. LEN
Correct Answer: C
MID extracts text.

43. Which tool validates data?

A. Filter B. Validation C. Protect D. Freeze
Correct Answer: B
Data validation controls input.

44. Excel is used for?

A. Calculations B. Charts C. Data analysis D. All
Correct Answer: D
Excel supports all.

45. Which function counts blanks?

A. COUNT B. COUNTBLANK C. COUNTA D. SUM
Correct Answer: B
COUNTBLANK counts empty cells.

46. Which feature protects workbook?

A. Freeze B. Protect Workbook C. Filter D. Sort
Correct Answer: B
Protect Workbook secures file.

47. Which function returns current date?

A. DATE B. TODAY C. NOW D. DAY
Correct Answer: B
TODAY returns current date.

48. Which function returns current time?

A. TIME B. NOW C. CLOCK D. DATE
Correct Answer: B
NOW returns date and time.

49. Which feature prevents duplicate entries?

A. Filter B. Sort C. Data Validation D. Freeze
Correct Answer: C
Data validation restricts duplicates.

50. Excel acts as?

A. OS B. Application software C. System software D. Utility
Correct Answer: B
Excel is application software.