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

Computer Fundamentals :: MS Excel

  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


  3. Tab scrolling button

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


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

  6. A.

     Apostrophe (')

    B.

     Exclamation (!)

    C.

     Hash (#)

    D.

     Ampersand (&)

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Concatenation of text can be done using

  8. A.

     Apostrophe (')

    B.

     Exclamation (!)

    C.

     Hash (#)

    D.

     Ampersand (&)

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  10. A.

     Auto formatting

    B.

     Applying styles

    C.

     Changing fonts

    D.

     all of above

    View Answer

    Workspace

    Discuss Discuss in Forum


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

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


  13. The auto calculate feature

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


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

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