150 very important Excel MCQs for test and interview

51. Which of the, following is a correct, order of precedence, in formula calculation?

a. Multiplication and, division exponentiation, positive and negative, values

b. Multiplication and, division, positive and negative, values, addition and, subtraction

c. Addition and subtraction, positive and negative, values, exponentiation

d. All ,

52. The :Paste Special command: lets you copy, and paste:

a. Multiply the, selection by a copied value,

b. Cell comments,

C. Formatting options,

d. The resulting values, of a formula instead of, the actual formula

53. The numbers, in our worksheet look, like this: You want them, to look like this: $1,000. How can, you accomplish, this?

a. None of these,

b. Select Format > Money from, the menu

c. Click the Currency, Style button on the formatting, toolbar

d. You have to retype, everything and manually, add the dollar signs, Commas, and decimals.

54. Which of the, following is not a valid, data type in excel

a. Number,

b. Character,

C. Label,

d. Date/time,

55. “Excel worksheet cells” work very similarly, to what common element, of the windows graphical, user interface,:

a. Option buttons,

b. List boxes,

c. Text boxes,

d. Combo boxes,

56. Which of the following, options is not located, in the Page Setup, dialog box?

a. Page Break Preview,.

b. Page Orientation,

C. Margins,

d. Headers and Footers,

57. You want to track, the progress of the, stock market on a daily, basis. Which type of chart, should you, use?

a. Pie chart,

b. Row chart,

c. Line chart,

d. Column chart,

58. Without using, the mouse or the arrow, keys, what is the fastest, way of getting to, cell A1 in a spreadsheet?

a. Press Ctrl +Home,

b. Press Home,

C. Press Shift + Home,

d. Press Alt + Home,

59. Which of the, following methods cannot, be used to edit, the contents, of a cell?

a. Press the Alt key,

b. Clicking the formula, bar

c. Pressing the F2 key,

d. Double clicking the cell,

60. If you begin typing, an entry into a cell, and then realize that, you don’t want you, entry placed into, a cell, you:

a. Press the Erase, key

b. Press Esc,

C. Press the Enter, button

d. Press the Edit Formula, button