MCQ of Microsoft Excel – Set 2
2-1. An Excel Workbook is a collection of …….
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts
2-2. What do you mean by a Workspace?
A. Group of Columns
B. Group of Worksheets
C. Group of Rows
D. Group of Workbooks
2-3. MS-EXCEL is based on ……….?
A. WINDOWS
B. DOS
C. UNIX
D. OS/2
2-4. 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
2-5. To select an entire column in MS-EXCEL, press?
A. CTRL + C
B. CTRL + Arrow key
C. CTRL + S
D. None of the above
2-6. 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 ( )
2-7. Which function is not available in the Consolidate dialog box?
A. Pmt
B. Average
C. Max
D. Sum
2-8. Which is not the function of “Edit, Clear” command?
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
2-9. Microsoft Excel is a powerful………..
A. Word processing package
B. Spreadsheet package
C. Communication S/W Package
D. DBMS package
2-10. How do you rearrange the data in ascending or descending order?
A. Data, Sort
B. Data, Form
C. Data, Table
D. Data Subtotals
Click Here for Answers
Very nice I like this page and also I want more knowledge in ms excel