McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Data Files
Buzz in IT
Updates
Concepts
Flashcards
Multiple Choice Quiz
Puzzlers
Feedback
Help Center


Office XP Excel 2002
Office XP Excel 2002, 2/e
Timothy O'Leary, Arizona State University

Creating and Using an Excel Database

Multiple Choice Quiz

Click on the correct response for each question below.



1

Each row in a list contains this.
A)Record
B)Field
C)Formula
D)Reference
2

In the Sort dialog box, this order is the default setting.
A)Descending
B)Ascending
C)Right to Left
D)Left to Right
3

This is a program that connects to remote computers and displays the Web pages you request.
A)Server
B)Host
C)Link
D)Browser
4

The area containing the records is called the
A)field range.
B)record range.
C)list range.
D)file range
5

This option in the drop-down list displays all records regardless of the value in this field.
A)(NonBlanks)
B)(Custom)
C)(Blanks)
D)(All)
6

Excel generates a data form from
A)records.
B)cells.
C)field labels.
D)database files.
7

When creating a hyperlink between workbooks, the hyperlink automatically displays the path of the linked file if you don’t enter anything in this box in the Insert Hyperlink dialog box.
A)Browsed Pages
B)Current Folder
C)Address
D)Text to Display
8

When saving a worksheet as a Web page the default file name in the Save As dialog box is the same as the workbook file name with the Web page file extension of
A).xls.
B).doc.
C).html.
D).txt.
9

In the Select Place in Document dialog box, the list box will display this to show the outline of the information in the workbook and named ranges.
A)Reference points
B)Objects
C)Tree diagram
D)Link outline
10

This is a computer that stores discussion text and information about the location of the file being discussed.
A)Remote server
B)Online server
C)Discussion server
D)Web page server
11

A single sort operation can be based on up to this number of columns or fields of data.
A)One
B)Two
C)Three
D)Four




McGraw-Hill/Irwin