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

  • question_answer
    If a range A1:A5 named MARKS contains numbers 5, 10, 15, 20 and 25 respectively, then what would be the result of the following function?
    =AVERAGE(MARKS, 60)
     

    A) 30        

    B) 22.5

    C) 60                    

    D) 15

    Correct Answer: B

    Solution :

    You can name the cells A1:A5, by using Define Name feature (found in Formulas tab).


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