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. Getting data from a cell located in a different sheet is called ________

    2. A.

     Accessing
    B.

     Referencing
    C.

     Updating
    D.

     Functioning

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Tab scrolling button

    3. A.

     Allow you to view a different worksheet
    B.

     Allow you to view additional worksheet rows down
    C.

     Allow you to view additional worksheet columns to the right
    D.

     Allow you to view additional sheets tabs

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. A numeric value can be treated as a label value if it precedes with

    4. A.

     Apostrophe (')
    B.

     Exclamation (!)
    C.

     Hash (#)
    D.

     Ampersand (&)

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. Concatenation of text can be done using

    5. A.

     Apostrophe (')
    B.

     Exclamation (!)
    C.

     Hash (#)
    D.

     Ampersand (&)

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. Data can be arranged in a worksheet in a easy to understand manner using

    6. A.

     Auto formatting
    B.

     Applying styles
    C.

     Changing fonts
    D.

     all of above

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. You can use drag-and-drop to embed excel worksheet data in a word document

    7. A.

     By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
    B.

     By dragging a range of excel data to the word button on the taskbar while pressing Shift key
    C.

     By dragging a range of excel data to the word button on the taskbar while pressing Alt key
    D.

     None of above

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. The auto calculate feature

    8. A.

     Can only add values in a range of cells
    B.

     Provides a quick way to view the result of an arithmetic operation on a range of cells
    C.

     Automatically creates formulas and adds them to a worksheet
    D.

     A and C

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Excel uniquely identifies cells within a worksheet with a cell name

    9. A.

     Cell names
    B.

     Column numbers and row letters
    C.

     Column letters and row numbers
    D.

     Cell locator coordinates

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers