Computer Question Bank
for Exam preparation

Q2. Ms Excel:Which option allows you to Bold all the negative values within the selected cell range:

1. Zero Formatting
2. Conditional Formatting
3. Compare Formatting
4. Negative Formatting

Q3. Ms Excel:If the cell B1 contains the formula = $A$1, which of the following statements is true

1. There is a relative reference to cell A1
2. There is an absolute reference to cell A1
3. Further changes in value of A1 will not affect the value of B1
4. Further changes in value of B1 will affect the value of A1

Q4. Ms Access: In access, this operation copies a backup file from the storage medium back onto the computer

1. Recreate
2. Restore
3. Copy
4. Structure

Q5. An output device that uses words or messages recorded on a magnetic medium to produce audio response is

1. Magnetic tape
2. Voice response unit
3. Voice recognition unit
4. Voice band

Q6. Ms Access: If a color property contains “#336699”, how many blue units are in the color?

1. 33
2. 66
3. 99
4. 255

Q7. Ms Access: Which of the following data type is used to store logical value in MS Access?

1. True/False
2. On/Off
3. Yes/No
4. All of Above

Q8. Ms Access: The file extension for an access 2003 database is

1. Exe
2. Doc
3. Exc
4. Mdb

Q9. Tree structure displays the

1. File only
2. Directory only
3. File and directory name
4. None of above

Q10. An application suitable for sequential processing is

1. Processing of grades
2. Payroll processing
3. Both a and b
4. All of above