Which function is used to total the number of cells in a selected range of data ?
MAX
COUNT
AVG
MIN
The various types of cell referencing are :
Relative references
Absolute references
Mixed references
All of these
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
Which function is used to find the smallest or minimum value in a range of data ?
SUM
In Excel which operator is used for division?
+
—
*
/
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
Which function can be used to find the average or arithmetic mean of a list of numbers ?
MINIMUM
AVERAGE
None of these.
It consists of operators , cell address or values.
Formula
Function
Cell reference
Which function is used to find the largest or maximum number in a given list of values ?
Total number of rows in Excel us?
512
1024
65,536
256
