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

Computer Fundamentals :: MS Excel

  1. Which symbol must all formula begin with?

  2. A.

     =

    B.

     +

    C.

     (

    D.

     @

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Which of the following formulas is not entered correctly?

  4. A.

     =10+50

    B.

     =B7*B1

    C.

     =B7+14

    D.

     10+50

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. Which of the following formulas will Excel not be able to calculate?

  6. A.

     =SUM(Sales)-A3

    B.

     =SUM(A1:A5)*.5

    C.

     =SUM(A1:A5)/(10-10)

    D.

     =SUM(A1:A5)-10

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. A typical worksheet has ________ number of columns.

  8. A.

     128

    B.

     256

    C.

     1024

    D.

     16384

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. How many characters can be typed in a single cell in Excel?

  10. A.

     256

    B.

     1024

    C.

     32767

    D.

     65535

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. A worksheet can have a maximum of ________ number of rows.

  12. A.

     256

    B.

     1024

    C.

     65535

    D.

     1048576

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. Which of the following is not an example of a value?

  14. A.

     350

    B.

     May 10, 2001

    C.

     0.57

    D.

     Serial Number 50771

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. The chart wizard term data series refers to

  16. A.

     A chart legend

    B.

     A collection of chart data markers

    C.

     A set of values you plot in a chart

    D.

     A data label

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. The Chart wizard term data categories refers to;

  18. A.

     A chart plot area

    B.

     A horizontal axis

    C.

     The organization of individual values with a chart’s data series

    D.

     The data range that supply chart data

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. A worksheet range is a

  20. A.

     A command used for data modeling

    B.

     A range of values such as from 23 to 234

    C.

     A group of cells

    D.

     A group of worksheets

    View Answer

    Workspace

    Discuss Discuss in Forum