Microsoft Excel Questions & Answers - Page 8

36.

What are the tabs that appear at the bottom of each workbook called?

A.

Reference tabs

B.

Position tabs

C.

Location tabs

D.

Sheet tabs

Correct answer is D

In Excel, a sheet, sheet tab, or worksheet tab is used to display the worksheet that a user is currently editing. By clicking a worksheet tab (located at the bottom of the workbook), users may move between the various worksheets.

37.

What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

A.

An absolute cell address is created

B.

Cell address will change when it is copied to another cell

C.

The sheet tab is changed

D.

The status bar does not display the cell address

Correct answer is A

The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.

38.

The first cell in EXCEL worksheet is labeled as

A.

AA

B.

A1

C.

Aa

D.

A0

Correct answer is B

No explanation has been provided for this answer.

39.

Which key do you press to check spelling?

A.

F3

B.

F5

C.

F7

D.

F9

Correct answer is C

In most Microsoft Office apps (including Word, Excel, PowerPoint and Outlook), tap F7 to begin the spellcheck process.

40.

What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

A.

XY Chart

B.

Line Chart

C.

Pie Chart

D.

Column Chart

Correct answer is C

No explanation has been provided for this answer.