IT Microsoft excel

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