Site MapHelpFeedbackMixed Quiz
Mixed Quiz
(See related pages)



1

An organized collection of related information that is entered into a series of worksheet rows and columns is called what?
A)List
B)Objects
C)Data
D)Logical operators
2

A list is also referred to as a(n)
A)guide
B)database
C)object
D)data table
3

In a list, each row contains one
A)column
B)field
C)database
D)record
4

This is the smallest unit of information about a record.
A)cell
B)file
C)field
D)list
5

This is a descriptive label that is used to identify the data stored in the field.
A)Data series
B)Argument
C)Data table
D)Field name
6

The area of a worksheet that contains database records is called the
A)list range
B)file range
C)record range
D)field range
7

To create a list, choose
A)Insert/List
B)Data/List/Create List
C)Format/Range/List
D)Edit/Name/Create List
8

The keyboard shortcut to create a new list is what?
A)Ctrl+T
B)Alt+L
C)Ctrl+L
D)Shift+I
9

Excel includes this tool to make it easy to enter database records in a list.
A)Record form
B)List form
C)Field form
D)Data form
10

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

The title of the data form is derived from what?
A)list name
B)cell label
C)worksheet name
D)file name
12

In Excel, the terms "list" and "database" are interchangeable.
A)TRUE
B)FALSE
13

The first column in a list contains field names.
A)TRUE
B)FALSE
14

Field names must be text entries.
A)TRUE
B)FALSE
15

Designating a range as a list lets you manage and analyze the data in the list independently of other data in the worksheet.
A)TRUE
B)FALSE
16

A data form can display a maximum of 16 fields.
A)TRUE
B)FALSE





To learn more about the book this website supports, please visit its Information Center.
(c)2004 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


The O'Leary Series Office 2003Online Learning Center

Home > Excel 2 > Lab 6 > Mixed Quiz