## 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**

#### Incoming search terms:

- an excel workbook is a collection of
- ms excel is based on
- ms excel multiple choice questions
- What do you mean by a Workspace
- excel workbook is a collection of
- what do you mean by workspace
- to return the remainder after a number is divided by a divisor in excel we use the function?
- What do you mean by a Workspace?
- microsoft excel is a powerful
- to return the remainder after a number is divided by a divisor in excel we use the function