Home / Computer Fundamentals / MS Excel :: Section-1

Computer Fundamentals :: MS Excel

  1. In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.

  2. A.

     AutoFill

    B.

     Auto correct

    C.

     Auto sum

    D.

     Auto format


  3. To select an entire column in MS-EXCEL, press?

  4. A.

     CTRL + C

    B.

     CTRL + Arrow key

    C.

     CTRL + S

    D.

     None of the above


  5. To return the remainder after a number is divided by a divisor in EXCEL we use the function?

  6. A.

     ROUND ( )

    B.

     FACT ( )

    C.

     MOD ( )

    D.

     DIV ( )


  7. Which function is not available in the Consolidate dialog box?

  8. A.

     Pmt

    B.

     Average

    C.

     Max

    D.

     Sum


  9. Which is not the function of "Edit, Clear" command?

  10. A.

     Delete contents

    B.

     Delete notes

    C.

     Delete cells

    D.

     Delete formats


  11. Microsoft Excel is a powerful ________

  12. A.

     Word processing package

    B.

     Spreadsheet package

    C.

     Communication S/W Package

    D.

     DBMS package


  13. How do you rearrange the data in ascending or descending order?

  14. A.

     Data, Sort

    B.

     Data, Form

    C.

     Data, Table

    D.

     Data Subtotals


  15. Which Chart can be created in Excel?

  16. A.

     Area

    B.

     Line

    C.

     Pie

    D.

     All of the above


  17. What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ?

  18. A.

     5430

    B.

     5436.80

    C.

     5436.8

    D.

     6.8


  19. How do you display current date and time in MS Excel?

  20. A.

     Date ()

    B.

     Today ()

    C.

     Now ()

    D.

     Time ()