Microsoft Excel Questions

MCQ bookmark_border

81.

Which would you choose to create a bar diagram?

A

Edit, Chart

B

Insert, Chart

C

Tools, Chart

D

Format, Chart

Correct Answer: B

Click the Insert > Chart

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

82.

Which setting you must modify to print a worksheet using letterhead?

A

Paper

B

Margin

C

Layout

D

Orientation

Correct Answer: B

We need to set margins in Excel worksheets before printing, open the

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

83.

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: C

Scatter plot (XY chart) used to show scientific XY data. Scatter plots are often used to find out if there's a relationship between variable X and Y.
Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis.
Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series.
Column charts are used to compare values across categories by using vertical bars.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

84.

The spelling dialog box can be involved by choosing spelling from ________ menu.

A

Insert

B

File

C

Tools

D

View

Correct Answer: C

In Excel 2003 and earlier version Tools > Spelling
From Excel 2007 and higher version Ribbon > Review tab > Proofing group > Spelling

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

85.

The spelling dialog box can be involved by choosing spelling from ________ menu.

A

Insert

B

File

C

Tools

D

View

Correct Answer: C

In Excel 2003 and earlier version Tools > Spelling
From Excel 2007 and higher version Ribbon > Review tab > Proofing group > Spelling

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

86.

To record a sequence of keystrokes and mouse actions to play back later we use:

A

Media player

B

Sound Recorder

C

Calculator

D

Macro Recorder

Correct Answer: D

Macro Recorder records your mouse movements, mouse clicks and keyboard input. Just like a tape recorder for your computer.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

87.

We can save and protect the workbook by

A

Write Reservation Password

B

Protection Password

C

Read-only Recommended

D

Any of the above

Correct Answer: D

We can save and protect the workbook by Encrypt a Workbook with a Password, Make a Workbook Read-Only, Protect a Workbook

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

88.

The first cell in EXCEL worksheet is labeled as

A

AA

B

A1

C

Aa

D

A0

Correct Answer: B

The first cell in EXCEL worksheet is labeled as A1.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

89.

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: 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.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

90.

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: 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.

Check Answer report_problem Report forum Discussion