1.What is the intersection of a column and a row on a
worksheet called?
A.Column
B.Value
C.Address
D.Cell
2.What type of chart is useful for comparing values over
categories?
A.Pie Chart
B.Column Chart
C.Line Chart
D.Dot Graph
3.Which functioning Excel tells how many numeric entries are
there?
A.NUM
B.COUNT
C.SUM
D.CHKNUM
4.A features that display only the data in column (s)
according to specified criteria
A.Formula
B.Sorting
C.Filtering
D.Pivot
5.Statistical calculations and preparation of tables and
graphs can be done using
A.Adobe Photoshop
B.Excel
C.Notepad
D.Power Point
6. What type of chart will you use to compare the performance of
two employees in the year 2016?
A.Column Chart
B.Line Chart
C.Pie Chart
D.Dot Chart
7. Which one is not a Function in MS Excel?
A.SUM
B.AVG
C.MAX
D.MIN
8. Functions in MS Excel must begin with ___
A.An () sign
B.An Equal Sign
C.A Plus Sign
D.A > Sign
9. Which function in Excel checks whether a condition is true
or not?
A.SUM
B.COUNT
C.IF
D.AVERAGE
10. In Excel, Columns are labeled as ___
A.A, B, C, etc
B.1,2,3 etc
C.A1, A2, etc.
D.$A$1, $A$2, etc.
11. The Greater Than Sign (>) is an example of _____
operator.
A.Arithmatic
B.Logical
C.Conditional
D.Greater
12. What type of chart is useful for showing trends or
changes over time?
A.Pie Chart
B.Column Chart
C.Line Chart
D.Dot Graph
13. The process of arranging the items of a column in some
sequence or order is known as :
A.Arrengin
B.Autofill
C.Sorting
D.Filtering
14. The ____ feature of MS Excel quickly completes a series
of data
A.Auto Complete
B.Auto Fill
C.Fill Handle
D.Sorting
15. What type of chart is useful for comparing parts of a
whole?
A.Pie Chart
B.Column Chart
C.Line Chart
D.Dot Graph
15. In Excel, Rows are labeled as ______
A.A, B, C, etc
B.1,2,3 etc
C.A1, A2, etc.
D.$A$1, $A$2, etc.
17. What do you use to create a chart?
A.Pie Wizard
B.Excel Wizard
C.Data Wizard
D.Chart Wizard
18. How will you graphically represent expenditure in
different departments?
A.Column Chart
B.Line Chart
C.Pie Chart
D.Dot Chart
19. What type of chart is good for single series of data?
A.Column Chart
B.Line Chart
C.Pie Chart
D.Cone Chart
20. The basic unit of a worksheet into which you enter data
in Excel is called a
A.cell
B.table
C.box
D.column
Correct Answer Sheet
|
1.D |
2.B |
3.B |
4.D |
5.B |
6.B |
|
7.B |
8.B |
9.C |
10.A |
11.B |
12.C |
|
13.C |
14.B |
15.A |
16.B |
17.D |
18.C |
|
19.C |
20.A |
|
|
|
|
