Excel assessment 1

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

• Column

• Value

• Address

• Cell

2. Which functioning in Excel tells how many numeric entries are there?

• NUM

• COUNT

• SUM

• CHKNUM

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

• SUM

• COUNT

• IF

• AVERAGE

4. In Excel, Columns are labeled as ____________

• A, B, C, etc

• 1,2,3 etc

• A1, A2, etc

• $A$1, $A$2, etc.

5. In Excel, Rows are labeled as ______.

• A, B, C, etc

• 1,2,3 etc

• A1, A2, etc

• $A$1, $A$2, etc

6. Functions in MS Excel must begin with ________

• An () sign

• An Equal Sign

• A Plus Sign

• A > Sign

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

• Pie Chart

• Column Chart

• Line Chart

• Dot Graph

8. How many sheets are there, by default, when we create a new Excel file?

• 1

• 3

• 5

• 10

9. In Excel, which one denoted a range from B1 through E5.

• B1 - E5

• B1:E5

• B1 to E5

• B1$E5

10. What type of chart will you use to compare the performance of the sales of two products?

• Column Chart

• Line Chart

• Pie Chart

• Both A and B