Computer Question Bank
for Exam preparation

Q2. Ms Excel:To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

1. HTML
2. Pivot Table Field List
3. Pivot Table List
4. Pivot Table Report

Q3. Ms Access: This key uniquely identifies each record

1. primary key
2. key record
3. unique key
4. field name

Q4. Ms Access: In MS Access, Text Data type may contain maximum character of

1. 255 Character
2. 256 Character
3. 1064 Character
4. No Limit

Q5. Ms PowerPoint:This is the menu command used to apply a design template in PowerPoint.

1. Tools -> Slide Design
2. Format -> Slide Design
3. Insert -> Slide Design
4. Insert -> Slide Design

Q6. Identify the true statement

1. Computers are 100% accurate but it can suffer from GIGO
2. Computers are reliable because they use electronic component which have very low failure rate
3. Computer is never tired and does not suffer from boredom
4. All of above

Q7. Ms Access: A collection of related records in database is known as a

1. Table
2. Database
3. File
4. None of above

Q8. Ms Excel:The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

1. None of these
2. Select Format > Money from the menu
3. Click the Currency Style button on the formatting toolbar
4. You have to retype everything and manually add the dollar signs, commas, and decimals.

Q9. Ms Excel:A numeric value can be treated as a label value if it precedes with

1. Apostrophe (&lsquo
2. Exclamation (!)
3. Hash (#)
4. Ampersand (&

Q10. Ms PowerPoint:The size of a table object

1. Is dependent on the amount of text within the table
2. Is determined by the presentation design but can be changed
3. Is determined by the presentation design and cannot be changed
4. a and c