Excel Home Ribbon Quiz

Which feature allows you to change the font style, size, and color of the text in Excel?

• Alignment Group

• Font Group

• Editing Group

• Styles Group

In the Home Ribbon, which of the following formatting options is used to make the text bold?

• Ctrl + I

• The Bold button in the Font Group

• Ctrl + U

• The Fill Color button

Which of the following options allows you to apply pre-set formatting styles to cells?

• Styles Group → Cell Styles

• Font Group → Font Color

• Alignment Group → Merge & Center

• Number Group → Format Cells

What is the function of the 'AutoSum' button in the Editing group on the Home Ribbon?

• It automatically adds a number format to cells

• It calculates the sum of selected cells

• It increases the decimal places of numbers

• It merges cells and sums the text content

The Fill Color button in the Font group allows you to change the background color of selected cells.

• True

• False

What does the 'Cell Styles' feature allow you to do?

• Automatically sum a range of numbers

• Change the font size and color

• Apply pre-defined formats such as titles, headings, or warnings to cells

• Adjust the height and width of cells

Cell styles allow you to quickly apply multiple formatting options, including font, fill color, and borders.

• True

• False

The 'Calculation' style in the Cell Styles menu is used to highlight cells where calculations occur.

• True

• False

Where can you find Excel templates when starting a new workbook?

• In the File tab under New

• In the Insert tab under Charts

• In the View tab under Workbook Views

• In the Home tab under Clipboard

Which of the following is an example of a commonly used Excel template?

• Income Statement

• Pivot Table

• Solver Add-In

• Conditional Formatting