MS Excel MCQs

Question 1

Which area in an excel window allows entering values and formulas

Accepted Answer

Formula bar

Answer

Title bar

Answer

Menu bar

Answer

Standard toolbar

Question 2

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

Accepted Answer

Freeze panes command on the window menu

Answer

Unfreeze panes command on the window menu

Answer

Hold titles command on the edit menu

Answer

Split command on the window menu

Question 3

To edit in an embedded excel worksheet object in a word document

Accepted Answer

Use the excel menu bar and toolbars inside the word application

Answer

Edit the hyperlink

Answer

Edit the data in a excel source application

Answer

Use the word menu bar and toolbars

Question 4

To create a formula, you can use:

Accepted Answer

Value and cell references

Answer

Values but not cell references

Answer

Cell references but not values

Answer

Values or cell references although not both at the same time

Question 5

Status indicators are located on the

Accepted Answer

Formula bar

Answer

Vertical scroll bar

Answer

Horizontal scroll bar

Answer

Standard toolbar

Question 6

Which of the following is the oldest spreadsheet package?

Accepted Answer

VisiCalc

Answer

Lotus 1-2-3

Answer

Excel

Answer

StarCalc

Question 7

Rounding errors can occur

Accepted Answer

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

Answer

When you use addition and subtraction in a formula

Answer

Because excel uses hidden decimal places in computation

Answer

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

Question 8

You can copy data or formulas

Accepted Answer

All of the above

Answer

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

Answer

With commands on the shortcut menu

Answer

With buttons on the standard toolbars

Question 9

You cannot link excel worksheet data to a word document

Accepted Answer

With the copy and paste buttons on the standard toolbar

Answer

With the right drag method

Answer

With a hyperlink

Answer

With the copy and paste special commands