What is Computer Awareness?
Computer Awareness, also known as Computer Aptitude is one of the prominent sections in various recruitment related competitive exams in India. IBPS RRB PO Computer Awareness Quiz 12 lists some of the important questions for the preparation of Computer Awareness module. The most significant topics to be learnt for Computer Awareness module are as follows:
A. Shows the location of the previously active cell
B. Appears to the left to the formula bar
C. Appears below the status bar
D. Appears below the menu bar
Answer: Option B
2. Starting letter of the column is 'A' what would be the end letter?
A. Z
B. VI
C. XFD
D. IV
Answer: Option C
3. What location would be described by the cell E12?
A. Column E on row 12
B. Column 12 on row E
C. Column E
D. All the above
Answer: Option A
4. What is the function of fill handle in MS- Excel ?
A. used to fill data automatically in cell
B. used to set up entry key directive
C. used to make numeric entry
D. used to create shortcut key
Answer: Option A
5. A spreadsheet is the BEST application for ____
A. handling simple accounts
B. writing a report which include tables
C. producing a grid-referenced map
D. keeping an inventory of equipment used
A. Can place a chart on a new chart sheet or on any sheet in the workbook
B. Can only place a chart on new chart sheet
C. Can only place a chart on a new blank worksheet
D. Can only be used to create embedded charts
Answer: Option B
2. In Excel you can zoom a worksheet
A. with the mouse pointer in print preview
B. with the zoom button on the print preview toolbar
C. with the zoom command on the view menu
D. All of the above
Answer: Option D
3. You cannot lick excel worksheet data to a word document
A. With the right drag method
B. with a hyperlink
C. with the copy and paste special commands
D. with the copy and paste button on the standard toolbar
Answer: Option D
4. In Excel -___ is a group of cells that from a rectangle on the screen
A. Calculating
B. Formula
C. Range
D. Range address
Answer: Option C
5. In Excel Documentation should include
A. Destination and users of the output data
B. source of input data
C. Information on the purpose of the workbook
D. All of the above
1. Files created with Lotus 1-2-3 have an extension
A. DOC
B. XLS
C. 123
D. WK 1
Answer: Option C
2. In Excel how many characters can be typed in a single cell?
A. 256
B. 1024
C. 32,000
D. 65,535
Answer: Option D
3. In Excel, the following is not a basic step in creating a worksheet
A. Save worksheet
B. Modify the worksheet
C. Enter text and data
D. allow you to view additional sheets tables
Answer: Option D
4. In Excel to view a cell comment
A. Click the edit comment commands on the Insert menu
B. click the Display comment command on the window menu
C. Position the mouse pointer over the cell
D. Click the comment command on the view menu
Answer: Option C
5. In excel advantage of using a spreadsheet is
A. calculating can be done automatically
B. changing data automatically updates calculations
C. more flexibility
D. All of the above