A predefined formula for performing a particular task is called
Formula
Functions
Column
None of these.
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
What is the excel function that adds all the numbers in a selected range of cells called ?
SUM
MAX
AVG
MIN
By default , Excel refers to cell address:
A1
A256
A65536
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 ?
COUNT
Which is a shortcut to using Excel's SUM function ?
AUTO FILL
AUTO 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 ( )
It consists of operators , cell address or values.
Function
Cell reference
