1. Special effects used to introduce slides in a presentation are called
a. Effects
b. Custom animations
c. Transitions
d. Present animations
2. What is the purpose of indexing?
a. To reduce table size
b. To speedup data search
c. Both a & b
d. None of the above
3. You can edit a cell in spreadsheet by
a. Clicking the formula button
b. Double clicking the cell to edit it in place
c. Selecting Edit > Edit cell from the menu
d. None of the above
4. Which function will calculate the number of workdays between 6/11/2012 and 8/12/2012 in spreadsheet?
a. Workday
b. Date
c. Net workdays
d. All of above
5. Which of the following is not a valid data type in Excel?
a. Number
b. Character
c. Label
d. Date/time
6. The file type ___ indicates the file is a word document
a. .msw
b. .wor
c. .wrd
d. .doc
7. How can you make the selected character superscripted in word document?
a. Ctrl+=
b. Ctrl+Shift+=
c. Alt+Ctrl+Shift+=
d. None of the above
8. What is the short cut key to open Font dialog box in MS Word?
a. Ctrl+F
b. Alt+Ctrl+F
c. Ctrl+D
d. Ctrl+Shift+D
9. A ___ acts as a security buffer between a company’s private network and all extern
a. Firewall
b. Password
c. Disaster recovery plan
d. Virus checker
10. Protecting the data from unauthorized access is called
a. Data inaccessibility
b. Data encryption
c. Data security
d. Data validation
11. Which of the following is responsible for coordinating various operations using timing signals?
a. Arithmetic-logic unit
b. Control unit
c. Memory unit
d. I/O unit
12. A computer consists of
a. A central processing unit
b. Control unit
c. Memory unit
d. I/O unit
13. Which of the following package is used to create slides for presentation?
a. MS-Word
b. MS-Excel
c. MS-PowerPoint
d. MS-Access
14. Which of the following is DBMS?
a. MS-Word
b. MS-Excel
c. MS-PowerPoint
d. MS-Access
15. Which of the following formula is entered correctly?
a. =sum( A1A10: )
b. =sum( :A1A10 )
c. =sum ( A1:A10 )
d. All of above
16. Each excel file is called a workbook, because
a. It can contain text and data
b. It can be modified
c. It can contain many sheets
d. You have to work hard to create it
17. Which of the following shortcut key is used to select all the contents of a MS Word document?
a. Ctrl+B
b. Ctrl+A
c. Ctrl+C
d. Ctrl+V
18. In word processing, the task of changing the appearance of a document is called
a. Formatting
b. Editing
c. Proofing
d. Inserting
19. MS Word is an example of
a. Word processor
b. Spreadsheet
c. Presentation
d. DBMs
20. Which of the following network device is used to connect different networks?
a. Hub
b. Switch
c. Router
d. None of above
21. The output quality of a printer is measured by
a. Dots per square inch
b. Dots per inch
c. Dots printed per unit time
d. All of the above
22. Which of the following memory is volatile?
a. RAM
b. ROM
c. PROM
d. EPROM
23. Which command will you choose to convert a column of data into row?
a. Cut and Paste
b. Edit >> Paste Special >> Transpose
c. Both a and b
d. None of the above
24. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
a. F8
b. F9
c. F10
d. F11
25. How can you show or hide the gridlines in Excel worksheet?
a. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
b. Check gridline tool on forms toolbar
c. Both a and b
d. None of the above
26. What is the purpose of inserting header and footer in document?
a. To enhance the overall appearance of the document
b. To mark the starting and ending of page
c. To make large documents more readable
d. To allow page headers and footers appear on document when printed
27. Which features help you to setup document page size in Microsoft Word?
a. Page setup
b. Print setup
c. Styles
d. Print preview
28. Which of the following is the symptom of the virus?
a. It must execute itself
b. It often places its own code in the part of execution of another program
c. It must replicate itself
d. All of the above
29. Which of the following protocol is used to receive email?
a. SMTP
b. POP3
c. TCP/IP
d. None of the above
30. Which of the following is the operating system?
a. Microsoft Word
b. Microsoft Excel
c. Microsoft Windows 7
d. All of above