Microsoft Excel Questions

MCQ bookmark_border

171.

To delete an embedded objects, first

A

Double click the object

B

Select the object by clicking it

C

Press the Shift + Delete keys

D

Select it and then press the delete key

Correct Answer: D

To delete an embedded objects, first select it and then press the delete key.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

172.

Comments can be added to cells using

A

Edit > Comments

B

Insert > Comments

C

File > Comments

D

View > Comments

Correct Answer: B

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

173.

Which of the following is not a worksheet design criterion?

A

Efficiency

B

Aditibility

C

Description

D

Clarity

Correct Answer: C

Description

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

174.

To copy cell contents using drag and drop press the

A

End key

B

Shift key

C

Ctrl key

D

Esc key

Correct Answer: C

To copy cell contents using drag and drop press the Ctrl key else it will move the data.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

175.

To copy cell contents using drag and drop press the

A

End key

B

Shift key

C

Ctrl key

D

Esc key

Correct Answer: C

To copy cell contents using drag and drop press the Ctrl key else it will move the data.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

176.

When you copy a formula

A

Excel erases the original copy of the formula

B

Excel edits cell references in the newly copied formula

C

Excel adjusts absolute cell references

D

Excel doesn

Correct Answer: B

When you copy a formula Excel edits cell references in the newly copied formula.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

177.

The autofill feature

A

Extends a sequential series of data

B

Automatically adds range of cell values

C

Applies a boarder around the selected cells

D

All of the above

Correct Answer: D

AutoFill feature of Excel is a great time saver. This command can automatically extend the sequence, adds range of cell values, applies a boarder around the selected cells.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

178.

Which menu option can be used to split windows into two

A

Format > window

B

View > window > split

C

Window > split

D

View > split

Correct Answer: B

View > Window > Split option can be used to split windows into two.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

179.

Which of the following is an absolute cell reference?

A

!A!1

B

$A$1

C

#a#1

D

A1

Correct Answer: B

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

180.

Which of the following is an absolute cell reference?

A

!A!1

B

$A$1

C

#a#1

D

A1

Correct Answer: B

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