Exam 13: Formatting a Worksheet

Pressing the ____ key changes a cell reference to an absolute reference.

Excel treats all cell references as ____________________ references unless you specify otherwise.

The ____ button puts a border around the outside edges of selected cells.

To change the width of a cell, you must increase the width of the entire column.

To insert more than one row at a time, drag down over the number of rows you want to insert.Click the down-arrow button next to Insert in the ____________________ group, then click Insert Sheet Rows to insert the new rows.

A cell reference that changes when a formula is copied or moved is called a(n) ____ reference.

If you want to modify characteristics of the new style, click the Format button to open the ____ Cells dialog box.

Case 13-1 Jim is copying and pasting formulas from one area of a worksheet to another. Please answer the questions below. -In several areas of the worksheet, Jim uses absolute references.The correct format for an absolute reference is ____.

To quickly select all cells in a column, click the column ____________________ at the top of the column.

The most commonly used number formats are available as buttons in the Formatgroup on the Home tab._________________________

The ____ button allows you to copy and paste formats from one cell to another.

-In the figure above, the word Invoice is centered across columns A through E.This was accomplished by using the Merge & Center button in the ____ group.

Pressing the F5 key changes a cell reference to an absolute reference._________________________

-In order to display the Format Cells dialog box shown in the figure above, you would click the Format Cells Dialog Box Launcher in the ____ group.

You can apply multiple font attributes to any worksheet cell.