Total number of columns in Excel
65,536
512
1024
256
Which is a shortcut to using Excel's SUM function ?
AUTO FILL
AUTO SUM
AVG
COUNT
What is the excel function that adds all the numbers in a selected range of cells called ?
SUM
MAX
MIN
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
By default , Excel refers to cell address:
A1
A256
A65536
None of these.
Which function can be used to find the average or arithmetic mean of a list of numbers ?
MINIMUM
AVERAGE
How many sheets are there in Excel Workbook by default?
2
3
4
5
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Which function is used to find the largest or maximum number in a given list of values ?
