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. Which symbol must all formula begin with?

    2. A.

     =
    B.

     +
    C.

     (
    D.

     @

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    3. A.

     =10+50
    B.

     =B7*B1
    C.

     =B7+14
    D.

     10+50

    View Answer

    Workspace

    Discuss Discuss in Forum

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

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

  4. A typical worksheet has ________ number of columns.

    5. A.

     128
    B.

     256
    C.

     1024
    D.

     16384

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    6. A.

     256
    B.

     1024
    C.

     32767
    D.

     65535

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    7. A.

     256
    B.

     1024
    C.

     65535
    D.

     1048576

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    8. A.

     350
    B.

     May 10, 2001
    C.

     0.57
    D.

     Serial Number 50771

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. The chart wizard term data series refers to

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

  9. The Chart wizard term data categories refers to;

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

  10. A worksheet range is a

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

Java Programming Questions and Answers Interview Questions and Answers