Computer Awareness Quiz - MS Excel

1. Function in Ms-Excel to count number of cells.
      (a) COUNTIF
      (b) DIVIF
      (c) SUBIF
      (d) EOUNTIF
      (e) None of these

 2. Function to find out how much money you will have in the bank in you invest over a fixed period, using a fixed rate of interest.
     (a) RS (----)
     (b) HP (----)
     (c) FV (----)
     (d) ST (----)
     (e) None of these

3. Function to find present value of a sum of money.
    (a) OP (----)
    (b) JU (----)
    (c) RT (----)
    (d) PV (----)
    (e) None of these

4. You cannot link Excel worksheet data to a Word document.
     (a) with the right drag method
     (b) with the hyperlink
     (c) with the copy and paste special commands
     (d) All of these
    (e) None of these

5. In Excel, Chart are created using which option?
    (a) Chart Wizard
    (b) Pivot Table
    (c) Pie Chart
    (d) Bar Chart
    (e) None of these

 6. Charts can be of two types. They are __________ and __________.
    (a) Embedded chart, Chart sheet
    (b) Embedded chart, Chart area
    (c) Both A & B
    (d) All of the above
    (e) None of these

7. In Excel you can copy cell formats from one cell to another by using the.
    (a) Backspace key
    (b) Default font
    (c) Format painter
    (d) Formatting toolbar
    (e) None of these

8. In Excel following term describes explanatory text attached to a cell.
    (a) Call out
    (b) Comment
    (c) Dialog
    (d) Extension
    (e) None of these

9. In Excel the auto fill feature.
    (a) Extends a sequential series of data
    (b) Automatically adds a range of cell values
    (c) Applies a boarder around selected cells
    (d) All of the above
    (e) None of above

10. In Excel which elements of worksheet can be protected from accidental modification?
      (a) Contents
      (b) Objects
      (c) Scenarios
      (d) All of above
      (e) None of these

 11. Right clicking something in Excel.
      (a) Deletes the object
      (b) Nothing the right mouse button is there for left handed people
      (c) Opens a shortcut menu listing everything you can do to the object
      (d) Selects the object
      (e) None of these

12. In Excel worksheet can have a maximum of _________ Number of rows.
      (a) 256
      (b) 1024
      (c) 32,000
      (d) 65,535
      (e) None of these

13. In Excel data can be arranged in a worksheet in a easy to understand manner using.
      (a) Auto formatting
      (b) Applying styles
      (c) Changing fonts
      (d) All of above
      (e) None of these

 14. In Excel on an excel sheet the active cell is indicated by.
      (a) A dark wide border
      (b) A dotted border
      (c) A blinking border
      (d) All of the above
      (e) None of these


2. FV (----)
3. PV (----)
4. All of these
5. Chart Wizard
6. Embedded chart, Chart sheet
7. Format painter
8. Comment
9. None of above
10. All of above
11. Opens a shortcut menu listing everything you can do to the object
12. 65,535
13. All of above
14. A dark wide border


Download Computer Awareness Notes for free here

Join 40,000+ readers and get free notes in your email


Post a Comment

Thanks for commenting. It's very difficult to answer every query here, it's better to post your query on