Where does the current cell address is displayed in excel?
Status bar
Name box
Formula bar
Title bar
In Ms Excel formula ‘=A1*B2’ used for multiply 2 values, then what you mean A1 and B2?
Constants
Operators
Functions
Cell References
Which of the following have the examples as SUM, AVERAGE, IF, COUNT etc?
Formulas
Arguments
Data
Which of the following function tells you the number of numeric entries in a selected cells?
Count
Maximum
Minimum
Average
What does ‘=SUM (A1:A4, B1)’ means?
A1, A4 and B1 cells to be added.
A1, A4 cells to be added and value stored in B1.
A1, A2, A3, A4, B1, B2, B3, B4 cells to be added.
A1, A2, A3, A4 and B1 cells to be added.
Which one's example is COUNT() in MS Excel?
Constant
Identify the constant part from the following formula =IF (A1>=200,”Yes”,”No”)?
A1
IF
Yes
>=
How can be start the formulas in MS Excel?
+
=
%
-
Which of the following is used to perform calculations in MS Excel?
Formula
Textbox
Table
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.
