Total number of columns in Excel
65,536
512
1024
256
Which function is used to find the smallest or minimum value in a range of data ?
MIN
MAX
SUM
COUNT
By default , Excel refers to cell address:
A1
A256
A65536
None of these.
What is the excel function that adds all the numbers in a selected range of cells called ?
AVG
What is the default extension of Excel files?
XLS
XLW
WK1
123
Which one of the following is Arithmetic operation ?
+
=
&
True or False
The various types of cell referencing are :
Relative references
Absolute references
Mixed references
All of these
A reference that identifies a cell or a range of cells on a worksheet is known as:
Row
Cell reference
Column
Which function can be used to find the average or arithmetic mean of a list of numbers ?
MINIMUM
AVERAGE
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
