AnswersGA-Business and TechnologyFormatting a Worksheet

Formatting a Worksheet Answers

11 verified answers1 views
1
Free Preview

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.

A
Using different cell styles can help you differentiate different types of data.
B
Fonts should be easily readable and of appropriate size.
C
You cannot customize the default themes.
D
Be consistent with themes across worksheets and workbooks.
E
Applying a new theme will only change cells in a workbook that have no other formatting applied.
2
Free Preview

On the drop-down list, click and click the rule you wish to use.

A
Rule Types
B
Insert Rule Formatting
C
Conditional Formatting
D
Condition Properties
3

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.
4

Which gallery houses the Data Bars tool?

A
Cell Styles
B
Page Layout
C
Conditional Formatting
D
Sort and Filter
6

On the Home tab, click the group.

A
Rules
B
Formatting
C
Conditions
D
Styles
8

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
9

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
10

Which tab houses the Themes tool?

A
Home
B
Insert
C
Page Layout
D
View
11

Where can you find thousands of templates for Excel?

A
Home tab
B
Page Layout tab
C
Backstage View
D
Insert

Did you find these answers helpful?

Formatting a Worksheet Answers — GA-Business and…