1. How do you enter data into a cell in Excel?
- A) Double-click the cell and type
- B) Press F2 and type
- C) Click the cell and start typing
- D) All of the above
Answer: D) All of the above
2. What is the default alignment for text in a cell in Excel?
- A) Center
- B) Right
- C) Left
- D) Justified
Answer: C) Left
3. How can you apply a number format to a cell, such as currency or percentage?
- A) Use the Format Cells dialog box
- B) Right-click the cell and select “Format Cells”
- C) Use the Number Format dropdown in the Home tab
- D) All of the above
Answer: D) All of the above
4. Which of the following is a valid Excel date format?
- A) MM/DD/YYYY
- B) YYYY-MM-DD
- C) DD-MM-YYYY
- D) All of the above
Answer: D) All of the above
5. How can you quickly clear the formatting from a cell?
- A) Use the Clear Formats option in the Home tab
- B) Press Ctrl + Z
- C) Right-click the cell and choose “Clear Contents”
- D) Use the Format Painter
Answer: A) Use the Clear Formats option in the Home tab
6. What feature allows you to automatically fill a series of numbers or dates in Excel?
- A) AutoFill
- B) Flash Fill
- C) Fill Handle
- D) Series Fill
Answer: C) Fill Handle
7. How can you apply conditional formatting to a cell based on its value?
- A) Use the Conditional Formatting option in the Home tab
- B) Use the Format Cells dialog box
- C) Apply a cell style
- D) Use the AutoFormat option
Answer: A) Use the Conditional Formatting option in the Home tab
8. How do you wrap text within a cell so that it appears on multiple lines?
- A) Use the Wrap Text option in the Home tab
- B) Press Alt + Enter
- C) Adjust the row height manually
- D) Use the Format Cells dialog box to adjust alignment
Answer: A) Use the Wrap Text option in the Home tab
9. Which of the following options allows you to apply a predefined style to a cell?
- A) Cell Styles in the Home tab
- B) Format Painter
- C) Conditional Formatting
- D) Number Format dropdown
Answer: A) Cell Styles in the Home tab
10. To ensure that a cell’s content does not overflow into adjacent cells, you should:
- A) Use the Shrink to Fit option in the Format Cells dialog box
- B) Apply cell borders
- C) Merge cells
- D) Adjust the column width manually
- Answer: A) Use the Shrink to Fit option in the Format Cells dialog box