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

301. MS-EXCEL can be used to automate
a. Financial statements, Business forecasting
b. Transaction registers, inventory control
c. Accounts receivable, accounts payable
d. Any of the above

302. NOT, AND, OR and XOR are
a. Logical Operators
b. Arithmetic operators
c. Relational operators
d. None of the above





303. In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a 

a. calendar
b. photograph of rainfall
c. chart showing rainfall amounts
d. database of rainfall

304. You want to record experiment information and create a chart that shows the rate of crystal growth over a period of timThe best application to use would be: 

a. word processing
b. spreadsheet
c. database
d. graphics

305. You are editing an worksheet that you had previously saveIf you want to save the edited sheet without losing the original one, which command should you use? 

a. New
b. Save As
c. Edit
d. Save

306. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do? 

a. Re-format the spreadsheet
b. Insert a row
c. Increase the column width
d. Use the spacebar

307. In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in …………… 

a. ascending order
b. descending order
c. alphabetical order
d. random order

308. In order to perform a calculation in a spreadsheet, you need to use a:

a. table
b. formula
c. field
d. variable

309. The box on the chart that contains the name of each individual record is called the ________. 

a. cell
b. title
c. axis
d. legend

310. If you want all of the white cats grouped together in the database, you need to sort by ________.
a. Color, then Gender
b. Pet Type, then Color
c. Pet Type, then Gender
d. Color, then Pet Name

311. You accidentally erased a record in the sheet. What command can be used to restore it immediately?
a. Insert
b. Copy
c. Undo
d. Replace

312. Where a row and a column meet, what do you call that?
a. A cell
b. A block
c. A box
d. None of the above

313. How do you tell one cell from another?
a. By numbers
b. By letters
c. By its address
d. by color

314. Give me an example of a cell address.
a. 11 25
b. 911
c. 41A
d. A21

315. Which is an example of a formula?
a. =A1+A2
b. =add(A1:A2)
c. A1+A2
d. SUM(A1:A2)

316. Which is an example of a function?
a. =add(A1:A2)
b. =A1+A2
c. =SUM(A1:A2)
d. A1+A2

317. What is the symbol for multiplying?
a. > 
b. /
c. !
d. *

318. What is the symbol for dividing?
a. A ./
b. %
c. &
d. #

319. A function inside another function is called _______
a. Nested function
b. Round function
c. Sum function
d. Text function

320. Which of the following is not an underline option in the format cells dialog box?
a. Double
b. Single Accounting 
c. Double Accounting
d. Single Engineering

Answers:
301 - d
302 - a
303 - c
304 - b
305 - b
306 - b
307 - b
308 - b
309 - d
310 - b
311 - c
312 - a
313 - c
314 - d
315 - a
316 - c
317 - d
318 - a
319 - a
320 - d