Exam 13: Formatting a Worksheet

You can use the Cut, Copy, and Paste buttons in the ____ group on the Home tab to copy and move cell contents to a different worksheet location.

To change the alignment of a range of cells, select the range of cells, then click the desired alignment button from the Alignment group on the Edit tab.

As you insert and delete rows and columns, Excel adjusts relative cell references in formulas to keep them accurate._________________________

You can create your own styles for numbers or text.Click the Styles button in the ____ group, click the More button on the Styles list, then click New Cell Style.Type the new style name.

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

Click the tabs ____ of the screen to navigate through the worksheets.

Case 13-1 Jim is copying and pasting formulas from one area of a worksheet to another. Please answer the questions below. -Jim has noticed that when it comes to the column totals, he wants those formulas to remain the same, even when copied.He is wanting to create a(n) ____ reference.

As with Microsoft Word, Excel allows you to work with either predefined or custom ____.

To create an absolute reference, insert ____.

If you copy or move the data in a range of cells, the pasted data is positioned above and to the left of the active cell.

To view available formats, click the Styles button in the Styles group, then click the ____ button or click the More button on the Styles list.

You can create mixed references by combining references so that only one of the column or row references is absolute.

In addition to font attributes, you can also apply ____________________ formats-currency, percent, commas, and decimals-to cells that contain values.

You can select a row by clicking the row identifier button on the left side of the window.

-Referring to the figure above, to apply the number format chosen in the dialog box, you would ____.

The ____ option allows you to change the order of worksheets.

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

To insert one or more columns, select the column or columns, click the down-arrow button next to Insert in the Cells group, then click ____________________.

To move the data in cells, select the cells, then click the Cut button.Click the cell where you want to paste the data, then click the Paste button._________________________

You can quickly add borders using the Borders button in the ____ group on the Home tab.