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

Financial Analysis, Lookup Functions, and Visual Basic for Applications (VBA)

Multiple Choice

Click on the correct response for each question below.



1

To create an organization chart, choose:
A)Insert, Chart, Organization Chart
B)Insert, Organization Chart
C)Insert, File, Organization Chart
D)Insert, Picture, Organization Chart
2

Which of the following refers to a type of diagram used to show the personnel structure
A)a company or organization?
B)Cycle Diagram
C)Organization Chart
D)Pyramid Diagram D. Target Diagram
3

In a Web Query, the selected areas of a Web page are marked with a
A)black checkmark
B)yellow box
C)green arrow
D)purple dot
4

Which of the following functions is used to calculate sum-of-years-digits depreciation?
A)SYD
B)SLN
C)DDB
D)VDB
5

Which of the following functions is used to calculate straight line depreciation?
A)DDB
B)VDB
C)DB
D)SLN
6

The syntax for referencing data from another worksheet is
A)=SheetName:CellName.
B)=SheetName.CellName.
C)=SheetName!CellName.
D)=SheetName&CellName.
7

To copy a worksheet, choose
A)Edit, Copy.
B)Edit, Copy or Move Worksheet.
C)Edit, Worksheet.
D)Edit, Move.
8

The table that is used to find the results in a lookup function is called what?
A)Lookup_table
B)Array
C)Lookup_index
D)Range_lookup
9

To find the smallest value that is greater than or equal to the lookup value in a Match function, set the Match_type argument to
A)0.
B)-1.
C)1.
D)>=.
10

Written instructions that will then be translated into actual computer code are referred to
A)
B)allegories.
C)macros.
D)machine language. D. pseudocode.
11

Which of the following likes of VBA code will copy the contents of cell B7 in worksheet "expenses" to cell A3 in worksheet "balance"?
A)Worksheets("balance").Cells(3,1).Value=Worksheets("expenses").Cells(7,2).Value
B)Worksheets("expenses").Cells(7,2).Value =Worksheets("balance").Cells(3,1).Value
C)Worksheets("balance").Cells(1,3).Value=Worksheets("expenses").Cells(2,7).Value
D)Worksheets("expenses").Cells(2,7).Value =Worksheets("balance").Cells(1,3).Value




McGraw-Hill/Irwin