CAL PACT

 

 

Home Schedule Course Info and Handouts Enroll Training Resources Contact






Pre-Training Assessment for Excel 4

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:

  • retake CAL PACT's "Excel 1," "Excel 2," and "Excel 3" courses
  • review the documentation and notes from "Excel 1," "Excel 2," and "Excel 3"
  • use your Excel manual or online help files to learn more
  • ask someone to show you how to perform these operations
| Home | Schedule | Course Info & Handouts | Enroll Now! | Departmental Training | Other Training Resources | News | Contact us |

For more information about CAL PACT, send email to calpact@berkeley.edu.
URL: http://calpact.berkeley.edu /info/assessments/excel4.html , page modified: Monday, 25-Jun-2007 09:23:50 PDT