Additional Formatting Options

What is a table in Excel?

a group of related data without any spaces between cells

Which task would the Format Painter be most helpful in completing?

copying the formatting from a cell and applying it to other cells

Which tasks can be completed using the Rules Manager? Check all that apply.

creating a new rule editing an existing rule deleting a rule

What are styles?

predefined combinations of formatting

Use the drop-down menus to complete the steps necessary for creating a rule that is not already an option.

1. On the Home tab, click the Styles group. 2. On the drop-down list, click Conditional Formatting, and then click New Rule. 3. Use the dialog box to create a rule.

Use the drop-down menu to complete the steps for editing a rule.

1. On the Home tab, click the Styles group. 2. On the Styles drop-down list, click Manage Properties. 3. In the dialog box, select the rule, and then click Edit Rule. 4. Make the changes to the rule, and click OK.

Use the drop-down menus to complete the steps for using the Find and Replace feature.

1. On the Home tab, in the Editing group, click Find and Select, and on the drop-down list click Replace. 2. In the dialog box, click the Options button, and choose the items to Find and Replace. 3. Click Replace or Replace All.

Use the drop-down menus to complete the steps for copying and applying formatting with the Format Painter.

1. Select the cell or cells with the formatting you want to copy. 2. On the Home tab, in the Clipboard group, click Format Painter. 3. Click or click and drag to select the cell or cells you want to apply the formatting to.

Use the drop-down menus to complete the steps for completely clearing formatting from a cell or range of cells.

1. Select the cell or range of cells. 2. In the Editing group, click the drop-down arrow next to the Clear button, and choose Clear Formats.

Use the drop-down menus to complete the steps for creating a table in Excel.

1. Select the cell or range. 2. On the Home tab, click the Styles, and then click Format As Table. 3. Select a table format. 4. In the dialog box, enter the range of the table and click OK. 5. Use the Table Style options and other groups on the Ribbon as needed. 6. Click anywhere in the worksheet to close the Table Tools Design tab.

Use the drop-down menus to complete the steps for copying and applying formatting with the AutoFill feature.

1. Select the cell with the formatting you want to copy. 2. Use the AutoFill handle to drag over the cells you want to apply formatting to. 3. Click the X Format Painter button in the Clipboard group AutoFill Options drop-down list, and then click Fill Formatting Only.

What is an example of conditional formatting?

Cells in a range with values under 10 have a red background.

Practice using formatting options in Excel using this document.

Complete each sentence. The first part of Step 1 involves clicking Styles. An option for Step 3 is edit a rule. The two options identified in Step 12 can both be found in the Editing group under the Home tab.

After completing Step 4, which cells will be yellow?

D20 and D22

What is one way to complete Step 11?

Select the data, click Home, click Styles, click Format as table, then select the table option.

Which tasks can be completed using the Cell Style gallery? Check all that apply.

choosing the look of a worksheet controlling number formatting

What are some areas to fill out in the New Formatting Rule dialog box? Check all that apply.

rule type condition format

What are ways how you can view and organize the data in a table? Check all that apply.

sorting filtering