Microsoft Excel Formatting MCQs - Test Your Knowledge

Difficulty Levels: Beginner ✅

Topic: Formatting in Microsoft Excel

📝 Multiple Choice Questions

1. What is the purpose of a cell format?

   • To change the appearance of a cell
   • To protect a cell from being changed
   • To add a formula to a cell
   • None of the above

2. Which of the following is NOT a valid font style in Excel?

   • Bold
   • Italic
   • Underline
   • None of the above

3. Which of the following is NOT a valid number format in Excel?

   • Currency
   • Date
   • Percentage
   • Text
   • None of the above

4. What is the primary function of the Format Painter tool in Excel?

   • To copy and paste formatting from one cell or range of cells to another.
   • To apply a specific font style to a selected range of cells.
   • To adjust the alignment of text within cells.
   • To change the border style of selected cells.

5. What is the advantage of using the Format Painter tool compared to manually applying formatting to multiple cells?

   • It saves time and effort when applying consistent formatting to multiple cells.
   • It allows you to apply a wider range of formatting options than are available in the Format Cells dialog box.
   • It ensures that all formatting is applied differently to all selected cells.
   • It allows you to preview the formatting changes before applying them to the selected cells.

6. What happens to the contents of the other cells when you merge two or more cells?

   • The contents of the other cells are copied to the merged cell.
   • The contents of the other cells are moved to the merged cell.
   • Merging cells only keeps the upper-left value and discards other values.
   • The contents of the other cells remain unchanged.

7. What is the purpose of using Merge and Center in Excel?

   • To combine two or more cells into a single cell.
   • To center the text in a cell.
   • To do both of the above.
   • Neither of the above.

8. What is the purpose of wrapping text in Excel?

   • To make text fit within the width of a cell
   • To change the font of text
   • To add a border to cells
   • To protect cells from being edited

9. What happens when you wrap text in Excel?

   • The text is moved to a different cell.
   • The text is hidden.
   • The text is displayed on multiple lines within the same cell.
   • The text is deleted.

10. What is the effect of wrapping text on the row height?

    • The row height decreases.
    • The row height increases.
    • The row height remains the same.
    • The row height varies depending on the amount of text in the cell.

11. Which of the following is the default alignment for text in Excel cells?

    • Left
    • Right
    • Center
    • Justify

12. Which of the following number formats is used to display numbers with decimal places?

    • General
    • Number
    • Currency
    • Accounting

13. Which of the following number formats is used to display numbers as percentages?

    • General
    • Number
    • Currency
    • Percentage

14. Which of the following number formats is used to display negative numbers in red?

    • General
    • Number
    • Currency
    • Accounting

15. What is the default font in Excel?

    • Arial
    • Calibri
    • Times New Roman
    • Courier New

16. How can you make a font bold in Excel?

    • Use the keyboard shortcut Ctrl+D.
    • Use the keyboard shortcut Ctrl+B.
    • Use the keyboard shortcut Ctrl+I.
    • Use the keyboard shortcut Ctrl+U.

17. Which of the following font sizes is best for body text?

    • 10
    • 12
    • 14
    • 16
    • 18

18. Which of the following options allows you to add borders to cells in Excel?

    • Fill Color
    • Border button in the Home tab
    • Merge Cells
    • Text Orientation

19. To change the background color of a cell in Excel, you can use the _____ option in the Home tab.

    • Font Color
    • Fill Color
    • Cell Styles
    • Alignment

20. Which of the following is used to adjust the width of a column in Excel?

    • Resize Column
    • AutoFit Column Width
    • Format Cells
    • Wrap Text

21. Which of the following is used to display numbers with commas for thousands in Excel?

    • Currency Format
    • Accounting Format
    • Number Format
    • Comma Style

22. What is the keyboard shortcut to format cells in Excel?

    • Ctrl + Shift + F1
    • Ctrl + 1
    • Alt + F4
    • Ctrl + Alt + Delete

23. What is the purpose of the 'Merge & Center' function?

    • To align text to the right.
    • To combine selected cells into one larger cell and center the content.
    • To apply a background color.
    • To change the font color.

24. Which tab in Excel contains the "Cell Styles" option for quick formatting?

    • Insert
    • Data
    • Home
    • Formulas

25. The keyboard shortcut to apply Strikethrough formatting in Excel is ________.

    • Ctrl + 5
    • Ctrl + D
    • Ctrl + T
    • Alt + S

🗝️ Answer Key

1. To change the appearance of a cell
2. None of the above
3. None of the above
4. To copy and paste formatting from one cell or range of cells to another.
5. It saves time and effort when applying consistent formatting to multiple cells.
6. Merging cells only keeps the upper-left value and discards other values.
7. To do both of the above.
8. To make text fit within the width of a cell
9. The text is displayed on multiple lines within the same cell.
10. The row height increases.
11. Left
12. Number
13. Percentage
14. Currency
15. Calibri
16. Use the keyboard shortcut Ctrl+B.
17. 12
18. Border button in the Home tab
19. Fill Color
20. AutoFit Column Width
21. Comma Style
22. Ctrl + 1
23. To combine selected cells into one larger cell and center the content.
24. Home
25. Ctrl + 5

📚 Related Resources

• Microsoft Excel Formatting