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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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 ( )

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  8. A.

     Pmt

    B.

     Average

    C.

     Max

    D.

     Sum

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  10. A.

     Delete contents

    B.

     Delete notes

    C.

     Delete cells

    D.

     Delete formats

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Microsoft Excel is a powerful ________

  12. A.

     Word processing package

    B.

     Spreadsheet package

    C.

     Communication S/W Package

    D.

     DBMS package

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. Which Chart can be created in Excel?

  16. A.

     Area

    B.

     Line

    C.

     Pie

    D.

     All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  20. A.

     Date ()

    B.

     Today ()

    C.

     Now ()

    D.

     Time ()

    View Answer

    Workspace

    Discuss Discuss in Forum