In this sample test there are 33 questions taken from the covered material. This sample provides you with the type of questions that will be covered in the lecture test. Some or none of these questions will be on the actual test.
Multiple Choice ( choose the most appropriate answer)
1. Which of the following is descriptive of electronic spreadsheets?
a. They can answer what-if questions very quickly.
b. They can include graphs to show trends and proportions.
c. They can include column headings, row labels and formulas.
->d. all of the above
e. none of the above
2. The term used to describe the consistency of data in all applications is ___.
a. file integration
b. data dependence
c. data security
->d. data integrity
e. none of the above
3. Flat files are created by ________ programs
a. two-dimensional
->b. file management
c. database management
d. hierarchical files
e. none of the above
4. Computer viruses _____________.
a. can be transmitted from computer A to computer B to computer C without doing any damage to computer to computer B.
b. can be transmitted via modem, floppy disk, and hard disk.
c. can remain in a computer even after it is turned off.
->d. all of the above.
5. Which of the following is an advantage of the Filter over the Find command?
a. A filter displays records that meet specified criteria.
b. A filter will search the entire database.
->c. A filter can search on multiple criteria.
d. A filter is not case sensitive.
6. A row in a database is known as a(n)
a. relation.
b. attribute
->c. record
d. field
e. none of the above
7. _______________________ are the entries at the top of every column
and beginning of every row that help the user to understand the
information contained in a spreadsheet.
a. headings
b. titles
c. documentation
->d. labels
e. none of the answers.
8.An entry will be preceded by quotation marks(") if it is a
a. quotation.
->b. text entry.
c. numeric entry
d. formula.
e. none of the answers.
9.The formula =B7+B8+B9 has been entered in B11. If the formula is copied
to C11, what will the formula read in C11?
a. =B11+B12+B13
b. =B7+B8+B9
->c. =C7+C8+C9
d. =C11+C12+C13
e. none of the answers.
10. Which database object do you use to display information for
one record at a time
a. table -> d. form
b. report e. none of the answers
c. query
11. In a spreadsheet datasheet, the intersection of a row and a column is
called a:
-> a. cell d. record
b. cursor e. none of the answers
c. form
12. You have the choice of either creating a table structure from
scratch or using a(n) ________ to lead you through the process.
a. assistant -> d. wizard
b. coach e. none of the answers
c. relation
13. Which data type would you use to store a phone number?
a. Currency -> d. Text
b. Memo e. none of the answers
c. Number
14. A collection of records matching the parameters of a query is
sometimes called a:
-> a. dynaset d. query
b. field e. none of the answers
c. table
15. Which of the following criteria returns only those cities
beginning with the letter "B"?
a. =B d. B#
-> b. B* e. none of the answers
c. B?
16. Which of the following criteria returns the name "Jones" as a
match?
->a. *ne* d. ?ne*
b. J??nes e. none of the answers
c. ?ne*
17. Which of the following statements is false?
a. A filter operation limits records displayed in a datasheet.
b. A query operation returns a Datasheet window of results.
c. A sort operation modifies the natural order of data in
a table
d. A find operation that is successful moves the cursor to the
record.
-> e. all are true.
18. The type of database where individual tables are linked by
a common field is called what? Hint: Access is this type.
a. linked database d. common field database
-> b. relational database e. None of the answers
c. object database
19. What term is used to describe the repetition of a data item
in several files?
a. data integrity d. data security
-> b. data redundancy e. None of the answers
c. data dependence
20. Which of the following are commonly found on Web pages?
-> a. hyperlinks d. a,b and c
b. Internet e. none of the answers
c. intranet
21. A formula in a spreadsheet can contain
a. Numbers -> d. a,b,and c
b. cells e. None of the answers
c. Operators
22. Each of the following is true about values, except
a. They can include labels d. They can include formulas
b. They are right-aligned, by default ->e. all are true
c. They are used in calculations
23. What type of cell reference changes when it is copied?
a. absolute -> d. relative
b. circular e. all change
c. looping
24. Which character is used to make a reference absolute?
a. & b. ^ ->c. $ d. @ e. no symbol is necessary
25. You begin spreadsheet formulas with which character
a. ! d. $
b. & e. Does not require a
-> c. = special character
26. Which of the following is a built-in Excel function?
a. SUM -> d. a,b, and c
b. IF e. Excel has no built-in
c. AVERAGE functions
27. A ________ is a block of adjacent cells in a spreadsheet.
-> a. range b. group c. highlight d. format e. none of the answers
28. Which of the following is the best example of what-if analysis?
a. Decreasing column widths to seven characters to see how many more
columns can be displayed in the window.
-> b. Decreasing Cost of Goods Sold to see the effect on Net Income
c. Displaying columns B and Z in the same window
d. Changing a font to see how it affects the display to a title
e. none of the answers
29. When specifying criteria on alphabetic data, the case of the characters,
upper or lower, in the filter is significant.
a. True -> b. False
30. Copied or cut cells are sent where?
a. Memory Board d. AutoCut area
-> b. Clipboard e. they are just discarded
c. AutoCopy area
31. If you accidentally delete a cell, you can click the ______ button to restore it.
a. Copy d. Paste
b. Retrieve e. you cannot restore a deleted cell
->c. Undo
32. If you accidentally delete a record, you can click the ______ button to restore it.
a. Copy d. Paste
b. Retrieve -> e. you cannot restore a deleted record
c. Undo
33. Boolean logic (not, and, or) is of no help when doing a search on the Web.
a. True -> b. False