8th Class Computers Microsoft Excel Question Bank MS-Excel 2010

  • question_answer Match the following MS-Excel functions given in Column-1 with their uses in Column - II
    Column - I Column - II
    (i) AVERAGE(range) (a) Returns the number rounded to the nearest odd integer.
    (ii) ODD(number) (b) Current date is displayed in the cell.
    (iii) MOD(number1, number2 (c) Rounds the number1 to the digits specified in number2.
    (iv) ROUND(number1,number2) (d) Returns the remainder when number1 is divided by the number2.
    (v) TODAY(  ) (e) Finds the average of the given range of numbers.
     

    A) (i) - (e), (ii) - (a), (iii) - (c), (iv) - (d), (v) - (b)

    B) (i) - (a), (ii) - (e), (iii) - (c), (iv) - (d), (v) - (b)

    C) (i) - (a), (ii) - (e), (iii) - (d), (iv) - (c), (v) - (b)

    D) (i) - (e), (ii) - (a), (iii) - (d), (iv) - (c), (v) - (b)

    Correct Answer: D


You need to login to perform this action.
You will be redirected in 3 sec spinner