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
|
 |