What is the syntax of sum function?
COUNT(select the cell range)
SUM(select the cell range)
Add(select the cell range)
TOTAL(select the cell range)
Which of the following are predefined in Excel?
Functions
Formula
Data
Constants
Which of the following displays the result after performing the formula calculations in MS Excel?
Formula bar
Selected Cell
Unselected Cell
Tool bar
What value does the formula ‘= MAX (A1:A2)’ returns?
Minimum
Maximum
Number of cell
Both 1 and 2
In Ms Excel formula ‘=A1*B2’ used for multiply 2 values, then what you mean A1 and B2?
Operators
Cell References
How can we begin the formulas?
Greater than sign
Equal sign
Smaller than sign
Plus sign
Which of the following function tells you the number of numeric entries in a selected cells?
Count
Average
Can you say the meaning of formula ‘= AVERAGE(A1:A4, 25)’?
Cell A1, A2, A3, A4 are added and divided into 25.
Cell A1, A2, A3, A4, 25 are added and divided into 4.
Cell A1, A2, A3, A4, 25 are added and divided into 5.
Cell A1, A4, 25 are added and divided into 3.
Which of the following area can be used to enter formulas in MS Excel?
Cells
None of these
Which of the following button is used to enter a formula quickly?
