Online Tests 2017

Computer Quiz : Microsoft Excel Set – 1

Dear Aspirants,
Welcome to Online Computer Quiz in Affairscloud.com. Here we are providing sample questions in Microsoft Excel. It will be useful for all SBI/IBPS/LIC exams and other competitive exams. We have also included some important questions that are repeatedly asked in previous exams.

  1. ____________ is a software tool that lets one to enter, calculate, manipulate and analyse set of numbers.
    A. Spread Sheet
    B. Word Processor
    C. Note Pad
    D. None of the above
    Answer
  2. An array of cells is called a _________
    A. Sheet
    B. Work Sheet
    C. Sheet or Work Sheet
    D. None of the above
    Answer
  3. _______ is a document that contains one or more worksheet.
    A. Sheet
    B. Work Sheet
    C. Workbook
    D. None of the above
    Answer
  4. ________ is a cell boundary that specifies which cell is active at that moment.
    A. Row
    B. Column
    C. Cell Pointer
    D. None of the above
    Answer
  5. The letter and number of intersecting column and row is the _______
    A. Cell location
    B. Cell Coordinates
    C. Cell Pointer
    D. Cell address
    Answer
  6. All Excel formula must begin with _____ sign.
    A. +
    B. –
    C. *
    D. =
    Answer
  7. ________ are the graphical and pictorial representation of worksheet data.
    A. Pictures
    B. Charts
    C. Diagrams
    D. None of the above
    Answer
  8. Which of the following is used to define a sequence of actions to perform on a document or multiple documents that can be executed again and again?
    A. Macros
    B. Charts
    C. Clipboard
    D. None of the above
    Answer
  9. Each new Workbook created in Excel has _____ worksheets by default.
    A. One
    B. Two
    C. Three
    D. None of the above
    Answer
  10. A cell in which you are currently working is referred as_________
    A. Active cell
    B. First Cell
    C. Home Cell
    D. None of the above
    Answer