Response to the following multiple choice questions:
1. The main input device used with today's personal computers is a
A. mouse.
B. keyboard.
C. cursor.
D. screen element.
2. What will appear on the screen when your computer needs more information from you as you execute a command in a software application?
A. Context sensitive Help
B. Office Assistant
C. A dialog box
D. An ellipsis
3. The ability to place a spreadsheet pie chart into a word processing document is
A. productivity software.
B. interfacing.
C. integration.
D. user-friendly.
4. The collection of fields related to a single client in a client database table is a
A. record.
B. database.
C. character.
D. file.
5. Which one of the following word processing features saves you the most time when keying a document?
A. WYSIWYG
B. Hitting the Delete key
C. Thesaurus
D. Search and replace
6. All of the following statements about writing tools are true except which one?
A. Grammar checkers don't replace the user's good grammar skills.
B. A thesaurus can help you find antonyms of words.
C. You can set your spell checker to automatically replace all misspelled words in a document without any help from you.
D. Spell checkers contain definitions of words as well as spellings.
7. When you add graphics to a spreadsheet file, this means you've added any one of the following except a(n)
A. drawing.
B. photograph.
C. Internet image.
D. word processed document.
8. Your supervisor has asked you to prepare a letter to your organization's 600 stockholders informing them of a quarterly meeting. The productivity software feature that will help you efficiently address the letters and envelopes to the stockholders is
A. mail merge.
B. letter Wizard.
C. macros.
D. Web page creation.
9. Which one of the following correctly expresses a range of cells in a spreadsheet?
A. G25:G100
B. A1, A2, A3, B1, B2, B3
C. M12-M25
D. D3;M3
10. Suppose you entered into a cell of a worksheet the formula A4*G4+(B4*G4)*1.5. If A4 = 40, G4 = 15, and B4 = 4, what will be the results of the calculation?
A. 9060
B. 3000
C. 690
D. 990
11. When you key numbers into a spreadsheet cell, where will they align?
A. In the center of the cell
B. At the right of the cell
C. At the left of the cell
D. Wherever you place the cursor
12. Which one of the following allows you to apply a predesigned format to a selection of spreadsheet cells?
A. Wizard
B. Default formatting settings
C. AutoFormat tool
D. Online Help
13. Which type of chart would best show changes in figures or trends over a period of time?
A. Bar
B. Line
C. Pie
D. Stacked bar
14. Which spreadsheet feature would you use to experiment with the effects of varying product markups to determine the best selling price?
A. WYSIWYG
B. Charting
C. Formulas
D. What-if analysis
15. Which of the following describes an advantage of using an electronic spreadsheet rather than a manual spreadsheet?
A. An electronic spreadsheet automatically checks to make sure that the formulas you enter are correct.
B. With an electronic spreadsheet, you would spend more time formatting the document.
C. An electronic spreadsheet automatically recalculates figures when you change numbers in a cell.
D. Wizards provide help with spreadsheet creation.
16. All of the following are examples of database information except which one?
A. Student name, address, Social Security number, telephone number, major
B. Student name, test #1 grade, test #2 grade, test #3 grade, average
C. Main document file, data source file, merged documents
D. Employee name, pay rate, hours worked, total pay
17. Which one of the following statements about databases is true?
A. You can sort numeric fields in ascending order only.
B. Database tables can be formatted using AutoFormat.
C. The smallest unit of information in a database table is a word.
D. A relationship is built between two database tables with a common field.
18. Which one of the following fields could be used as a database table's primary field?
A. Address
B. Last name
C. Zip code
D. Client number
19. What is the data type for a Social Security number (XXX-XX-XXXX) when creating a data structure?
A. Number
B. Text
C. Number plus text
D. Memo
20. You open a Word document that has an Excel chart in it. You notice that there's an error in the chart. When you go to the Excel source document, you see that the chart there is correct, unlike its copy in Word. More than likely, the spreadsheet chart in Word was
A. cut and pasted.
B. linked.
C. embedded.
D. created in Word.