Banking Sample Paper SBI Clerk Grade (Main) Sample Test Paper-2

  • question_answer
    Consolidate option does not offer ______ function

    A)  AVERAGE                   

    B)  MAX   

    C)  PMT                           

    D)  SUM   

    E)  StDev

    Correct Answer: C

    Solution :

     Consolidation is the process of combining values from several ranges of data either from within the same or different workbooks. It can be used to summarize data from different worksheets into master worksheet and create a report using a variety of calculations. PMT is a financial function that is offered in the financial functions category in Excel.


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