In Ms Excel formula ‘=A1*B2’ used for multiply 2 values, then what you mean A1 and B2?
Constants
Operators
Functions
Cell References
Identify the constant part from the following formula =IF (A1>=200,”Yes”,”No”)?
A1
IF
Yes
>=
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)
What value does the formula ‘= MAX (A1:A2)’ returns?
Minimum
Maximum
Number of cell
Both 1 and 2
How can be start the formulas in MS Excel?
+
=
%
-
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 formula is used to add two cells (D1 and D2) together?
=D1 + D2
=Add(D1+D2)
= total(D1:D2)
D1 + D 2
Which one's example is COUNT() in MS Excel?
Constant
Data
Which of the following are predefined in Excel?
Formula
Which of the following button is used to enter a formula quickly?
None of these
