1. . The example of formula is:
(A) =A1 + A2
(B) =add(A1:A2)
(C) A1+A2
(D) SUM(A1:A2)
2. . The example of function is:
(A) =A1 + A2
(B) A1+A2
(C) =SUM(A1:A2)
(D) =add(A1:A2)
3. . Which of the following option is correct?
(A) =Average(2,3,4)
(B) =Average(A2:F2)
(C) All of these
(D) =Average(A1,B1,C1)
4. . Which of the following is correct?
(A) =Power(2^3)
(B) =Power(2,3)
(C) =Power(2#3)
(D) =Power(2*3)
5. . Which function in Excel tells how many numeric entries are there?
(A) Count
(B) Num
(C) Sum
(D) PI
6. . The correct example for addition is:
(A) SUM(A2,B2)
(B) =add(A2,B2)
(C) A2 + B2
(D) =A2 + B2
7. . A ____________ is more efficient than formulas:
(A) Chart
(B) Sorting
(C) None of these
(D) Function
8. . A value used in a formula that does not change is called:
(A) Cell address
(B) Function
(C) Constant
(D) Range
9. . Which formula can add all the numeric values in a range of cells?
(A) Count
(B) Average
(C) Sum
(D) If