Advanced Formatting (Excel 2016)

Where do you find the Merge Style dialog box to merge styles from one workbook to another? A.) in the Home tab, then Styles group B.) in the Home tab, then Cells group C.) in the File tab, then Merge Styles D.) in the Home tab, then Editing group

A.) in the Home tab, then Styles group

What is an example of conditional formatting? A.) Cells in a row have a yellow background. B.) Cells in a range with values under 10 have a red background. C.) Cells in a column have green text. D.) Cells in a worksheet have borders around their edges.

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

Where can you find thousands of templates for Excel? A.) Home tab B.) Page Layout tab C.) Backstage View D.) Insert

C.) Backstage View

Which gallery houses the Data Bars tool? A.) Cell Styles B.) Page Layout C.) Conditional Formatting D.) Sort and Filter

C.) Conditional Formatting

Which tab houses the Themes tool? A.) Home B.) Insert C.) Page Layout D.) View

C.) Page Layout

What are styles? A.) built-in conditional formatting rules B.) formatting applied with the Format Painter C.) defined combinations of formatting D.) cells that were created using the AutoFill feature

C.) defined combinations of formatting

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.

Option 1, 2, 4

What are examples of conditional formatting tools? Check all that apply. color scales icon sets data bars cell styles themes

Option 1, 2, 3

Abram needs to put multiple sets of data into the same type of calculations for different companies, so he will create a template. Which components of the worksheet will he keep? data themes cell styles conditional formatting formulas

Option 2,3,4,5

On the Home tab, click the (Rules, Formatting, Conditions, Styles) group. On the drop-down list, click (Rule Types, Insert Rule Formatting, Conditional Formatting, Condition Properties) and click the rule you wish to use. Use the dialog box to complete the rule.

Styles Conditional Formatting