MS Excel 97 Lesson 6 Review

1. Please provide the following contact information:

   First Name
   Last Name

1. A workbook can have a maximum of 16 worksheets.

   True False
   

2. You can rename a worksheet by first double-clicking the sheet tab.

   True False
   

3. Embedded charts are updated when the worksheet data changes.

   True False
   

4. Charts on a separate chart sheet are not updated when the worksheet data changes.

   True False
   

5. Column charts are most useful for comparing the parts of a whole.

   True False
   

6. Column charts have a category and value axis.

   True False
   

7. The Chart Wizard can only be used to create embedded charts.

   True False
   

8. The Chart menu on the menu bar is only available when a chart is selected.

   True False
   

9. You must select a chart before you can move or resize it.

   True False
   

10. A chart has a portrait orientation when it is first created on a separate chart sheet.

    True False
    

    The rest of the questions are multiple choice.

Multiple Choice Questions

1. Which procedure would you use to change the position of a worksheet in the sheet order?

   No answer a)Double-click the sheet tab then drag the tab to the desired location. b)Click the sheet tab and choose Edit-Move sheet from the menu bar. c)Drag the sheet tab to the desired location. d)None of the above.
   

2. Which command would you use to move an embedded chart to a separate sheet?

   No answer a)Edit-->Move chart b)Chart-->Location c)Chart-->Move d)This cannot be done
   

3. Which chart would be best for showing a trend over a period of time?

   No answer a)Line chart b)Bar chart c)Column chart d)Pie chart
   

4. Which technique can be used to insert Data Labels after a chart has been created?

   No answer a)Select the chart and click the Data Labels button on the Chart toolbox. b)Select the chart and choose the lnsert-->Data Labels command. c)Select the chart, choose Chart-options, and then click the Data Labels tab. d)Data labels cannot be inserted after a chart has been created.
   

5. Which technique can be used to explode a single pie slice?

   No answer a)Select the chart, click anywhere on the pie and drag the slice. b)Click the chart, click the pie, click the desired slice, and then drag it. c)Click the chart, double-click the pie and drag the slice. d)None of the above.