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

1 – D / 2 – D / 3 – A / 4 – C / 5 – D / 6 – C / 7 – A / 8 – C / 9 – B / 10 – A
 

One Response to “MCQ of Microsoft Excel – Set 2”

  1. waseem hussain 1 February 2017 at 12:58 PM

    Very nice I like this page and also I want more knowledge in ms excel


Leave a Reply

error: Content is protected !!