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

Customizing Excel

Multiple Choice

Click on the correct response for each question below.



1

To make a circle drawing object appear to be under a rectangle drawing object,
A)right-click the rectangle and choose Order/Send Backward.
B)right-click the circle and choose Order/Bring Forward.
C)right-click the rectangle and choose Order/Bring Forward.
D)right-click the circle and choose Order/Bring to Front.
2

Excel templates that you want to activate automatically when Excel opens are stored in what folder?
A)Start
B)XLStart
C)OfficeStart
D)Office
3

To add a button to a displayed toolbar, select it from the Customize dialog box and
A)click the Add command button.
B)right-click it and select "Add to…".
C)drag it to the toolbar.
D)click the Modify Selection command button.
4

To move a button from one location on a toolbar to another, hold down which key while dragging it?
A)Shift
B)Control
C)Alt
D)Insert
5

The special file that contains Excel's toolbar and menu settings is called what?
A)the Registry
B)xlstart.xlt
C)Excel.xlb
D)book1.xls
6

In a 3D chart, the XY plane is referred to as what?
A)ceiling
B)floor
C)wall
D)horizon
7

The syntax for the TREND function is
A)=TREND(known y values, known x values, new x values, constant).
B)=TREND(known x values, known y values, new y values, constant).
C)=TREND(new x values, known x values, known y values, constant).
D)=TREND(new y values, known y values, known x values, constant).
8

Shared workbooks have an automatic tracked changes feature spanning
A)10 days.
B)20 days.
C)30 days.
D)60 days.
9

Which of the following is not accessed in the Share Workbook dialog box?
A)which users' changes are highlighted
B)how many days to keep tracked changes history
C)when to update changes made to the workbook
D)how to resolve conflicting changes
10

The file extension for a workspace is
A).xlt.
B).xls.
C).mht.
D).xlw.
11

When you open a workspace that contains workbooks that are already open, Excel will
A)not open the open workbooks.
B)ask you if you would like to save before reopening.
C)open another instance of the workbook.
D)ask if you would like to update your links




McGraw-Hill/Irwin