Computer Question Bank
for Exam preparation

Q2. Ms Excel:You can check the conditions against __________ when applying conditional formatting

1. Cell value
2. Formula
3. Both of above
4. None of above

Q3. 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

Q4. Ms Excel:You can open the Sort dialog box by choosing Sort from the ….. menu

1. View
2. Format
3. Tools
4. Data

Q5. Ms Word: Which of the following is not essential component to perform a mail merge operation?

1. Main document
2. Data source
3. Merge fields
4. Word fields

Q6. CAD stands for

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

Q7. Controlling access to a network by analyzing the incoming and outgoing packets is called

1. IP Filtering
2. Data Filtering
3. Packet Filtering
4. Firewall Filtering

Q8. As compared to diskettes, the hard disks are

1. More expensive
2. More portable
3. Less rigid
4. Slowly accessed

Q9. Ms Excel:Weight refers to

1. The print density of characters
2. The height of the printed character
3. Upright or slanted shape
4. The design and appearance of characters

Q10. 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