Current Affairs PDF

Computer Quiz : Microsoft Excel Set – 1

AffairsCloud YouTube Channel - Click Here

AffairsCloud APP Click Here

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
    A. Spread Sheet

  2. An array of cells is called a _________
    A. Sheet
    B. Work Sheet
    C. Sheet or Work Sheet
    D. None of the above
    C. Sheet or Work Sheet

  3. _______ is a document that contains one or more worksheet.
    A. Sheet
    B. Work Sheet
    C. Workbook
    D. None of the above
    C. Workbook

  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
    C. Cell Pointer

  5. The letter and number of intersecting column and row is the _______
    A. Cell location
    B. Cell Coordinates
    C. Cell Pointer
    D. Cell address
    D. Cell address

  6. All Excel formula must begin with _____ sign.
    A. +
    B. –
    C. *
    D. =
    D.=

  7. ________ are the graphical and pictorial representation of worksheet data.
    A. Pictures
    B. Charts
    C. Diagrams
    D. None of the above
    B. Charts

  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
    A. Macros

  9. Each new Workbook created in Excel has _____ worksheets by default.
    A. One
    B. Two
    C. Three
    D. None of the above
    C. Three

  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
    A. Active cell