Ms Excel Mcqs From Basic To Advance

1. What is the intersection of a column and a row on a worksheet called ?

A.Column
B.Value
C.Address
D.Cell

2. Statistical calculations and preparation of tables and graphs can be done using

A.Adobe Photoshop
B.Excel
C.Notepad
D.PowerPoint

3. Which function in Excel tells how many numeric entries are there ?

A.NUM
B.COUNT
C.SUM
D.CHKNUM

4. A features that displays only the data in column (s) according to specified criteria

A.Formula
B.Sorting
C.Filtering
D: None of these

5: What type of chart is useful for comparing values over categories ?

A.Pie Chart

B.Column Chart

C.Line Chart

D.Dot Graph

6. What type of chart will you use to compare performance of two employees in the year 2019 ?

A.Column Chart
B.Line Chart
C.Pie Chart
D.Dot Chart

7: Not a Function in Microsoft Excel ?

A.SUM

B.AVG

C.MAX

D.MIN

8. Functions in Microsoft Excel must begin from

A.An () sign

B.An Equal Sign

C.A Plus Sign

D. None Of These

9. In Microsoft Excel, Columns labelled as

A.A, B, C, etc

B.1,2,3 etc

C.A1, A2, etc.

D. None of these

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

A.Arithmetic

B.Logical

C.Conditional

D.Greater