Computer Question Bank
for Exam preparation

Computer- Q2. Ms Excel:Which function is not available in the Consolidate dialog box?

1. Pmt
2. Average
3. Max
4. Sum

Computer- Q3. Ms Excel:You can automatically adjust the size of text in a cell if they do not fit in width by

1. Double clicking on the right border of column header
2. From Format choose Columns and then Autofit Selection
3. From Format Cells dialog box mark Shrink to fit check box
4. All of above

Computer- Q4. Ms Word: How to remove all character formats?

1. Shift + Spacebar
2. Shift + Enter
3. Ctrl + Spacebar
4. Ctrl + Enter

Computer- Q5. Which command will be used to display only the file name and extensions in wide format?

1. Dir/b
2. Dir A:
3. Dir/s
4. Dir/w

Computer- Q6. It is used to explorer the contents of computer, drives as well as manage files

1. Control Panel
2. My Document
3. My Computer
4. My Network Place

Computer- Q7. Ms Access: What is the type of query that extracts data from a table and puts them into separate table?

1. Parameter query
2. Make table query
3. Update query
4. Put table query

Computer- Q8. Ms Excel:Hyperlinks can be

1. Text
2. Drawing objects
3. Pictures
4. All of above

Computer- Q9. Which of the following is extension of notepad?

1. .txt
2. .bmp
3. .ppt
4. .xls

Computer- Q10. Ms Access: An application that executes on separate PCs like this is called a(n) __________ application.

1. enterprise
2. distributed
3. tier
4. global