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 
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 
A)  Icon Sets 
B)  Color Scales 
C)  Top/Bottom Rules 
D)  Highlight Cells Rules

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

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

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?

Getting Started With Excel

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Filters

Exam 2: Formatting Workbook Text and Data

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

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

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?

Getting Started With Excel

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Filters