150 very important Excel MCQs for test and interview

31. To create, a formula, you can use:

a. Values but not, cell references

b. Cell references but not, values

c. Values or cell, references although not, both at the same time

d. Value, and cell references,

32. “Status indicators” are located, on the“

a. Vertical scroll bar,

b. Horizontal, scroll bar

c. Formula bar,

d. Standard toolbar,

32. Status, indicators are located, on the:

a. Vertical scroll, bar

b. Horizontal scroll, bar

c. Formula bar,

d. Standard toolbar,

33. Which of, the following is the oldest, “spreadsheet” package?

a. VisiCalc,

b. Lotus 1-2-3,

C. Excel,

d. StarCalc,

34. 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 exce,l uses hidden decimal, places in computation

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

35. You can, copy data or, formulas

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

b. With commands, on ta shortcut menu,

c. With buttons, on the standard, toolbars

d. All ,

36. You cannot “link excel worksheet” data to a word, document

a. With the right, drag method

b. With a hyperlink,

c. With the, copy and paste, special commands

d. With the copy, and paste buttons on, the standard toolbar.

37. Which of the, following is a popular “DOS based spreadsheet” package?

a. Word,

b. Smart cell,

c. Excel,

d. Lotus 1-2-3,

38. An “excel workbook” is a collection, of:

a. Workbooks,

b. Worksheets,

c. Charts,

d. Worksheets and charts,

39. Excel files, have a “default extension” of:

a. Xls,

b. Xlw,

c. Wk1,

d. 123,

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

a. You can use, the format painter button, on 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