1. How can you format a cell to display numbers with two decimal places?
- A) Use the Number Format dropdown in the Home tab and select “Number” with two decimal places
- B) Apply the “Currency” format
- C) Enter the number manually with two decimal places
- D) Use the “Text” format and type the decimal places
Answer: A) Use the Number Format dropdown in the Home tab and select “Number” with two decimal places
2. Which of the following formats will display the cell content as a percentage?
- A) Number > Percentage
- B) Currency > Percentage
- C) Text > Percentage
- D) Custom > Percentage
Answer: A) Number > Percentage
3. How can you format a cell to display dates in the “DD/MM/YYYY” format?
- A) Use the Format Cells dialog box and select “Date” with the desired format
- B) Type the date manually in the desired format
- C) Use the Custom format option and enter “DD/MM/YYYY”
- D) Both A and C
Answer: D) Both A and C
4. To apply bold formatting to text within a cell, you should:
- A) Use the Bold button in the Home tab
- B) Press Ctrl + B
- C) Use the Format Cells dialog box to select “Bold”
- D) All of the above
Answer: D) All of the above
5. What is the effect of using the “Text” format on a cell in Excel?
- A) Numbers are treated as text and not used in calculations
- B) The text is automatically bolded
- C) The text is aligned to the right
- D) The cell content is displayed in uppercase
Answer: A) Numbers are treated as text and not used in calculations
6. How do you apply a currency format to a cell, showing the currency symbol and two decimal places?
- A) Use the Format Cells dialog box and select “Currency”
- B) Use the Number Format dropdown and choose “Currency”
- C) Apply the “Accounting” format
- D) Both A and B
Answer: D) Both A and B
7. How can you change the format of a cell to display time in “HH
AM/PM” format?
- A) Use the Format Cells dialog box and select “Time” with the desired format
- B) Type the time manually in “HH
AM/PM” format
- C) Use the Custom format option and enter “HH
AM/PM”
- D) Both A and C
Answer: D) Both A and C
8. Which of the following options will allow you to format cells to show a negative number in red?
- A) Use the Format Cells dialog box and select “Number” with the red color for negative values
- B) Use Conditional Formatting to set the color for negative numbers
- C) Use the Font color option to manually change the color of negative numbers
- D) Both A and B
Answer: D) Both A and B
9. To display a number with thousand separators (e.g., 1,000), which format should you use?
- A) Number format with “Use 1000 Separator (,)”
- B) Currency format
- C) Accounting format
- D) Custom format with a thousand separator
Answer: A) Number format with “Use 1000 Separator (,)”
10. What does the “Custom” format option in the Format Cells dialog box allow you to do?
- A) Create a unique format for numbers, dates, and text not available in standard options
- B) Apply predefined styles to cells
- C) Automatically adjust the cell size based on content
- D) Change the cell’s background color
Answer: A) Create a unique format for numbers, dates, and text not available in standard options