Computer Question Bank
for Exam preparation

Q2. Ms Excel:What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

1. An absolute cell address is create
2. Cell address will change when it is copied to another cell.
3. The sheet tab is change
4. The status bar does not display the cell address.

Q3. Ms Excel:To insert three columns between columns D and E you would

1. Select column D
2. Select column E
3. Select columns E, F and G
4. Select columns D, E, and

Q4. CAD stands for

1. Computer aided design
2. Computer algorithm for design
3. Computer application in design
4. All of the above

Q5. The contribution of Konrad Zuse was long ignored because

1. He made the computers secretly
2. his computers were very complicated and it took time for the people to recognize its power
3. of political reasons. He was German.
4. All of the above

Q6. Ms Excel:You cannot link excel worksheet data to a word document

1. With the right drag method
2. With a hyperlink
3. With the copy and paste special commands
4. With the copy and paste buttons on the standard toolbar.

Q7. Ms PowerPoint:When an image is selected, it displays which of the following?

1. Two corner handles
2. Six middle handles
3. Eight sizing handles
4. Six boxes

Q8. Ms Access: What is the process of eliminating redundant fields by separating data into tables called?

1. Renormalizations
2. Filtering
3. Normalization
4. Sorting

Q9. Ms Excel:The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….

1. G1-G10
2. B1.G10
3. B1;G10
4. B1:G10

Q10. Ms Excel:If the values in A1 is “MCQ” and B1 is “Questions”, which function will return [email protected] in cell C1?

1. =A1 + [email protected] + B1
2. =A1 # [email protected] # B1
3. =A1 & [email protected] & B1
4. =A1 $ [email protected] $ B1