Module 3 Questions

Where on the ribbon will you find cell styles?

• Home tab, Font group
• Page Layout tab, Themes group
• Home tab, Styles group
• Insert tab, Illustrations group

Where would you use Headings cell styles? Select all that apply.

• Cells at the top of a column of data
• Cells that label rows of data
• Cells that contain totals
• Cells that contain comments

Cell styles can help you to ________________. Select all that apply.

• Keep consistency in formatting
• Make your worksheets easier to read
• Apply formatting more quickly
• Perform calculations

Which of the following styles are built-in cell styles in Excel? Select all that apply.

• Calculation
• Chart
• Warning Text
• Comma

If you have a cell at the bottom of a column that adds up all the numbers in the column, you might apply the ___________________ cell style.

• Avg
• Count
• Max
• Total

What kinds of formatting can be included in cell styles? Select all that apply.

• Font Size
• Margins
• Fill Color
• Text Alignment

When you need a selection of cells to have only the original default formatting, you should use the ______________ command.

• Clear formats
• Clear all
• Clear contents
• Clear

The types of alignment for contents of a cell include:

• Horizontal
• Vertical
• Italic
• Rotation

To display text in a cell turned on its side or on an angle, you change the _______________.

• Position
• Orientation
• Wrapping
• Margins

You can align cell contents centered over multiple columns with _______________.

• Center and clear
• Center
• Merge & Center and Center Across Selection