Exam 4: Excel Lesson 2: Formatting and Editing Worksheets

The Find and Replace commands are two separate commands that are often used together.

If you click the Insert Sheet Rows command, a new row will be inserted ____ the current selection.

A background color or pattern in a cell is referred to as a(n) ____________________.

Case EX 2-2 Iris has created an invoice using Excel. Now she needs to alter the structure of the worksheet by making changes to the rows and columns. When Iris deletes rows or columns from her worksheet, the rows beneath the deleted row and the columns to the right of the deleted column automatically shift ____ to fill the space.

Borders can be applied to any side of a cell using predefined styles or by creating custom borders.

Each time you enter a number in a cell, Excel automatically applies the Currency format.

Clicking the dialog box launcher in which group on the Home tab of the Ribbon will display the Format Cells dialog box?

Font effects are changes in the shape or weight of a font's character, such as bold and italic.

You can change a cell's background color using the ____ button in the Font group on the Home tab.

You can click the Find & Replace button in the Editing group on the Home tab to access the Find and Replace commands.

If you want to add formatting to more than one cell, you can double-click the Format Painter button so that it stays active.

You can use the ____ button to replace all occurrences of data at once without confirming each instance.

What is displayed as you drag the border of a column heading to a new width?

When you create a new workbook, columns are set to a default width of ____ characters.

A defined combination of formatting characteristics--such as number, alignment, font, border, and fill--is called a(n) ____________________.

The Paste button menu offers a variety of ways to paste copied data, such as pasting only formats, pasting only values, or pasting all contents except the borders.

The ____ available are determined by which theme has been applied to the workbook.

The commands for working with rows and columns are located in the ____ group on the Home tab.

On the Home tab in the Editing group, you can click the Clear button and then click ____ to remove all of the formatting that has been applied to the selected cell.

FIGURE EX 2-1 In Figure EX 2-1 above, the data is being copied from cell ____.