Pariksha Corner

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

MS Excel



Wednesday, February 5, 2020

You have to attend an annual appraisal meeting with your Senior Manager. You have created a presentation for this meeting through which you will be sharing your team performance details with your Senior Manager. Before the meeting, you go through the presentation to check it. You feel that some of the slides are moving away too quickly. You want the slide to move forward only when you click.Which of the following tabs contain the options that will help you controlthe advancement of the slides of your presentation in a show?

 | 

, , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-2 7-MAY­-2017 click here to view all questions

    You have to attend an annual appraisal meeting with your Senior Manager. You have created a presentation for this meeting through which you will be sharing your team performance details with your Senior Manager. Before the meeting, you go through the presentation to check it. You feel that some of the slides are moving away too quickly. You want the slide to move forward only when you click.Which of the following tabs contain the options that will help you controlthe advancement of the slides of your presentation in a show?

    ASlide Show
    BDesign
    CInsert
    DTransitions
    View Answer

    Sunday, January 26, 2020

    You are creating a spread sheet to set a monthly sales target for your team.You want to fill in the first column of the sheet with Month and Year as shown.Which of the following will help you drag the fill handle in MS­Excel 2010 toautomatically fill the rest of the months after you type the first month Jan-2017 manually?

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-1 7-MAY­-2017 click here to view all questions
    You are creating a spread sheet to set a monthly sales target for your team. You want to fill in the first column of the sheet with Month and Year as shown. Which of the following will help you drag the fill handle in MS­Excel 2010 to automatically fill the rest of the months after you type the first month Jan- 2017 manually?
    ABy using Auto Fill Options >>Fill Series.
    BBy clicking Styles group on Home tab>>Fill Across Worksheet.
    CBy clicking the Cell Styles command >>Custom List.
    DBy clicking Insert command >>Fill Months.
    View Answer

    You want to proof read the sales worksheet created by your sales team. Which of the following features in Excel 2010 should you turn on to collaborate with your sales team?

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-1 7-MAY­-2017 click here to view all questions
    You want to proof read the sales worksheet created by your sales team. Which of the following features in Excel 2010 should you turn on to collaborate with your sales team?
    AClick File ­> fo ­> Protect Workbook.
    BClick File ­> Info ­> Check for Issues ­> Inspect Document.
    CClick Review ­> Show Ink.
    DClick Review ­> Track Changes ­> Highlight Changes. Then, select Track Changes while editing.
    View Answer

    You have been given the responsibility of creating a statistical report of the overall performance of your bank branch. Which of the following will be best suited to help you handle large amounts of numerical data and convert it to Graphs?

     | 

    , , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-1 7-MAY­-2017 click here to view all questions
    You have been given the responsibility of creating a statistical report of the overall performance of your bank branch. Which of the following will be best suited to help you handle large amounts of numerical data and convert it to Graphs?
    AWord 2010
    BExcel 2010
    CAccess 2010
    DPowerPoint 2010
    View Answer

    You want to prepare a list of persons and their loan tenure. You want to temporarilyhide the No. Of Installments Per Year and Principal Amount columns' data fromview. How will you achieve the requirement in Excel 2010?

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-1 7-MAY­-2017 click here to view all questions
    You want to prepare a list of persons and their loan tenure. You want to temporarily hide the No. Of Installments Per Year and Principal Amount columns' data from view. How will you achieve the requirement in Excel 2010?
    ASelect the respective columns, on the Data tab, click Group. In the Group dialog box, select Columns. Click the minus sign to hide the group.
    BSelect the respective columns, on the Insert tab, click Group. In the Group dialog box, select Columns. Click the minus sign to hide the group.
    CSelect the respective columns, on the Data tab, click Hide Detail to hide the column`s data.
    DSelect the respective columns, on the Data tab, click Filter. Click the minus sign to hide the group.
    View Answer

    Categories