BG-1

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

A. Column

B. Value

C. Address

D. Cell

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

A. Num

B. Sum

C. Count

D. Chknum

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

A. Formula

B. Sorting

C. Filtering

D. Pivot

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

A. Column Chart

B. Line Chart

C. Pie Chart

D. Dot Chart

Q5. Which one is not a Function in MS Excel ?

A. SUM

B. AVG

C. MAX

D. MIN

Q6. Formulae in MS Excel must begin with ___

A. An () sign

B. An Equal Sign

C. A Plus Sign

D. A > Sign

Q7. Which functionin Excel checks whether a condition is true or not ?

A. SUM

B. COUNT

C. IF

D. AVERAGE

Q8. In Excel, Columns are labelled as ___

A. A, B, C, etc

B. 1,2,3 etc

C. A1, A2, etc.

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

Q9. 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

Q10. What type of chart is useful for comparing parts of a whole ?

A. Pie Chart

B. Column Chart

C. Line Chart

D. Dot Graph