Student Center
|
Instructor Center
|
Information Center
|
Home
Glossary
Data Files
Buzz in IT
Choose a Chapter
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Chapter 11
Chapter 12
Learning Objectives
Chapter Outline
Prerequisites
Multiple Choice Quiz
Short Answer
True or False
Case Problems
Hands-On Exercises
Feedback
Help Center
Advantage Series: Microsoft® Excel 2002
Sarah Hutchinson-Clifford
Glen Coulthard
Automating And Extending Excel
Multiple Choice Quiz
Click on the correct response for each question below.
1
Which of the following lookup and reference functions returns the column where a particular entry resides?
A)
INDEX
B)
MATCH
C)
HLOOKUP
D)
VLOOKUP
2
Which of the following characteristics make up a good password?
A)
Use of upper and lower case letters
B)
Numbers
C)
Symbols
D)
All of the above
3
AutoTemplates must be stored in the __________ folder.
A)
AutoTemp
B)
ExcelTemp
C)
XLStart
D)
XLAutoTemp
4
If you need imported data to update automatically, you can use the following importing method:
A)
Pasting
B)
Linking
C)
Embedding
D)
Either A or C
5
XML stands for
A)
Extendible Markup Language
B)
Excel Markup Language
C)
Extensible Markup Language
D)
Extraneous Markup Language
2002 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
.