Home / Computer Fundamentals / MS Excel :: section-3

Computer Fundamentals :: MS Excel

  1. To delete an embedded objects, first

  2. A.

     Double click the object

    B.

     Select the object by clicking it

    C.

     Press the Shift + Delete keys

    D.

     Select it and then press the delete key

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Comments can be added to cells using

  4. A.

     Edit > Comments

    B.

     Insert > Comments

    C.

     File > Comments

    D.

     View > Comments

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. Which of the following is not a worksheet design criterion?

  6. A.

     Efficiency

    B.

     Aditibility

    C.

     Description

    D.

     Clarity

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. To copy cell contents using drag and drop press the

  8. A.

     End key

    B.

     Shift key

    C.

     Ctrl key

    D.

     Esc key

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Which of the following is the latest version of Excel

  10. A.

     Excel 2007

    B.

     Excel 2016

    C.

     Excel 365

    D.

     Excel XP

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. When you copy a formula

  12. A.

     Excel erases the original copy of the formula

    B.

     Excel edits cell references in the newly copied formula

    C.

     Excel adjusts absolute cell references

    D.

     Excel doesn’t adjust relative cell references

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. The autofill feature

  14. A.

     Extends a sequential series of data

    B.

     Automatically adds range of cell values

    C.

     Applies a boarder around the selected cells

    D.

     All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. Which menu option can be used to split windows into two

  16. A.

     Format > window

    B.

     View > window > split

    C.

     Window > split

    D.

     View > split

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. Which of the following is an absolute cell reference?

  18. A.

     !A!1

    B.

     $A$1

    C.

     #a#1

    D.

     A1

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. What symbol is used before a number to make it a label?

  20. A.

     ” ( quote )

    B.

     = ( equal )

    C.

     _ ( underscore )

    D.

     ‘ ( apostrophe )

    View Answer

    Workspace

    Discuss Discuss in Forum