Exam 13: Formatting a Worksheet

Case 13-1 Jim is copying and pasting formulas from one area of a worksheet to another. Please answer the questions below. -Jim is copying a formula from cell C3 to cell F3 and wants the cell references to change accordingly.He is wanting to create a(n) ____ reference.

A(n) ____________________ reference does not change, and will always refer to the same cell, even after the formula is copied or moved.

____ options allow you to select a decorative line style or to make all the border lines appear in a selected color.

You can use buttons in the Font group on the Edit tab to select different font attributes for any data in worksheet cells._________________________

To delete one or more columns, select the column or columns, click the down-arrow button next to Delete in the ____ group, then click Delete Sheet Columns.

A workbook-sometimes called a "3D workbook"-is a collection of ____.

You insert a new worksheet by left-clicking the tab for the worksheet that should immediately follow the new worksheet.

To manually adjust the width of a column, position the pointer over the vertical line between two column headings so that the pointer changes to a shape.____ while you drag the vertical line left or right to manually adjust the width of the column.

Borders and background colors define areas of a worksheet and call attention to important information.

You can use the Font group on the Home tab and ____ dialog box to add borders and a colored background to one or more cells.

To select all cells in a row, click the row header on the left side of the row._________________________

Insert a new worksheet by ____ the tab for the worksheet that should immediately follow the new worksheet.Select Insert from the shortcut menu, then make a selection from the Insert dialog box.

Typically, you'll want to ____ the headings for columns of numbers.

-In the figure above, the word Description is centered as a column heading.This was accomplished by clicking the Center button in the ____ group.

Delete an existing worksheet by right-clicking the worksheet's tab and clicking ____.

The Percent Style button displays cell contents as a percentage, which means .35 is displayed as ____.

To create a(n) relative reference, insert a dollar sign ($) before the column reference and another dollar sign before the row reference._________________________

To merge a range of cells in a column, select the range of cells, then click the Merge & Center button in the Alignment group on the ____ tab.

The Money Number Format button displays cell contents in your local currency format._________________________

The ____ button adds borders between individual cells.