NEW
Font size
WorksheetsExcel assessment 1
Total questions: 10
Worksheet time: 10mins
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
