New Student User - Use Code HELLO

Register Now

Computer Awareness Quiz - MS Excel

Published on Saturday, March 26, 2016
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
ebook store

About us

ramandeep singh

Ramandeep Singh is a seasoned educator and banking exam expert at BankExamsToday. With a passion for simplifying complex concepts, he has been instrumental in helping numerous aspirants achieve their banking career goals. His expertise and dedication make him a trusted guide in the journey to banking success.

  • Follow me:
Close Menu
Close Menu