Microsoft Excel Questions

MCQ bookmark_border

131.

Status indicators are located on the

A

Vertical scroll bar

B

Horizontal scroll bar

C

Formula bar

D

Standard toolbar

Correct Answer: C

Status indicators are located on the formula bar.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

132.

Which of the following is the oldest spreadsheet package?

A

VisiCalc

B

Lotus 1-2-3

C

Excel

D

StarCalc

Correct Answer: A

VisiCalc was the first computer spreadsheet program. It was released to the public in 1979, running on an Apple II computer. While most early microprocessor computers had been quickly supported by BASIC and a few games, VisiCalc introduced a new level in application software. It was considered a fourth generation software program.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

133.

Rounding errors can occur

A

When you use multiplication, division, or exponentiation in a formula

B

When you use addition and subtraction in a formula

C

Because excel uses hidden decimal places in computation

D

When you show the results of formulas with different decimal places that the calculated results

Correct Answer: A

When we use multiplication, division, or exponentiation in a formula, rounding errors can occur.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

134.

You can copy data or formulas

A

With the copy, paste and cut commands on the edit menu

B

With commands on the shortcut menu

C

With buttons on the standard toolbars

D

All of the above

Correct Answer: D

We can copy data or formulas with the copy, paste and cut commands on the edit menu or with commands on the shortcut menu or with buttons on the standard toolbars in Excel 2003 or earlier version.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

135.

You can copy data or formulas

A

With the copy, paste and cut commands on the edit menu

B

With commands on the shortcut menu

C

With buttons on the standard toolbars

D

All of the above

Correct Answer: D

We can copy data or formulas with the copy, paste and cut commands on the edit menu or with commands on the shortcut menu or with buttons on the standard toolbars in Excel 2003 or earlier version.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

136.

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

A

Word

B

Smart cell

C

Excel

D

Lotus 1-2-3

Correct Answer: D

Lotus 1-2-3 spreadsheet was the first MS-DOS based spreadsheet package which was released on January 26, 1983. It was the IBM PC's first killer application, was hugely popular in the 1980s, displacing the former leader VisiCalc and contributed significantly to the success of the IBM PC. Lotus had difficulties adapting 1-2-3 to the Windows environment, and was overtaken by Microsoft Excel.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

137.

An excel workbook is a collection of

A

Workbooks

B

Worksheets

C

Charts

D

Worksheets and charts

Correct Answer: D

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

138.

Excel files have a default extension of in Excel-2003

A

Xls

B

Xlw

C

Wk1

D

123

Correct Answer: A

Excel files have a default extension of xls in 2003 and earlier version of MS-office and xlxs in 2007 and higher version of MS-office.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

139.

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

A

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

B

Double clicking the format painter button

C

Pressing the Ctrl key and clicking the format painter button

D

Pressing the Alt key and clicking the format painter button

Correct Answer: B

We can use the format painter multiple times before we turn it off by double clicking the format painter button.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

140.

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

A

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

B

Double clicking the format painter button

C

Pressing the Ctrl key and clicking the format painter button

D

Pressing the Alt key and clicking the format painter button

Correct Answer: B

We can use the format painter multiple times before we turn it off by double clicking the format painter button.

Check Answer report_problem Report forum Discussion