Microsoft Excel Set-27

261. MS-EXCEL is based on ……….?
     a. WINDOWS
     b. DOS
     c. UNIX
     d. OS/2
262. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
     a. AutoFill
     b. Auto correct
     c. Auto sum
     d. Auto format
263. To select an entire column in MS-EXCEL, press?
     a. CTRL + C
     b. CTRL + Arrow key
     c. CTRL + S
     d. None of the above
264. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
     a. ROUND ( )
     b. FACT ( )
     c. MOD ( )
     d. DIV ( )
265. Which function is not available in the Consolidate dialog box?
     a. Pmt
     b. Average
     c. Max
     d. Sum
266. Which is not the function of “Edit, Clear” command?
     a. Delete contents
     b. Delete notes
     c. Delete cells
     d. Delete formats
267. Microsoft Excel is a powerful………..
     a. Word processing package
     b. Spreadsheet package
     c. Communication S/W Package
     d. DBMS package
268. How do you rearrange the data in ascending or descending order?
     a. Data, Sort
     b. Data, Form
     c. Data, Table
     d. Data Subtotals
269. Which Chart can be created in Excel?
     a. Area
     b. Line
     c. Pie
     d. All of the above
270. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?
     a. 5430
     b. 5436.8
     c. 5436.8
     d. 6.8

___________________________________________________________________________________________________