How can we begin the formulas?
Greater than sign
Equal sign
Smaller than sign
Plus sign
Which one's example is COUNT() in MS Excel?
Constant
Functions
Operators
Data
Where does the current cell address is displayed in excel?
Status bar
Name box
Formula bar
Title bar
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.
In Ms Excel formula ‘=A1*B2’ used for multiply 2 values, then what you mean A1 and B2?
Constants
Cell References
Which of the following displays the result after performing the formula calculations in MS Excel?
Selected Cell
Unselected Cell
Tool bar
Identify the constant part from the following formula =IF (A1>=200,”Yes”,”No”)?
A1
IF
Yes
>=
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 of the following have the examples as SUM, AVERAGE, IF, COUNT etc?
Formulas
Arguments
