Computer Question Bank
for Exam preparation

Computer- 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

Computer- 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

Computer- 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

Computer- 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

Computer- 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

Computer- 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

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

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

Computer- Q9. Tree structure displays the

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

Computer- Q10. An application suitable for sequential processing is

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