Excel Module 3

Double-clicking the column line to the right of a column activates the _____ features for the column.

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the _____ dialog box.

You can change the ____ of labels and values in cells to be left, right, or center.

The default Accounting number format adds dollar signs and ____ decimal places to the data.

The _____ size is the physical size of the text.

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

If you create a conditional formatting rule you can modify it using the Conditional Formatting ____.

The default format for cells that meet a condition with conditional formatting is _____.

The Find & Select button is found in the Editing group on the _____ tab on the Ribbon.

You can apply font styles and alignment options using the ____ tab of the Ribbon.

The spelling button is found in the Proofing group on the _____ tab on the Ribbon.

Which of the following removes only the contents of a selected row or column?

You can apply font styles and alignment options using the _____ dialog box.

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.

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

Cell ____ are predesigned combinations of formats.

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.

The Format Painter button is found in the ____ group on the Home tab of the Ribbon.

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

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

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

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

Cells and ranges in a worksheet can be formatted _____.

To remove all formatting for a selected range, click the _____ button in the Editing group on the Home tab.

A _____ is an individual media file, such as art, sound, animation, or a movie.

You can use colors, patterns, and borders to enhance the overall appearance of a worksheet and to make it easier to read. One of the ways of adding these enhancements is to use the Borders, Font Colors, and Fill Color buttons in the Font group on the ____ tab of the Ribbon.

To hide a selected column the _____ button in the Cells group on the Home tab.

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

You insert a comment in a worksheet by using a command on the ____ tab on the Ribbon.

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

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