Exam 8: Excel 3: Formatting a Worksheet

In the ____ window you can search for online pictures (or Clip Art) in Office.com, through the Bing search engine, or on OneDrive.

Explain conditional formatting.

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon.

You can change the font and font size of any cell or range using the Mini toolbar.

###### in a cell means that the ____.

You can add multiple worksheets to a workbook by clicking the Home tab on the Ribbon, pressing and holding ____, and then clicking the number of existing worksheet tabs that correspond with the number of sheets you want to add, clicking the Insert list arrow in the Cells group on the Home tab, then clicking Insert Sheet.

Font ____ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet.

Discuss inserting or adjusting online pictures and other images in Excel.

When do you apply formatting to a cell or range?

The ____ of a cell determines how the labels and values look.

To check the spelling in more than one sheet of a multiple-sheet workbook, you need to display each sheet and run the spelling checker again.

What does the Format Painter button do?

To format a cell or range, first you select it, and then you apply the formatting using the ____, the Mini toolbar, or a keyboard shortcut.

A small, ____ triangle appears in the upper-right corner of a cell containing a comment.

Using the mouse, you can drag or double-click the right edge of a column heading to change the column width . _________________________

____ shows you how a fill color will look before you apply it.

____ formatting is automatically updated if you change data in the worksheet.

Double-clicking the right edge of a column heading activates the AutoSize feature which automatically resizes  the column to accommodate the w​idest entry in the column. ____________________

To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the Home tab, and then click a style in the gallery.