Font size
WorksheetsMS EXCEL
Total questions: 10
Worksheet time: 5mins
What is the intersection of a column and a row on a worksheet called ?
Column
Value
Address
Cell
Which one is not a Function in MS Excel ?
SUM
AVG
MAX
MIN
Which function in Excel checks whether a condition is true or not ?
SUM
COUNT
IF
AVERAGE
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
A1, A2, etc
$A$1, $A$2, etc.
In Excel, Rows are labelled as ______
A, B, C, etc
1,2,3 etc
A1, A2, etc
$A$1, $A$2, etc
In Excel, which one denoted a range from B1 through E5
B1 - E5
B1:E5
B1 to E5
B1$E5
Ms Excel is a .......
Word Processing Program
Spreadsheet Program
Presentation Program
None of the above
Formula in Excel start with......
#
%
=
+
Which area in an Excel window allows entering values and formulas?
Standard tool Bar
Title bar
Formula Bar
None of the above
In the formula, which symbol specifies the fixed columns or row?
$
&
%
All of the above
