Chapter 8 Working with Formulas and Functions MCQs 9 min Score: 0 Attempted: 0/9 Subscribe 1. . The example of formula is: (A) =A1 + A2 (B) =add(A1:A2) (C) A1+A2 (D) SUM(A1:A2)Show All Answers 2. . The example of function is: (A) =A1 + A2 (B) A1+A2 (C) =SUM(A1:A2) (D) =add(A1:A2)Show All Answers 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)Show All Answers 4. . Which of the following is correct? (A) =Power(2^3) (B) =Power(2,3) (C) =Power(2#3) (D) =Power(2*3)Show All Answers 5. . Which function in Excel tells how many numeric entries are there? (A) Count (B) Num (C) Sum (D) PIShow All Answers 6. . The correct example for addition is: (A) SUM(A2,B2) (B) =add(A2,B2) (C) A2 + B2 (D) =A2 + B2Show All Answers 7. . A ____________ is more efficient than formulas: (A) Chart (B) Sorting (C) None of these (D) FunctionShow All Answers 8. . A value used in a formula that does not change is called: (A) Cell address (B) Function (C) Constant (D) RangeShow All Answers 9. . Which formula can add all the numeric values in a range of cells? (A) Count (B) Average (C) Sum (D) IfShow All Answers
