Which one's example is COUNT() in MS Excel?
Constant
Functions
Operators
Data
Which of the following displays the result after performing the formula calculations in MS Excel?
Formula bar
Selected Cell
Unselected Cell
Tool bar
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.
Identify the constant part from the following formula =IF (A1>=200,”Yes”,”No”)?
A1
IF
Yes
>=
Which of the following button is used to enter a formula quickly?
None of these
Which of the following function tells you the number of numeric entries in a selected cells?
Count
Maximum
Minimum
Average
Where does the current cell address is displayed in excel?
Status bar
Name box
Title bar
Which of the following area can be used to enter formulas in MS Excel?
Cells
Both 1 and 2
How can be start the formulas in MS Excel?
+
=
%
-
Which of the following have the examples as SUM, AVERAGE, IF, COUNT etc?
Formulas
Arguments
