NEW
Font size
WorksheetsIT Microsoft excel
Total questions: 10
Worksheet time: 5mins
Which one is not a Function in MS Excel ?
Sum
AVG
Max
min
Functions in MS Excel must begin with ___
An Equal Sign
An () sign
A Plus Sign
A > Sign
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
$A$1, $A$2, etc.
A1, A2, etc
What is the intersection of a column and a row on a worksheet called ?
Column B
Value
Address
Cell
Which function Excel checks whether a condition is true or not ?
AVERAGE
SUM
IF
Count
How many sheets are there in Excel Workbook by default?
2
3
4
5
The first cell in Excel worksheet is labeled as:
A1
A2
Aa
AA
Which is an example of a function?
=add(A1:A2)
=A1+A2
=SUM(A1:A2)
A1+A2
To find Maximum of B2 , C2 and D2 you would use :
Sum(B:D2)
Max(B2:D2)
=Max(B2:D2)
=Min(B2:D2)
To have the current date displayed on your worksheet use the .................... function
TODAY
Sum
Max
Min
