IBPS PO Mains: Computer Awareness Quiz

Published on Tuesday, October 20, 2015
computer awareness
Q1. To delete embedded object, we should:
a) double click the object
b) select it and then press delete key
c) press the Shift + Delete Keys
d) right click and select properties

Q2. Which type of software contains rows and columns:
a) database
b) word processing
c) drawing
d) spreadsheet
e) presentation 

Q3. You can click the open button on the _______toolbar to open an existing workbook:
a) drawing
b) formatting
c) forms
d) standard
e) visual basic


Q4. Which of the following is not an option in the spelling dialog box?
a) change
b) ignore
c) ignore all
d) edit
e) none of the above


Q5. Which option will help you quickly change the appearance of your work by choosing auto format from the _________menu:
a) format
b) tools
c) edit
d) view
e) file

Q6. What is the easiest method to select a column?
a) click the column label
b) click the column heading
c) drag from the top cell in the column to the last cell in the column
d) double click any cell in the column
e) speak out the column name loudly


Q7. In order to protect a worksheet, we can choose protection, and the protect sheet from which menu?
a) data 
b) format
c) tools
d) edit
e) file


Q8. Which of the following options is not a worksheet design criterion?
a) clarity
b) audit ability
c) description 
d) efficiency
e) any of the above

Q9. If we have to copy cell contents using drag and drop, we will have to press?
a) Esc Key
b) Shift Key
c) End Key
d) Enter Key
e) Any of The Above 

Q10. The cell accepts your typing as its contents if you press:
a) Insert
b) Enter
c) TAB
d) Ctrl + Enter
e) None of The Above

Q11. The purpose of the auto fill features is that it:
a) applies a border around selected cells
b) automatically adds a range of cell values
c) extends a sequential series of data
d) inserts random values in the selected cells
e) none of the above 

Q12. What is the keyboard shortcut key creating a chart from the selected cells?
a) F11
b) F7
c) F5
d) F3
e) F1


Q13. One can use the formula pallette to which of the following functions?
a) copy a range of cells
b) create and edit formulas containing functions
c) entered assumptions data
d) formal cells containing numbers
e) none of the above


Q14. Which of the following Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data has changed?
a) Refresh Data 
b) Pivot Table
c) Show Detail
d) Format Report
e) Any of The Above

Q15. Which of the following is an expression that tell how to numbers in a determined set of cells are to be calculated?
a) Data 
b) Field
c) Query
d) Formula
e) Result

Q16. Which of the following features enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
a) Forecasting
b) Scenario Summary Report
c) Goal Seek
d) Trend Line
e) Magic

Q17. "Qtr 1, Qtr2, Qtr 3" is an example of what?
a) Series 
b) Formula
c) Function
d) Syntax
e) Error 

Q18. How can we convert existing Excel worksheet data and charts to HTML document?
a) By using FTP Wizard
b) By using Internet Assistant Wizard
c) By using Intranet Wizard
d) By using Import Wizard
e) Its not possible to do so


Q19. The cell reference for a range of cells that starts in cell BI and goes over to column G and down to row 10 is:
a) B1.G10
b) G1-G10
c) B1; G10
d) B1:G10
e) BG1:10

Q20. One can open the Highlight changes dialog box by choosing Track Changes from which menu?
a) Format
b) Insert
c) Edit
d) Tools

Can I help you?

ramandeep singh

Hey I am Ramandeep Singh. I am determined to help students prepaing for RBI, SEBI, NABARD and IBPS exams. Do you want me to help you ?

Join my class here
    Follow me:
Close Menu
Close Menu