Question 1

Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.

Accepted Answer

A)   Home tab
B)   Format Cells dialog box
C)   Insert tab
D)   Mini toolbar

Question 2

The Comma Style format adds a comma and a dollar sign to a cell value.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select)  Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK?

Accepted Answer

A)   Icon Sets
B)   Color Scales
C)   Top/Bottom Rules
D)   Highlight Cells Rules

Exam 2: Formatting Workbook Text and Data

The Comma Style format adds a comma and a dollar sign to a cell value.

Correct Answer
verified

Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.

Correct Answer
verified

Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select) Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK?

Correct Answer
verified

Exam 2: Formatting Workbook Text and Data

The Comma Style format adds a comma and a dollar sign to a cell value.

Correct AnswerverifiedShow Answer

Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.

Correct AnswerverifiedShow Answer

Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select) Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified