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

Computer Fundamentals :: MS Excel

MS Excel - Section-1
MS Excel - section-2
MS Excel - section-3
  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

  2. Comments can be added to cells using

    3. A.

     Edit > Comments
    B.

     Insert > Comments
    C.

     File > Comments
    D.

     View > Comments

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    4. A.

     Efficiency
    B.

     Aditibility
    C.

     Description
    D.

     Clarity

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    5. A.

     End key
    B.

     Shift key
    C.

     Ctrl key
    D.

     Esc key

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    6. A.

     Excel 2007
    B.

     Excel 2016
    C.

     Excel 365
    D.

     Excel XP

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. When you copy a formula

    7. 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

  7. The autofill feature

    8. 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

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

    9. A.

     Format > window
    B.

     View > window > split
    C.

     Window > split
    D.

     View > split

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    10. A.

     !A!1
    B.

     $A$1
    C.

     #a#1
    D.

     A1

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    11. A.

     ” ( quote )
    B.

     = ( equal )
    C.

     _ ( underscore )
    D.

     ‘ ( apostrophe )

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers