MCQs on Data Entry and Formatting | Excel MCQ Questions

Data entry and formatting are crucial skills when working with spreadsheets. This chapter focuses on practical aspects such as entering and editing data, using AutoFill and Flash Fill, formatting cells (including fonts, borders, and alignment), applying number formatting, and understanding conditional formatting basics. Master these skills to improve your spreadsheet workflow.

Topic 1: Entering Data and Editing Cells

1. Which of the following is the default method to enter data into a cell in Excel?
   a) Type and press Enter
   b) Right-click and paste
   c) Click and drag
   d) Double-click the cell
2. How do you edit the content of an already entered cell in Excel?
   a) Right-click and choose “Edit”
   b) Press the F2 key
   c) Press Ctrl + Z
   d) Double-click the cell
3. What is the purpose of the “Undo” function in Excel?
   a) To delete the last entry
   b) To delete the last row
   c) To reverse the last action
   d) To clear all data
4. What happens if you press “Enter” after entering data into a cell?
   a) The data is saved and the cell is locked
   b) The cursor moves to the next column
   c) The data is automatically formatted
   d) The cursor moves to the next row
5. What is the shortcut to delete data from a selected cell?
   a) Ctrl + C
   b) Ctrl + D
   c) Delete key
   d) Shift + D
6. When you copy a cell in Excel, which of the following is copied?
   a) Only the data
   b) Data and formatting
   c) Only the formula
   d) Data and column width
7. What happens if you press “Ctrl + V” in Excel?
   a) Paste the copied data
   b) Paste the data in reverse order
   c) Undo the last action
   d) Clear the selected cell
8. To enter the same data in multiple cells at once, which feature can you use?
   a) AutoFill
   b) Flash Fill
   c) Fill Handle
   d) Conditional Formatting
9. How do you cancel an ongoing data entry in a cell?
   a) Press Esc
   b) Press Delete
   c) Press Enter
   d) Right-click and select Cancel
10. Which of the following methods is used to add a new row to a worksheet?
    a) Press Ctrl + Shift + R
    b) Right-click on a row and select “Insert”
    c) Use the AutoFill tool
    d) Press F2

Topic 2: Using AutoFill and Flash Fill

11. What is the AutoFill feature used for in Excel?
    a) To automatically format a cell
    b) To quickly fill a range of cells with data
    c) To delete empty cells
    d) To calculate sums automatically
12. What happens when you drag the fill handle across a range of cells?
    a) It copies the data to the range
    b) It fills the cells with the same data type
    c) It auto-formats the cells
    d) It highlights the cells
13. Which of the following can be automatically completed using the AutoFill feature?
    a) Number series
    b) Random text
    c) Formatting styles
    d) Conditional formatting rules
14. What is the Flash Fill feature used for?
    a) To remove formatting from a cell
    b) To fill in data based on patterns
    c) To merge multiple cells
    d) To create charts based on data
15. How can you activate Flash Fill in Excel?
    a) Press Ctrl + Shift + F
    b) Type the pattern and press Enter
    c) Type the pattern and press Ctrl + E
    d) Press Alt + F
16. If you start typing “John” and “Jane” in the next cell, what will Flash Fill do?
    a) It will fill the column with random names
    b) It will try to auto-complete the pattern of names
    c) It will insert numbers sequentially
    d) It will add a color gradient
17. Which of the following does Flash Fill NOT work for?
    a) Merging names
    b) Splitting a full name into first and last names
    c) Creating a formula
    d) Formatting phone numbers
18. Can AutoFill be used to copy data across multiple worksheets?
    a) Yes
    b) No
    c) Only with numeric data
    d) Only with dates
19. What is a common issue when using AutoFill for dates?
    a) The dates are copied as text
    b) The dates don’t increment correctly
    c) The dates get deleted
    d) AutoFill doesn’t work for dates
20. Flash Fill is available in which version of Excel?
    a) Excel 2003
    b) Excel 2010 and earlier
    c) Excel 2013 and later
    d) Excel 2016 only

Topic 3: Cell Formatting (Fonts, Colors, Borders, Alignment)

21. Which option allows you to change the font style in Excel?
    a) Format Cells > Font
    b) View > Font
    c) Insert > Font
    d) Home > Styles
22. How can you change the background color of a cell in Excel?
    a) Home > Fill Color
    b) Right-click and select “Background”
    c) Format > Cell Color
    d) View > Background
23. What does the “Alignment” option in the Format Cells dialog box allow you to do?
    a) Change text size
    b) Align text within a cell
    c) Change font style
    d) Apply conditional formatting
24. Which of the following can you set using the “Borders” feature in Excel?
    a) Font style
    b) Background color
    c) Cell border style
    d) Alignment position
25. How do you make text bold in a cell?
    a) Right-click and select “Bold”
    b) Use the “B” button in the Home tab
    c) Press Ctrl + B
    d) Both b and c
26. Which of the following options allows you to center text across multiple cells?
    a) Merge and Center
    b) Text Centering
    c) Center Across Selection
    d) Align Center
27. How can you add a border around a selected cell?
    a) Use the “Borders” dropdown in the Home tab
    b) Right-click and select “Borders”
    c) Use the Format Cells dialog box
    d) All of the above
28. What happens when you apply the “Wrap Text” option to a cell?
    a) The text wraps within the same cell
    b) The text is deleted
    c) The cell is automatically merged with others
    d) The font style changes
29. To apply different font colors to specific parts of a cell’s content, which option should you use?
    a) Format Cells > Font
    b) Conditional Formatting
    c) Text Color
    d) Cell Formatting
30. How can you quickly clear the formatting from a cell?
    a) Right-click and select “Clear Formats”
    b) Press Ctrl + F
    c) Press Ctrl + Z
    d) Click “Clear All” in the Ribbon

Answers