Exam 17: Excel 2007 Unit C: Formatting a Worksheet

Formatting can change the actual data of a cell.

Cells and ranges in a worksheet can be formatted ____.

The ____________________ is the box at the top of each column containing a letter.

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.

As shown in the figure above, item ____ points to the button that underlines text.

As shown in the figure above, item 1 is the ____ list arrow.

You are the administrator of a small hospital. You have been asked by some governmental agencies to keep track of the average waiting times for some of the types of procedures being performed at the hospital. You have created the following worksheet for this purpose. You realize that you have left an empty row, row 7, in the middle of the data by mistake. Write the procedure for deleting row 7.

The Spelling button is found in the Proofing group on the ____ tab on the Ribbon.

____________________ refers to images such as a corporate logo, a picture, or a photo.

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

You are the administrator of a small hospital. You have been asked by some governmental agencies to keep track of the average waiting times for some of the types of procedures being performed at the hospital. You have created the following worksheet for this purpose. You have been asked by the government to highlight all the procedures in which the waiting time is greater than 10 days. Write the procedure for doing this using conditional formatting.

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 by using the Border and Fill Color buttons in the Font group on the ____ tab of the Ribbon.

With Excel, you can adjust the width of one or more columns by using the Ribbon.

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

Explain conditional formatting.

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

The Increase Decimal button automatically adds dollar signs and two decimal places to your data.

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

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

You must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells.