AnswersTX-Business Information Management BIM IAdvanced Formatting

Advanced Formatting Answers

16 verified answers3 views
1
Free Preview

Which tasks can be completed using the Cell Style gallery? Check all that apply.choosing the look of a worksheetmaking sure the data is accuratecontrolling number formattingapplying relevant images

A
choosing the look of a worksheet
B
making sure the data is accurate
C
controlling number formatting
D
applying relevant images
2
Free Preview

✔ ThemesPage Setup Sheet Options Editing

A
✔ Themes
B
Page Setup
C
Sheet Options
D
Editing
3

Browse for Themes ✔ Save Current ThemeOffice Themes

A
Browse for Themes
B
✔ Save Current Theme
C
Office Themes
4

Titles and Headings New Cell Style ✔ Merge Styles

A
Titles and Headings
B
New Cell Style
C
✔ Merge Styles
145056

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

Answers:
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
145057

AlignmentFontCells✔ Styles

A
Alignment
B
Font
C
Cells
D
✔ Styles
145058

Format as Table ✔ Conditional FormattingCell Styles

A
Format as Table
B
✔ Conditional Formatting
C
Cell Styles
145059

✔ Manage RulesNew Rule Rule Properties

A
✔ Manage Rules
B
New Rule
C
Rule Properties
145060

Which types of customizing can you do with the Cell Style galleries? Check all that apply.change the font sizechange the font colorchange the background coloradjust percentage of background shadeadjust the style type to be currencyadd a hyperlink

A
change the font size
B
change the font color
C
change the background color
D
adjust percentage of background shade
E
adjust the style type to be currency
F
add a hyperlink
145061

Tomika wants to create a cell style for her workbook and share it with other workbooks she’s already created. Complete the steps to help Tomika.

Answers:
Go to the tab on the ribbon and the group .:Home
Go to the tab on the ribbon and the group .:Styles
Click Cell Styles, then click and create the style.:New Cell Style
To share it with other workbooks, use the function in the same group.:Merge Styles
145062

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

Answers:
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
145063

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

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

Tomika wants to create a cell style for her workbook and share it with other workbooks she’s already created. Complete the steps to help Tomika.

Answers:
Go to the tab on the ribbon and the group .:Home
Go to the tab on the ribbon and the group .:Styles
Click Cell Styles, then click and create the style.:New Cell Style
To share it with other workbooks, use the function in the same group.:Merge Styles
145065

Rule Types Insert Rule Formatting ✔ Conditional FormattingCondition Properties

A
Rule Types
B
Insert Rule Formatting
C
✔ Conditional Formatting
D
Condition Properties
145066

Alignment Font Cells ✔ Styles

A
Alignment
B
Font
C
Cells
D
✔ Styles
145067

Titles and Headings ✔ New Cell StyleMerge Styles

A
Titles and Headings
B
✔ New Cell Style
C
Merge Styles

Did you find these answers helpful?

More from this Course

Assignment
16 verified answers

Advanced Formatting

Assignment
10 verified answers

Managing Workbook Properties

Instruction
11 verified answers

Managing Workbook Properties