Pariksha Corner

Learn and practice Aptitude questions and answers with explanation for interview, competitive exam (Pariksha Corner )

MS Excel



Saturday, January 25, 2020

You want to create a snapshot view of the annual sales results of your bank's different products or services such as home loan, car loan, personal loan, consumer loan etc. Which of the following application software will help you create good sales graphs by taking data automatically from tables?

 | 

, , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-3 2017 click here to view all questions
    You want to create a snapshot view of the annual sales results of your bank's different products or services such as home loan, car loan, personal loan, consumer loan etc. Which of the following application software will help you create good sales graphs by taking data automatically from tables?
    AMicrosoft Excel
    BMicrosoft Outlook
    CMicrosoft PowerPoint
    DMicrosoft Word
    View Answer

    You have to create an annual sales report across all product categories. You will need to submit this report to your Senior Manager who will review it and thenpresent it to the Vice President. As both the Senior Management people are very busy, you need to provide a single graph that shows the total sales of differentproduct categories. Which of the following type of charts in MS­Excel 2010 should you use for comparing values over different categories?

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-3 2017 click here to view all questions
    You have to create an annual sales report across all product categories. You will need to submit this report to your Senior Manager who will review it and then present it to the Vice President. As both the Senior Management people are very busy, you need to provide a single graph that shows the total sales of different product categories. Which of the following type of charts in MS­Excel 2010 should you use for comparing values over different categories?
    APie Chart
    BLine Chart
    CColumn Chart
    DDot Graph
    View Answer

    The MS­Excel 2010 worksheet in the following figure contains large quantities ofsales amount data for different regions. Which of the following options will helpyou rearrange the data to identify the order in which the regions made salesfrom highest to lowest?

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-3 2017 click here to view all questions
    The MS­Excel 2010 worksheet in the following figure contains large quantities of sales amount data for different regions. Which of the following options will help you rearrange the data to identify the order in which the regions made sales from highest to lowest?
    AAutofill
    BFiltering
    CArranging
    DSorting
    View Answer

    You want to calculate the total amount of sales made by the various categoriesof automobile loans offered by your bank. Which of the following excel formulawould you use in cell B8 shown by the red highlighted box to calculate the totalamount of sales made by various categories of automobile loans?

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-3 2017 click here to view all questions
    You want to calculate the total amount of sales made by the various categories of automobile loans offered by your bank. Which of the following excel formula would you use in cell B8 shown by the red highlighted box to calculate the total amount of sales made by various categories of automobile loans?
    Aa. =TOTAL(B4:B7)
    Bb. =AVG(A4*B4:A7*B7)
    Cc. =SIGMA(A4:A7)
    Dd. =SUM(B4:B7)
    View Answer

    Sunday, January 19, 2020

    You have a large volume of data in your region­wise sales worksheet. You want toquickly analyze data to make better business decisions. Which of the following MS­ Excel object will you create to present your data for easy exploration and analysis?

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-2 2017 click here to view all questions
    You have a large volume of data in your region­wise sales worksheet. You want to quickly analyze data to make better business decisions. Which of the following MS­ Excel object will you create to present your data for easy exploration and analysis?
    APivot Table
    BTable
    CSubtotal
    DSlicer
    View Answer

    Categories