A) Press Ctrl + ; (semicolon) B) Press Ctrl + Shift + D C) Type =TODAY() and press Enter D) Use the Insert Date option from the Home tab
To automatically fill a series of dates or numbers, you should use:
A) AutoFill Handle B) Fill Series Command C) Flash Fill D) Data Validation
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
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
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
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
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
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
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
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
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
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
What is the purpose of conditional formatting in Excel?
A) To apply formatting based on specific conditions or criteria B) To automatically sort data in a worksheet C) To create charts and graphs D) To protect cells from being edited
How can you apply conditional formatting to highlight cells that are greater than a specific value?
A) Use the “Highlight Cell Rules” option in the Conditional Formatting menu B) Apply a cell style manually C) Use the “Data Bars” option D) Use the “Color Scales” option
Which of the following options allows you to apply a color scale to a range of cells?
A) Color Scales in Conditional Formatting B) Icon Sets in Conditional Formatting C) Data Bars in Conditional Formatting D) Highlight Cell Rules in Conditional Formatting
How can you use conditional formatting to highlight duplicate values in a range?
A) Use the “Duplicate Values” option in the Conditional Formatting menu B) Use the “Top/Bottom Rules” option C) Apply a custom formula D) Use the “Data Bars” option
Which of the following conditional formatting features allows you to apply different icons based on cell values?
A) Icon Sets B) Color Scales C) Data Bars D) Highlight Cell Rules
To create a custom conditional formatting rule based on a formula, you should:
A) Use the “Use a formula to determine which cells to format” option in Conditional Formatting B) Apply a built-in rule from the Conditional Formatting menu C) Use the “Manage Rules” option D) Use the “Clear Rules” option
How can you remove conditional formatting from a range of cells?
A) Use the “Clear Rules” option in the Conditional Formatting menu B) Use the “Delete” option in the Conditional Formatting menu C) Press Ctrl + Z D) Change the cell format manually
Which conditional formatting feature would you use to apply formatting to the top 10 values in a range?
A) Top/Bottom Rules B) Color Scales C) Data Bars D) Icon Sets
How can you manage multiple conditional formatting rules applied to the same range?
A) Use the “Manage Rules” option in the Conditional Formatting menu B) Apply rules one by one in the Conditional Formatting menu C) Use the “Clear Rules” option to start over D) Edit each rule directly in the cell
What does the “Data Bars” option in Conditional Formatting do?
A) Adds bars to cells to represent the relative size of values B) Colors cells based on their values C) Adds icons to cells based on their values D) Highlights cells with duplicate values
