Pariksha Corner

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

MS Excel



Sunday, January 19, 2020

How will you convert the selected range of cells to a table in MS­Excel 2010?

 | 

, , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-2 2017 click here to view all questions
    How will you convert the selected range of cells to a table in MS­Excel 2010?
    ABy clicking the Format as Table command in the Styles group on the Home tab.
    BBy clicking the Conditional Formatting command in the Styles group on the Home tab.
    CBy clicking the Cell Styles command in the Styles group on the Home tab.
    DBy clicking the Insert command in the Cells group on the Home tab.
    View Answer

    You have entered the information in an MS­Excel worksheet as shown in the figure. What formula will you write in cell B4 for calculating sales amount?
    Note: You will need to write the required formula with cell references.

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-2 2017 click here to view all questions
    You have entered the information in an MS­Excel worksheet as shown in the figure. What formula will you write in cell B4 for calculating sales amount?
    Note: You will need to write the required formula with cell references.
    A =B2*B3
    BB2*B3
    CA2*A3
    D =A2*A3
    View Answer

    Saturday, January 4, 2020

    You want to calculate the payment for a loan amount of INR 20,000 at 10% interest rate for a period of 2 years.

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT1 2017 click here to view all questions
    You want to calculate the payment for a loan amount of INR 20,000 at 10% interest rate for a period of 2 years. Which of the following excel formula would you use in cell E2 assuming the loan is compounded monthly?
    A"=PMT(A2/C2,B2*C2,D2)"
    B"=NPER(A2/C2,B2*C2,D2)"
    C"=RATE(A2/C2,B2*C2,D2)"
    D"=PV(A2/C2,B2*C2,D2)"
    View Answer

    The MS­Excel 2010 worksheet in the following figure contains large quantities ofdata.

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT1 2017 click here to view all questions
    The MS­Excel 2010 worksheet in the following figure contains large quantities of data. You want to print only the data in the range A1 through D19. How would you achieve this?

    A Select the cells A1 through D19, click File, and then click Print. In the Printpanel, under Settings, click Print Selection and click the Print button.
    BSelect the cells A1 through D19, click File, and then click Print. In the Printpanel, under Settings, click Print Active Sheets and click the Print button.
    C Select the cells D1 through D19, click File, and then click Print. In the Printpanel, under Settings, click PrintSelection and click the Print button.
    D Select the cells D1 through D19, click File, and then click Print. In the Printpanel, under Settings, click Print Active Sheets and click the Print button.
    View Answer

    You want to find out the year­ wise total sales on different regions.

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT1 2017 click here to view all questions
    You want to find out the year­ wise total sales on different regions. Which of the following should you perform in MS­Excel 2010 to achieve the same?
    A Sort the Year field from smallest to largest. Then, select the Data tab and click the Subtotal command to use it.
    B Sort the State field in ascending order. Then, select the Data tab and use the Group command to use it.
    C Sort the Year field from smallest to largest. Then, select the Data tab and clickthe Consolidate command to use it.
    DSort the State field in ascending order. Then, select the Data tab and click the Subtotal command to use it.
    View Answer

    Categories