This assessment tool is for your own use, to help you determine if you have mastered the skills needed to participate successfully in Excel 4.
In addition to the skills needed for Excel 1, 2, and 3, I know how to:
| insert a chart on a new worksheet | Yes | No | Not sure | |
| insert a chart on the current worksheet | Yes | No | Not sure | |
| specify the range of cells to be shown on a chart | Yes | No | Not sure | |
| tell when to use a line chart vs. an XY (scatter) chart | Yes | No | Not sure | |
| select a specific chart type and format | Yes | No | Not sure | |
| preview how the chart will look | Yes | No | Not sure | |
| use a row or column to specify the chart's x-axis labels | Yes | No | Not sure | |
| use a row or column to specify the chart's legend text | Yes | No | Not sure | |
| add a legend | Yes | No | Not sure | |
| specify a chart title and axis labels | Yes | No | Not sure | |
| differentiate between selecting and opening a chart | Yes | No | Not sure | |
| resize a chart | Yes | No | Not sure | |
| move a chart | Yes | No | Not sure | |
| move an object within a chart | Yes | No | Not sure | |
| edit the chart title and axis labels | Yes | No | Not sure | |
| edit the chart legend | Yes | No | Not sure | |
| add a new series or data to the chart | Yes | No | Not sure | |
| delete legends, chart title, axis labels, and series | Yes | No | Not sure | |
| change the chart type (e.g., from pie chart to bar chart) | Yes | No | Not sure | |
| customize the color of the chart's background text, plot area and border | Yes | No | Not sure | |
| rename a data series | Yes | No | Not sure | |
| change a data series' color and markers | Yes | No | Not sure | |
| add error bars and data labels to a series | Yes | No | Not sure | |
| change the scale of the X or Y axis | Yes | No | Not sure | |
| add major and minor tick marks on an axis | Yes | No | Not sure | |
| position and format tick mark labels | Yes | No | Not sure | |
| add a label to an individual data point | Yes | No | Not sure | |
| delete chart that is on a sheet by itself | Yes | No | Not sure | |
| on a sheet with other objects, delete only the chart | Yes | No | Not sure | |
| begin recording a macro | Yes | No | Not sure | |
| specify the name and description of a macro | Yes | No | Not sure | |
| specify the storage location of a macro | Yes | No | Not sure | |
| stop recording a macro | Yes | No | Not sure | |
| run a macro | Yes | No | Not sure | |
| attach a macro to the "Tools" menu | Yes | No | Not sure | |
| remove a macro from the "Tools" menu | Yes | No | Not sure | |
| assign a macro to a button on a sheet | Yes | No | Not sure | |
| remove a macro from a button on a sheet | Yes | No | Not sure | |
| assign a macro to a button on a toolbar | Yes | No | Not sure | |
| remove a macro from a button on a toolbar | Yes | No | Not sure | |
| view the Personal Macro Workbook | Yes | No | Not sure |
In Excel 4, we assume that you have mastered key concepts covered in Excel 1 through Excel 3. We want you to use your time effectively, and to get the most out of each course you take.
If you answered "No" or "Not sure" to more than a few of the above questions, consider one or more of the following: