16 MS Excel MCQ Questions in english

16. Which kind of graph will you use to compare the sales performance of the two products?

A. Column Chart

B. Line Chart

C. Pie Chart

D. Both A and B

15. It is a group of data that has been electronically saved as a table of records.

A. spreadsheet

B. presentation

C. database

D. MS Word

14. Which one in Excel stood for the range B1 through E5?

A. E-Spreadsheet

B. Woorksheet

C. Workbook

D. Sheet

13. Which one in Excel stood for the range B1 through E5?

A. B1 - E5

B. B1:E5

C. B1 to E5

D. B1$E5

12. When we create a new Excel file, how many sheets are there by default?

A. 1

B. 3

C. 5

D. 10

11. A cell is the fundamental building block of an Excel spreadsheet in that you insert data into.

A. cell

B. box

C. column

D. table

10. What kind of chart works best for one data series?

A. Column Chart

B. Line Chart

C. Pie Chart

D. Cone Chart

9. How would you display spending in the various departments graphically?

A. Column Chart

B. Line Chart

C. Pie Chart

D. Dot Chart

8. What do you employ when making a chart?

A. Pie Wizard

B. Excel Wizard

C. Data Wizard

D. Chart Wizard

7. Rows in Excel have the label .

A. A, B, C, etc

B. 1,2,3 etc

C. A1, A2, etc.

D. $A$1, $A$2, etc.

6. What kind of chart can be used to compare different elements of a whole?

A. Pie Chart

B. Column Chart

C. Line Chart

D. Dot Graph

5. The ____ feature of MS Excel quickly completes a series of data

A. Auto Complete

B. Auto Fill

C. Fill Handle

D. Sorting

4. The process of arrenging the items of a column in some sequence or order is known as :

A. Arrengin

B. Autofill

C. Sorting

D. Filtering

3. What kind of graph is effective at displaying trends or changes over time?

A. Pie Chart

B. Column Chart

C. Line Chart

D. Dot Graph

2. The Greater Than sign (>) is an example of _____ operator.

A. Arithmatic

B. Logical

C. Conditional

D. Greater

1. Which function in Excel checks whether a condition is true or not ?

A. SUM

B. COUNT

C. IF

D. AVERAGE

Hi,Login to your account

Subjectwise MCQ

Statewise Prepration

Govt. Examwise MCQ