1. Which key is used to edit the contents of an active cell in MS Excel?
(A) F2
(B) F1
(C) F5
(D) Esc
2. What happens when you press Enter after entering data in a cell by default?
(A) Cursor moves right
(B) Cursor moves up
(C) Cursor moves down
(D) Cursor stays in same cell
3. Which type of data is left-aligned by default in Excel cells?
(A) Numbers
(B) Dates
(C) Text
(D) Currency
4. Which type of data is right-aligned by default in Excel cells?
(A) Text
(B) Numbers
(C) Labels
(D) Headings
5. Which feature allows long text to be displayed on multiple lines within the same cell?
(A) Merge Cells
(B) Wrap Text
(C) AutoFit
(D) Indent
6. Which option is used to combine two or more cells into one?
(A) Wrap Text
(B) AutoFill
(C) Align Center
(D) Merge Cells
7. Which option automatically adjusts the column width to fit the entered data?
(A) Wrap Text
(B) Orientation
(C) Merge
(D) AutoFit
8. Which shortcut key inserts the current date in a cell?
(A) Ctrl + ;
(B) Ctrl + Shift + ;
(C) Ctrl + D
(D) Alt + Enter
9. Which shortcut key is used to cancel data entry in a cell?
(A) Enter
(B) Esc
(C) Tab
(D) Shift
10. Which option changes the background color of a cell?
(A) Font Color
(B) Border
(C) Fill Color
(D) Cell Style
11. Which alignment places text in the center of a cell horizontally?
(A) Center Align
(B) Right Align
(C) Left Align
(D) Justify
12. Which option is used to rotate text within a cell?
(A) Orientation
(B) Wrap Text
(C) Merge Cells
(D) Indent
13. Which dialog box provides all cell formatting options?
(A) Page Setup
(B) Conditional Formatting
(C) Data Validation
(D) Format Cells
14. Which shortcut key applies bold formatting to cell contents?
(A) Ctrl + B
(B) Ctrl + U
(C) Ctrl + I
(D) Ctrl + F
15. Which shortcut key applies italic formatting to cell contents?
(A) Ctrl + B
(B) Ctrl + T
(C) Ctrl + U
(D) Ctrl + I
16. Which shortcut key applies underline formatting to cell contents?
(A) Ctrl + B
(B) Ctrl + U
(C) Ctrl + I
(D) Ctrl + D
17. Which option is used to add borders around a cell?
(A) Fill Color
(B) Font Color
(C) Alignment
(D) Border
18. Which feature copies formatting from one cell to another?
(A) AutoFill
(B) Wrap Text
(C) Cell Styles
(D) Format Painter
19. Which alignment option places text at the bottom of a cell vertically?
(A) Top Align
(B) Bottom Align
(C) Middle Align
(D) Center Align
20. Which option increases the indentation of text inside a cell?
(A) Orientation
(B) Increase Indent
(C) Wrap Text
(D) Merge Cells
21. Which shortcut key moves the cursor to the next cell on the right?
(A) Enter
(B) Shift + Enter
(C) Ctrl + Tab
(D) Tab
22. Which feature helps enter a series of data like numbers or days quickly?
(A) Sort
(B) AutoFill
(C) Filter
(D) Format Painter
23. Which formatting makes text thicker and darker?
(A) Italic
(B) Underline
(C) Strikethrough
(D) Bold
24. Which option clears all formatting from selected cells?
(A) Clear Formatting
(B) Clear Contents
(C) Delete
(D) Remove Style
25. Which option changes the font type of selected cell data?
(A) Font Size
(B) Font Name
(C) Font Style
(D) Font Color
26. Which option changes the size of text in a cell?
(A) Font Size
(B) Font Style
(C) Font Name
(D) Font Color
27. Which option aligns text to the right side of a cell?
(A) Left Align
(B) Right Align
(C) Center Align
(D) Justify
28. Which feature displays ###### when column width is insufficient?
(A) Text Format
(B) Narrow Column
(C) Cell Error
(D) Hidden Data
29. Which tab contains most data entry and cell formatting tools?
(A) Insert
(B) Data
(C) Home
(D) Review
30. What is the default font in MS Excel (modern versions)?
(A) Arial
(B) Times New Roman
(C) Calibri
(D) Verdana
31. Which option is used to change the color of text inside a cell?
(A) Fill Color
(B) Font Color
(C) Border Color
(D) Cell Style
32. Which alignment option places text at the top of a cell vertically?
(A) Center Align
(B) Middle Align
(C) Bottom Align
(D) Top Align
33. Which shortcut key moves the cursor to the cell above?
(A) Enter
(B) Tab
(C) Shift + Enter
(D) Ctrl + Enter
34. Which option is used to apply a predefined combination of formatting to a cell?
(A) Conditional Formatting
(B) Format Painter
(C) Themes
(D) Cell Styles
35. Which option allows numbers to be displayed with commas (e.g., 1,000)?
(A) Font
(B) Alignment
(C) Number Format
(D) Border
36. Which dialog box allows changing alignment, font, border, and fill together?
(A) Page Setup
(B) Data Validation
(C) Conditional Formatting
(D) Format Cells
37. Which option is used to decrease the number of decimal places shown in a cell?
(A) Decrease Decimal
(B) Increase Decimal
(C) Number Format
(D) AutoFit
38. Which shortcut key fills the selected cell with data from the cell above?
(A) Ctrl + R
(B) Ctrl + D
(C) Ctrl + C
(D) Ctrl + V
39. Which option changes the direction of text inside a cell?
(A) Wrap Text
(B) Indent
(C) Merge Cells
(D) Orientation
40. Which formatting option places a line below the text in a cell?
(A) Bold
(B) Italic
(C) Strikethrough
(D) Underline
41. Which option is used to increase row height manually?
(A) Drag row boundary
(B) AutoFit Row Height
(C) Wrap Text
(D) Merge Cells
42. Which option clears only the data but keeps formatting intact?
(A) Clear All
(B) Clear Formats
(C) Clear Contents
(D) Delete Cells
43. Which key is used to confirm data entry and remain in the same cell?
(A) Enter
(B) Ctrl + Enter
(C) Tab
(D) Shift + Enter
44. Which alignment option spreads text evenly across the width of a cell?
(A) Center
(B) Left
(C) Right
(D) Justify
45. Which option applies borders to the outside of selected cells only?
(A) All Borders
(B) Inside Borders
(C) Outside Borders
(D) Thick Border
46. Which feature repeats the last data entry action quickly?
(A) Repeat (F4)
(B) AutoFill
(C) Format Painter
(D) Paste Special
47. Which shortcut key opens the Format Cells dialog box?
(A) Ctrl + 1
(B) Ctrl + F
(C) Ctrl + Shift + F
(D) Alt + F
48. Which option is used to display negative numbers in red color?
(A) Font Color
(B) Conditional Formatting
(C) Number Format
(D) Cell Styles
49. Which feature allows entering the same data in multiple selected cells at once?
(A) AutoFill
(B) Format Painter
(C) Ctrl + Enter
(D) Wrap Text
50. Which option removes merged cells and restores them to individual cells?
(A) Split Cells
(B) Clear Formatting
(C) Unmerge Cells
(D) AutoFit
51. Which option allows text to overflow into adjacent empty cells?
(A) Default text display
(B) Merge Cells
(C) Wrap Text
(D) AutoFit
52. Which option hides cell contents without deleting them?
(A) Clear Contents
(B) Delete Cell
(C) Font Color (white)
(D) Hide Row/Column
53. Which alignment option places text in the center of a cell vertically?
(A) Top Align
(B) Justify
(C) Bottom Align
(D) Middle Align
54. Which option is used to increase the width of a column?
(A) AutoFit Column Width
(B) Wrap Text
(C) Drag column boundary
(D) Merge Cells
55. Which shortcut key applies strikethrough formatting to selected cells?
(A) Ctrl + S
(B) Ctrl + T
(C) Ctrl + U
(D) Ctrl + 5
56. Which option repeats text automatically while typing similar entries?
(A) AutoComplete
(B) AutoFill
(C) Flash Fill
(D) Repeat
57. Which option allows text to be displayed at an angle inside a cell?
(A) Wrap Text
(B) Indent
(C) Merge Cells
(D) Orientation
58. Which option clears both data and formatting from selected cells?
(A) Clear Contents
(B) Clear All
(C) Clear Formats
(D) Delete Cells
59. Which alignment option places text at the left side of a cell?
(A) Center Align
(B) Right Align
(C) Left Align
(D) Justify
60. Which shortcut key is used to move to the next cell below?
(A) Tab
(B) Shift + Tab
(C) Enter
(D) Ctrl + Enter
61. Which option displays numbers as currency symbols?
(A) Font
(B) Number Format
(C) Border
(D) Alignment
62. Which option is used to apply a thick border around selected cells?
(A) Outside Borders
(B) All Borders
(C) Inside Borders
(D) Thick Border
63. Which feature copies only formatting and not data?
(A) AutoFill
(B) Paste Special
(C) Format Painter
(D) Flash Fill
64. Which option allows reducing indentation inside a cell?
(A) Increase Indent
(B) Orientation
(C) Decrease Indent
(D) Wrap Text
65. Which shortcut key moves the cursor to the previous cell on the left?
(A) Enter
(B) Tab
(C) Shift + Tab
(D) Ctrl + Tab
66. Which option displays text with a line through it?
(A) Strikethrough
(B) Italic
(C) Bold
(D) Underline
67. Which option increases the number of decimal places displayed?
(A) Increase Decimal
(B) Decrease Decimal
(C) Number Format
(D) AutoFit
68. Which feature allows changing row height automatically to fit content?
(A) AutoFit Row Height
(B) Wrap Text
(C) Merge Cells
(D) Orientation
69. Which option allows text to be aligned to both left and right margins?
(A) Center
(B) Left
(C) Right
(D) Justify
70. Which option removes all cell styles from selected cells?
(A) Clear Contents
(B) Clear Formatting
(C) Delete Cells
(D) Remove Borders