Advanced Formatting

Question 1

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

Revolt · Accepted Answer

choosing the look of a worksheet; controlling number formatting

Question 2

Jayden wants to take a current theme but just change a little bit of it. Complete the steps to help Jayden.

Revolt · Accepted Answer

✔ Page Layout; Go to the tab on the ribbon and the group.: Page Layout; Go to the tab on the ribbon and the group.: Themes; Select to save the changes.: Save Current Theme

Question 3

✔ ThemesPage SetupSheet OptionsEditing

Revolt · Accepted Answer

✔ Themes

Question 4

Browse for Themes✔ Save Current ThemeOffice Themes

Revolt · Accepted Answer

✔ Save Current Theme

Question 5

Use the drop-down menus to complete the steps necessary for creating a conditional formatting rule.

Revolt · Accepted Answer

✔ Styles; On the Home tab, click the group.: Styles; On the drop-down list, click , and click New Rule.: Conditional Formatting

Question 6

Rule TypesInsert Rule Formatting✔ Conditional FormattingX Condition Properties

Revolt · Accepted Answer

✔ Conditional Formatting

Question 7

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

Revolt · Accepted Answer

✔ Home; On the tab, click the group.: Home; On the tab, click the group.: Styles; On the Styles drop-down list, click .: Conditional Formatting; In the dialog box, select the rule, and click .: Manage Rules

Question 8

AlignmentFontCells✔ Styles

Revolt · Accepted Answer

✔ Styles

Question 9

Format as Table✔ Conditional FormattingCell Styles

Revolt · Accepted Answer

✔ Conditional Formatting

Question 10

✔ Manage RulesNew RuleRule Properties

Revolt · Accepted Answer

✔ Manage Rules

Advanced Formatting Answers

More from this Course

TRY EDGENUITY HACKS