Microsoft Excel Questions

MCQ bookmark_border

141.

You can convert existing excel worksheet data an charts to an HTML document by using

A

FTP wizard

B

Internet assistant wizard

C

Intranet wizard

D

Import wizard

Correct Answer: B

The Internet Assistant for Excel is an add-in wizard that allows you to create and distribute Excel documents online for viewing with any popular browser. The Internet Assistant helps you convert your spreadsheet data to HTML format. It is designed for the 1997 and earlier versions of Excel.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

142.

A circular reference is

A

Geometric modeling tool

B

A cell that points to a drawing object

C

A formula that either directly or indirectly depends on itself

D

Always erroneous

Correct Answer: C

A circular reference occurs when a formula directly or indirectly refers to its own cell. This causes the formula to use its result in the calculation, which can create errors.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

143.

Which of following is Not one of Excel's what-if function?

A

Goal seek

B

Solver

C

Scenario manager

D

Auto Outline

Correct Answer: D

Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

144.

When you insert an excel file into a word document. The data are

A

Hyperlinked placed in a word table

B

Linked

C

Embedded

D

Use the word menu bar and toolbars

Correct Answer: B

When we insert an excel file into a word document and keep the source file linkage when data is updated in source file update data in liked file also. The data are Linked. In Embedded objects file become part of document and does not get updated when source file is updated.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

145.

When you insert an excel file into a word document. The data are

A

Hyperlinked placed in a word table

B

Linked

C

Embedded

D

Use the word menu bar and toolbars

Correct Answer: B

When we insert an excel file into a word document and keep the source file linkage when data is updated in source file update data in liked file also. The data are Linked. In Embedded objects file become part of document and does not get updated when source file is updated.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

146.

Each excel file is called a workbook because

A

It can contain text and data

B

It can be modified

C

It can contain many sheets including worksheets and chart sheets

D

You have to work hard to create it

Correct Answer: C

A workbook is a collection of one or more spreadsheets and charts in a single file.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

147.

Excel probably considers the cell entry January 1, 2020 to be a

A

Label

B

Value

C

Formula

D

Text string

Correct Answer: B

In Excel Date format is considered as value.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

148.

You can enter which types of data into worksheet cells?

A

Labels, values, and formulas

B

Labels and values but not formulas

C

Values and formulas but not labels

D

Formulas only

Correct Answer: A

We can enter Labels, values, and formulas into worksheet cells.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

149.

All worksheet formula

A

Manipulate values

B

Manipulate labels

C

Return a formula result

D

Use the addition operator

Correct Answer: C

All worksheet formula returns a formula result.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

150.

All worksheet formula

A

Manipulate values

B

Manipulate labels

C

Return a formula result

D

Use the addition operator

Correct Answer: C

All worksheet formula returns a formula result.

Check Answer report_problem Report forum Discussion