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

Computer Fundamentals :: MS Excel

MS Excel - Section-1
MS Excel - section-2
MS Excel - section-3
  1. How do you display current date only in MS Excel?

    2. A.

     Date ()
    B.

     Today ()
    C.

     Now ()
    D.

     Time ()

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. How do you wrap the text in a cell?

    3. A.

     Format, cells, font
    B.

     Format, cells, protection
    C.

     Format, cells, number
    D.

     Format, cells, alignment

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. What does COUNTA () function do?

    4. A.

     Counts cells having alphabets
    B.

     Counts empty cells
    C.

     Counts cells having number
    D.

     Counts non-empty cells

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. What is the short cut key to highlight the entire column?

    5. A.

     Ctrl + C
    B.

     Ctrl + Enter
    C.

     Ctrl + Page Up
    D.

     Ctrl + Space Bar

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. In the formula, which symbol specifies the fixed columns or rows?

    6. A.

     $
    B.

     *
    C.

     %
    D.

     &

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. Excel displays the current cell address in the ________

    7. A.

     Formula bar
    B.

     Status Bar
    C.

     Name Box
    D.

     Title Bar

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. What is the correct way to refer the cell A10 on sheet3 from sheet1?

    8. A.

     Sheet3!A10
    B.

     Sheet1!A10
    C.

     Sheet3.A10
    D.

     A10

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Which language is used to create macros in Excel?

    9. A.

     Visual Basic
    B.

     C
    C.

     Visual C++
    D.

     Java

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Which of the following is not a term of MS-Excel?

    10. A.

     Cells
    B.

     Rows
    C.

     Columns
    D.

     Document

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. How many worksheets can a workbook have?

    11. A.

     3
    B.

     8
    C.

     255
    D.

     none of above

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers