MCQs (Set - 9)

MICROSOFT EXCEL MCQS FOR GOVERNMENT EXAM PREPARATION

1. Which types of document can be created by spreadsheet program?

A. Sales Invoice

B. Cash Memo

C. Product Quotation

D. Purchase Invoice

E. All of the above

Ans. E

2. Elements of Microsoft excel?

A. Workbook

B. Worksheet

C. Columns

D. Rows

E. All of the above

Ans. E

3. In MS-Excel every formula should be start with …………. Sign?

A. @

B. %

C. #

D. =

Ans. D

4. Identify the invalid function of Microsoft excel?

A. Count

B. Rows

C. Avg

D. Sum

Ans. C

5. Which element can be share in MS-Excel?

A. Only worksheet

B. Only workbook

C. Both worksheet and workbook

D. None

Ans. C  

6. A worksheet consisted ….. ?

A. Workbooks

B. Rows and columns

C. Only rows

D. Only columns

Ans. B

7. Which tool is used to highlight only particular value selected via a given condition?

A.  Advance filter

B. Sorting

C. Conditional formatting

D. If formula

Ans. C

8. Run command to open the Microsoft excel?

A. MS Excel

B. Microsoft Excel

C. Excel

D. All of the above

Ans. C

9. Which function is used to calculate sum of only selected values?

A. Sum

B. SumIf

C. Average

D. IfSum

Ans. B

10. Which menu can be used to insert a comment in Microsoft Excel?

A. Home

B. Insert

C. Review

D. View

Ans. C

SET - 10 >>

HOME