Advanced Formatting

Question 1

Which are guidelines for using Themes? Check all that apply.Using different cell styles can help you differentiate different types of data.Fonts should be easily readable and of appropriate size.You cannot customize the default themes.Be consistent with themes across worksheets and workbooks.Applying a new theme will only change cells in a workbook that have no other formatting applied.

Revolt · Accepted Answer

Using different cell styles can help you differentiate different types of data.; Fonts should be easily readable and of appropriate size.; Be consistent with themes across worksheets and workbooks.

Question 2

Rule TypesX Insert Rule Formatting✔ Conditional FormattingCondition Properties

Revolt · Accepted Answer

✔ Conditional Formatting

Question 3

What is an example of conditional formatting?

Revolt · Accepted Answer

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

Question 4

What are styles?

Revolt · Accepted Answer

defined combinations of formatting

Question 5

What are examples of conditional formatting tools? Check all that apply.color scalesicon setsdata barscell stylesthemes

Revolt · Accepted Answer

color scales; icon sets; data bars

Question 6

Where do you find the Merge Style dialog box to merge styles from one workbook to another?

Revolt · Accepted Answer

in the Home tab, then Styles group

Question 7

Which tab houses the Themes tool?

Revolt · Accepted Answer

Page Layout

Question 8

Which gallery houses the Data Bars tool?

Revolt · Accepted Answer

Conditional Formatting

Question 9

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

Revolt · Accepted Answer

✔ Styles; On the Home tab, click the group.: Styles; On the drop-down list, click and click the rule you wish to use.: Conditional Formatting

Question 10

Where can you find thousands of templates for Excel?

Revolt · Accepted Answer

Backstage View

Advanced Formatting Answers

More from this Course

TRY EDGENUITY HACKS