Pre-Training Assessment for Microsoft Excel Session 2
This assessment tool is for your own use, to help you determine if you have mastered the skills needed to participate successfully in Excel 2.In addition to the skills needed for Excel 1, I know how to:
| start the Excel program | Yes | No | Not sure | |
| start a new Excel workbook | Yes | No | Not sure | |
| open an existing Excel workbook | Yes | No | Not sure | |
| distinguish between workbooks and sheets | Yes | No | Not sure | |
| switch to different sheets in a workbook | Yes | No | Not sure | |
| use commands from Excel's menu bar | Yes | No | Not sure | |
| use commands from Excel's toolbar | Yes | No | Not sure | |
| edit cell contents on Excel's formula bar | Yes | No | Not sure | |
| interpret Excel's status bar | Yes | No | Not sure | |
| select an entire row or column of cells | Yes | No | Not sure | |
| select several non-adjacent cells | Yes | No | Not sure | |
| select several non-adjacent rows or columns | Yes | No | Not sure | |
| use the keyboard to move between cells | Yes | No | Not sure | |
| tell whether I'm in formula entry mode or not | Yes | No | Not sure | |
| enter data into a cell, and edit it | Yes | No | Not sure | |
| insert new rows and columns | Yes | No | Not sure | |
| insert new sheets | Yes | No | Not sure | |
| decide when to clear and when to delete | Yes | No | Not sure | |
| clear the contents of a cell, row or column | Yes | No | Not sure | |
| copy, cut and paste selected cells | Yes | No | Not sure | |
| paste only the format of a copied cell | Yes | No | Not sure | |
| drag selected cells to a new location | Yes | No | Not sure | |
| activate the Quick Edit menu on selected cells | Yes | No | Not sure | |
| format font and alignment of selected cells | Yes | No | Not sure | |
| format color, pattern, and borders of cells | Yes | No | Not sure | |
| format how numbers appear in cells | Yes | No | Not sure | |
| use the menu to change a cell's height or width | Yes | No | Not sure | |
| use column and row headings to change cell height or width | Yes | No | Not sure | |
| sort the data in a selection of cells | Yes | No | Not sure | |
| change margins, headers, and footers | Yes | No | Not sure | |
| remove gridlines for printing | Yes | No | Not sure | |
| preview a worksheet before printing | Yes | No | Not sure | |
| print only selected columns or rows | Yes | No | Not sure |
In Excel 2, we assume that you have mastered key concepts covered in Excel 1. We want you to help you get the most out of each course you take and use your time effectively.
If you answered "No" or "Not sure" to more than a few of the above questions, consider one or more of the following, we suggest you:
- retake CAL PACT's "Excel 1" course
- review the documentation and notes from "Excel 1"
- use your Excel manual or online help files to learn more
- ask someone to show you how to perform these operations
For more
information about CAL PACT, send email to calpact@berkeley.edu.
URL: http://calpact.berkeley.edu
/info/assessments/excel2.html
, page modified:
Monday, 25-Jun-2007 09:23:48 PDT