Microsoft Excel MCQs for test and Interview

321. “Formulas in “Excel start with

a. %,

b. =,

C. .+,

d. ^,

322. The default, header for a, worksheet is

a. Username,

b. Date and Time,

c. Sheet tab Name,

d. None,

323. Which of the, following is not an option, of the spelling dialog, box?

a. lgnore,

b. Ignore all,

C. Edit,

d. Change,

324. Which of ,the following methods ,will not enter data in, a cell?

a. Pressing the Esc key,

b. Pressing an arrow key,

C. Pressing the tab key,

d. Clicking the enter button, to the formula bar,

325. The cell reference, for cell range of G2, to M12 is:

a. G2.M12,

b. G2;M12,

c. G2:M12,

d. G2-M12,

326. What is the keyboard, shortcut for creating a ,chart from the selected, cell range?

a. F2,

b. F4,

C. F8,

d. F11,

327. The Software which, contains rows and columns, is called

a. Database,

b. Drawing,

c. Spreadsheet,

d. Word processing,

328. You can group, noncontiguous worksheets, with

a. The alt+enter key,

b. The ctrl key and mouse,

c. The shift key and the mouse,

d. The group button, on the standard toolbar,

329. What is the “AutoComplete” feature of, Excel?

a. It automatically, completes abbreviated words,

b. It completes text, entries that match an existing, entry in the same column,

c. It completes text and, numeric entries that match, an existing entry in the same, column

d. It completes text, entries that match an, existing entry in the same, worksheet

330. Which, of the following ,is correct?

a. =AVERAGE(4, 5, 6, 7),

b. =AVERAGE(A1, B1, C1),

C. =AVERAGE(A1:A9, B1:B9),

d. =All