Microsoft Excel Questions & Answers - Page 7

Share on
31.

You can activate a cell in Excel by

A.

Pressing the Tab key

B.

Clicking the cell

C.

Pressing an arrow key

D.

All of the above

Correct answer is D

No explanation has been provided for this answer.

32.

B7:B9 indicates

A.

Cells B7 and cell B9 only

B.

Cells B7 through B9

C.

Cell B8 only

D.

None of the above

Correct answer is B

B7:B9 indicates a range of cell between Cells B7 through B9

33.

Which function in Excel is used to calculate depreciation, rates of return, future values and loan payment amounts?

A.

Logical

B.

Math & Trigonometry

C.

Statistical

D.

Financial

Correct answer is D

No explanation has been provided for this answer.

34.

The active cell in Excel

A.

is defined by a bold border around the cell

B.

receives the data the user enters

C.

is the formula bar

D.

Only A and B

Correct answer is D

An active cell is a rectangular box that highlights (a bold border around) the cell in a spreadsheet. An active cell helps identify what cell is being worked with and where data will be entered.

35.

What is represented by the small, black square in the lower-right corner of an active cell or range?

A.

Copy handle

B.

Fill handle

C.

Insert handle

D.

Border

Correct answer is B

Fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells in Excel. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner, as shown in the image.