Ms Excel Mcqs for ( NTS, PTS, KPPSC, FPSC,PPSC SPSC, OTS, ETEA) Set 17

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. Ignore
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 of the above

331. Which of the following function will return a value of 8?
a. ROUNDUP(8.4999, 0)
b. ROUNDDOWN(8.4999, 0)
c. ROUND(8.4999, 0)
d. Only B and C

332. How to restrict to run a macro automatically when starting Microsoft Excel?
a. Hold down the SHIFT key during startup
b. Hold down the CTRL key during startup
c. Hold down the ESC key during startup
d. Hold down the ALT key during startup

333. How to remove the unwanted action from recorded macro without recording the whole macro again?

a. By using the Find and Edit Action Option
b. By clicking on the Refresh button in the Macro toolbar
c. By edit the macro in the Visual Basic Editor
d. Macro cannot be edited.

334. What should be add before a fraction to avoid entering it as a date?
a. //
b. FR
c. Zero
d. Zero Space

335. Which of the following function will use to find the highest number in a series of number?

a. MAX(B1:B3)
b. MAXIMUM (B1:B3)
c. HIGH (B1:B3)
d. HIGHEST(B1:B3)

336. What does the NOW() function return?
a. It returns the serial number of the current date and time
b. It returns the serial number of the current date
c. It returns the serial number of the current time
d. None of the above

337. What value will display if the formula = “$55.00″+5 is entered into a cell?
a. $60
b. 60
c. “$55.00″+5
d. $60.00

338. What is the shortcut key to insert current date in a cell?
a. CTRL + D
b. CTRL + T
c. CTRL + ;
d. CTRL + /

339. Which of the following syntax is correct regarding to SUM function in Excel?
a. =SUM (A1, B1)
b. =SUM (A1:B9)
c. =SUM (A1:A9, B1:B9)
d. All of the above

340. What is the shortcut key to hide entire column?
a. CTRL + −
b. CTRL + 0 
c. CTRL + H
d. CTRL + C

Answers:
321 - b
322 - d
323 - c
324 - a
325 - c
326 - d
327 - c
328 - b
329 - b
330 - d
331 - d
332 - a
333 - c
334 - d
335 - a
336 - d
337 - b
338 - c
339 - d
340 - b