White Test2

Test 2

White Form

CS 104

Spring 2001

Multiple Choice: Choose the best answer

1. A Wildcard

a. an asterisk that is used to help you fine tune a search in a database

b. the default Web page

c. the default Web server

d. a new search engine

e. none of the above

2. An anti-virus program ___________________;

a. can be set to run automatically whenever a computer is booted

b. is called a vaccine

c. is available at minimal cost

d. all of above

e. none of the above

3. When using a word processor to create a Web page, you should save the file with a _____extension.

a. DOC

b. HTML

c. TXT

d. URL

e. None of the above

4. To add a graphic to a web page, the format must be

a. JPG

b. GIF

c. BMP

d. IMG

e. a and b

5."AND", "OR", and "NOT" are examples of _______________.

a. false drops

b. Boolean operators

c. Runs

d. Hits

e. None of the above

6. Flat files are created by __________-programs

a. two-dimensional

b. database management

c. file management

d. SQL

e. None of the above

7. When data is kept in a series of unrelated files, the inevitable result is ____________;

a. data integrity

b. data redundancy

c. integration of data

d. both a and b

e. a, b and c

8. Subject directories are built by __________; Web databases are built by __________________--.

a. people, software robots

b. software robots, people

c. HTML, HTTP

d. Infoseek, Yahoo!

e. None of the above

9. What invention enabled developers to create microcomputers?

a. integrated circuit

b. transistor

c. vacuum tube

d. magnetic disk

e. all of the above

10.Which of the following is not true of computers as we progress from one generation to the next?

a. Computer size decreased.

b. Computer cost decreased.

c. Speed of processing increased.

d. Memory/storage capacities decreased

e. All are true

11. Which type of chart is best for showing parts of the whole?

a. area

b. column

c. line

d. pie

e. none of the above

12. What type of chart usually helps you spot trends easily?

a. area

b. column

c. line

d. pie

e. none of the above

13.If the pound signs (#####) fill a cell, it means what?

a. the cell is not active

b. the formula is impossible

c. the column is not wide enough

d. you must recalculate the formula

e. none of the above

14.The contents of the following spreadsheet cells are as follows:

D4 100

A4 99

C4 1

If the formula =IF(D4-A4<=10,-C4*2, 0) is in cell A3, what value is displayed in A3?

a.0

b.-2

c. 2

d. -.02

e. none of the answers

15. An argument in a function can be which of the following?

a. a single cell

b. a range of cells

c. any entered value

d. a, b and c

e. none of the answers

16. When you copy the formula =$C$2 + C3 from cell C4 to D4, what is the resulting formula?

a. =C2+D3

b. =$D$2+D3

c. =$C$2 + C3

d. =$C$2 + D3

e. none of the above

17. If you do not use parenthesis in a formula, which type of calculation takes precedence?

a. exponential calculations

b. multiplication

c. division

d. addition

e. none of the above

18. What function is used to add the values in a range of cell?

a. ADD

b. PLUS

c. SUM

d. TOTAL

e. None of the above

19. What appears in the active cell where you enter a formula?

a. the formula

b. the result of the formula

c. the cell address

d. an equal sign

e. none of the above

20.Which of the following is a valid formula?

a. B3+B4+B5

b. (B3+B4+B5)

c. =B3+B4+B5

d. $b$3+$B$4+$B$5

e. none of the above

21.To identify the range of cells A1 to Z100, type which of the following?

a. A1:z100

b. A1;Z100

c. A1-Z100

d. A1,Z100

e. None of the above

22. K$5 is a

a. relative reference

b. absolute reference

c. mixed reference with row varying

d. mixed reference with the column varying

e. it is not a reference

23. To include all fields in a query, you could:

a. select each field individually

b. select the asterisk (*) in the field list

c. not all fields can be included such as key fields

d. a and b above

e. none of the answers

24.When you sort data in a query

a. the records in the underlying tables are also sorted

b. data can only be sorted by a major sort key

c. if you do not want duplicates to appear, use the Properties command

d. the major sort key must appear to the right of the minor sort key.

e. All of answers are incorrect

Questions: 25 and 26 will use the following Access tables Employee (Figure 1) and Salary (Figure 2):

Figure1: Employee Table

Figure 2: Salary Table

25. Which of the filled in design grid queries will answer the following question:

Display in alphabetical order the last names of employees who live in Indiana who make over $10,000. (IN)

Field:	LastName	StateOrProvince	Salary
Table:	Employee	Employee	Salary
Sort:	Decending
Show:
Criteria:		Like "IN"	>10000
Or:

Field:	LastName	StateOrProvince	Salary
Table:	Employee	Employee	Salary
Sort:	ascending
Show:
Criteria:		Like "IN"
Or:			>10000

Field:	LastName	StateOrProvince	Salary	EmployeeID
Table:	Employee	Employee	Salary	Employee
Sort:	ascending
Show:
Criteria:		Like "IN"		=[EmployeeID]!Salary
Or:			>10000

Field:	LastName	StateOrProvince	Salary
Table:	Employee	Employee	Salary
Sort:	ascending
Show:
Criteria:		Like "IN"	>10000
Or:

e.None of the above

26. Which of the filled in design grid queries will answer the following question:

Display the last names of employees who work in Dept 10 or

Dept 11 and do not have benefits.

Field:	LastName	DepartmentID	benefits
Table:	Employee	Salary	Salary
Sort:
Show:
Criteria:		Like "10"	No
Or:		Like "11"

Field:	LastName	DepartmentID	Benefits
Table:	Employee	Salary	Salary
Sort:
Show:
Criteria:		=10	No
Or:		=11

Field:	LastName	DepartmentID	benefits	EmployeeID
Table:	Employee	Salary	Salary	Employee
Sort:
Show:
Criteria:		=10	No	=[EmployeeID]
Or:		=11

Field:	LastName	DepartmentID	benefits
Table:	Employee	Salary	Salary
Sort:	ascending
Show:
Criteria:		=10	No
Or:		=11	No

e. none of the answers.

27.Which of the following is not a valid relationship?

a.one-to-one

b. one-to-many

c. many-to-one

d. many-to-many

e. all are valid

28. In which view can you modify the structure of a table?

a. Any view

b. Datasheet view

c. Design view

d. Query view

e. none of the answers

29. How should you enter criteria for text fields if the criterion contains punctuation?

a. In all uppercase d. Within quotation marks

b. In all lowercase e. none of the answers

c. In bold

30. In what order are fields included in a query?

a. The order in which you add them. d. Numerical order

b. The order in which they appear in the table. e. None of the answers.

c. Alphabetical order

31. GIF

a. Is a lossless compression d. has no patent protection

b. Is a lossy compression e. None of the answers

c. Is a format used for sound media

32. In Design view, how can you tell that a field is the primary key?

a. The status bar displays text when you have the field selected.

b. There is no way to tell in Design View.

c. The field name is underlined.

d. The key symbol appears on the row selector button.

e. None of the above

33. Which of the following is not a valid data type?

a. Currency d. Text & Numbers

b. Yes/No e. all are valid

c. Text