Microsoft Excel Questions & Answers - Page 5

21.

To copy formatting from one area in an Excel worksheet and apply it to another area, you would use

A.

The Edit > Copy Format and Edit>Paste Format commands form the menu

B.

The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

C.

There is no way to copy and apply formatting in Excel – You have to do it manually

D.

The Format Painter button on the standard toolbar

Correct answer is D

No explanation has been provided for this answer.

22.

In Excel, hyperlinks can be

A.

Text

B.

Drawing objects

C.

Pictures

D.

All of the above

Correct answer is D

No explanation has been provided for this answer.

23.

Which of the following is used to perform WHAT IF analysis in Excel?

A.

Solver

B.

Goal seek

C.

Scenario Manager

D.

All of the above

Correct answer is D

No explanation has been provided for this answer.

24.

In Excel, comments put in cells are called

A.

Smart Tip

B.

Cell Tip

C.

Web Tip

D.

Soft Tip

Correct answer is B

No explanation has been provided for this answer.

25.

When a label is too long to fit within a worksheet cell, you typically must

A.

Shorten the label

B.

Increase the column width

C.

Decrease the column width

D.

Adjust the row height

Correct answer is B

No explanation has been provided for this answer.