MS Excel MCQs

Question 1

Which of the following is a popular DOS based spreadsheet package?

Accepted Answer

Lotus 1-2-3

Answer

Word

Answer

Smart cell

Answer

Excel

Question 2

An excel workbook is a collection of

Accepted Answer

Worksheets and charts

Answer

Workbooks

Answer

Worksheets

Answer

Charts

Question 3

Excel files have a default extension of in Excel-2003

Accepted Answer

Xls

Answer

Xlw

Answer

Wk1

Answer

123

Question 4

You can use the format painter multiple times before you turn it off by

Accepted Answer

Double clicking the format painter button

Answer

You can use the format painter button on ly one time when you click it

Answer

Pressing the Ctrl key and clicking the format painter button

Answer

Pressing the Alt key and clicking the format painter button

Question 5

You can use the formula palette to

Accepted Answer

Create and edit formulas containing functions

Answer

Format cells containing numbers

Answer

Enter assumptions data

Answer

Copy a range of cells

Question 6

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

Accepted Answer

Internet assistant wizard

Answer

FTP wizard

Answer

Intranet wizard

Answer

Import wizard

Question 7

A circular reference is

Accepted Answer

A formula that either directly or indirectly depends on itself

Answer

Geometric modeling tool

Answer

A cell that points to a drawing object

Answer

Always erroneous

Question 8

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

Accepted Answer

Auto Outline

Answer

Goal seek

Answer

Solver

Answer

Scenario manager

Question 9

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

Accepted Answer

Linked

Answer

Hyperlinked placed in a word table

Answer

Embedded

Answer

Use the word menu bar and toolbars