| Excel 2007 Assignment Sheet 1,
Review— Appendix A (Working with Text Functions and Creating Custom Formats) and Appendix D (Working with Enhanced Formatting Tools)
|
 |
GENERAL NOTES: All files have been saved for you in the Student Files area of our server available in the labs in the basement floor of Scarpelli Hall. You can also access these files via the online Assignment Sheet links. Whether specified in the steps or not, always do the following:
1. Save the file as indicated but also—
a. Create a folder for each assignment to save the files in; and
b. add your initials at the beginning of the file name
2. Move the Documentation Sheet to be the first sheet in your workbooks
3. Best Fit columns and make sure any color choices are readable in whatever format you are submitting the assignment.
4. Skip any directions related to headers/footers and instead follow our general Excel setup instructions as shown in the table below—
|
| Your Name
 |
Additional Instructions |
Submit |
|
|
Appendix A: Tutorial
County
Records.xls |
Read and complete pages EX A1 – EX A17.
NOTES:
Page EX A15, Step 6—Print the YI Bayville County workbook.
(Do not re-print after re-saving as an Excel 97-2003 workbook.) |
p. EX
A15,
|
|
Appendix A:
(15 points) |
Complete the Apply Case Problem 1 Assignment on page EX A18-A19. When you are done, save the file as directed and print the Members sheet of the YI Senior Center workbook as indicated below and at right. NOTE: Skip Step 9 (We will do this together in class) |
Step 8 _________(Members sheet)
|
|
Appendix A:
(15 points) |
Complete the Apply Case Problem 2 Assignment on page EX A19-A20. When you are done, save the file as directed and print the Pay Period 10 sheet of the YI Grants workbook as indicated at right. NOTES: Step 8— Before printing in Step 9, delete or hide Column D. |
Step 9_________(Pay Period 10 sheet) |
|
Appendix D:
Periodic.xlsx,
Mendeleev.jpg,
Dalton.jpg, and
Democritus.jpg |
Read and complete pages EX D1 – EX D24.
NOTES:
Do not print or e-mail this assignment. This assignment will
be checked off in class on Monday of the second week of classes at
the beginning of class. If it is not completed by that time and/or
if you are not in class on that day, you will not receive credit for
this assignment. |
Pages EX D24, Step 6_________ (Viewed in class) |
|
Appendix D:
Elements.xlsx, Table1.jpg, Table2.jpg, Table3.jpg, and Table4.jpg
|
Complete the Practice Review Assignment on page EX D25-D26. When you are done, save the file as directed and either print (in color) the Human Body sheet of the YI Elements Table workbook or e-mail the YI Elements Table file to your instructor using yousendit. |
Step 11 ________(Human Body sheet) |
|
Appendix D: (15 points) |
Complete the Apply Case Problem 1 Assignment on page EX D26-D27. When you are done, save the file as directed and print the Yearly Attendance sheet of the YI Big Wave workbook as indicated at right. |
(Yearly Attendance sheet) |
|
EXTRA
CREDIT
(up to 10 points) |
Complete the Apply Case Problem 2 on pages EX D27-D28 (Steps 8-12). Print as a workbook.
|
|
