Question

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

On the ___ tab, click the ___ group. On the Styles drop-down list, click ______. In the dialog box, select the rule, and click ________. Make the changes to the rule and click ok.

Answer 1

Answer:

1. Home

2. Conditional formatting.

3. Manage rules.

4. Edit.

Explanation:

A spreadsheet can be defined as a file or document which comprises of cells in a tabulated format (rows and columns) typically used for formatting, arranging, analyzing, storing, calculating and sorting data on computer systems through the use of Microsoft Excel.

On the Home tab, click the Conditional formatting group. On the Styles drop-down list, click Manage rules. In the dialog box, select the rule, and click Edit. Make the changes to the rule and click OK.

Answer 2

Answer:

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

On the

✔ Home

tab, click the

✔ Styles

group.

On the Styles drop-down list, click

✔ Conditional Formatting

.

In the dialog box, select the rule, and click

✔ Manage Rules

.

Make the changes to the rule, and click OK.

Explanation: