Getting Started using Excel Spreadsheet Survey
The following skills survey is designed to help you evaluate your skills using a computer spreadsheet application. Complete the skills assessments before you begin this training module and after you have completed the module. Take a few minutes to answer the following questions and leave the form with the lab assistant or your instructor. Your instructor or lab assistant will provide a scan-tron form for you to use to answer the questions.
Directions:
On your scan-tron form, please write the following information:
1) Your Last Name, First Name
2) Today’s date
3) Where the form says Subject, please write the name and number of the course in which you are enrolled, for example CA 304
4) Where the form says, Test No., please write Getting Started with Excel.
5) Where the form says, Hour, please write “1” if you have not completed the training workbook for this course, or “2” if you have completed the training workbook for this course.
On this form, mark the letters A through E.
§ A means “I have never done this before."
§ B means, " I did this task once or twice before."
§ C means, " I have done this task several times before."
§ D means, "I have done this task many times and feel very comfortable doing this task."
§ E means “I am very experienced with this task."
Your answers should reflect how well you feel you could complete the specified tasks. There are no right or wrong answers.
1. Create a new spreadsheet.
2. Open an existing spreadsheet.
3. Change the font and size of text in a spreadsheet.
4. Change the format of numbers in a spreadsheet.
5. Use menu options to save a spreadsheet.
6. Use key combinations to save a spreadsheet.
7. Save a spreadsheet on a floppy disk or a hard drive.
8. Create a formula using cell references.
9. Create relative cell references.
10. Create absolute cell references.
11. Copy formulas using relative cell references from one cell to another.
12. Copy formulas using absolute cell references from one cell to another.
13. Create multiple spreadsheets within one workbook.
14. Create references across spreadsheets within a workbook
15. Identify and correct errors in a spreadsheet formula.
16. Identify menu options that lead to submenus.
17. Use key combinations for printing, copying, and pasting sections of a spreadsheet.
18. Adjust the size of a spreadsheet for printing so that a spreadsheet fits on a single page.
19. Print a spreadsheet in either portrait or landscape mode.
20. Adjust the width of a column using the mouse and menu selections.
21. Adjust the height of a row using the mouse and menu selections.
22. Use the right mouse button to display context-sensitive menus.
23. Convert a spreadsheet to HTML format.
24. Add comments to a spreadsheet cell.
25. Change a spreadsheet display so that comments are hidden.