150 very important Excel MCQs for test and interview

91. The “Chart wizard” term data categories, refers to;

a. A chart plot area,

b. A horizontal axis,

C. The organization, of individual values with, a chart’s data series

d. The data range, that supply chart data,

92. A “worksheet range” is a:

a. A command used, for data modeling,

b. A range of, values such as from 23 to, 234

c. A group of cells,

d. A group of worksheets,

93. Getting data, from a cell located in a, different sheet is called,

a. Accessing,

b. Referencing,

c. Updating,

d. Functioning,

94. “Tab scrolling” button:

a. Allow you to view, a different worksheet,

b. Allow you, to view additional worksheet, rows down

C. Allow you, to view additional worksheet, columns to the right

d. Allow you to, view additional sheets ,tabs

95. A numeric value, can be treated as a, label value if it precedes, with

a. Apostrophe (&lsquo),

b. Exclamation (1),

C. Hash (#),

d. Ampersand (&,

96. “Concatenation of text” can be done, using:

a. Apostrophe (‘),

b. Exclamation (!),

C. Hash (#),

d. Ampersand (&),

97. Data can be, arranged in a worksheet, in a easy to understand, manner using

a. auto formatting,

b. applying styles,

C. changing fonts,

d. all ,

98. You can use, drag-and-drop to embed, excel worksheet data, in a word document,

a. By dragging a, range of excel data to, the word button on the, taskbar while pressing the, Ctrl key

b. By dragging a range, of excel data to the word, button on the taskbar while, pressing Shift key

c. By dragging a, range of excel data to the, word button on the taskbar, while pressing Alt key

d. None ,

99. The “auto calculate” feature,

a. Can only add values, in a range of cells,

b. Provides a quick way, to view the result of, an arithmetic operation, on a range of cells

C. Automatically creates, formulas and adds them, to a worksheet

d. a and c,

100. Excel uniquely, identifies cells within, a worksheet with, a cell name

a. Cell names,

b. Column numbers, and row letters,

c. Column letters, and row numbers,

d. Cell locator coordinates,