Task 04 Spreadsheets
Tasks due by 11:59 p.m. on due date.
Orange links are links to help files on the web. Blue links are file and pages to the class site.
| You will download your individual file (from your sakai dropbox) and modify 18 to 20 spreadsheets | due 10/31 | |
| You will demonstrate sheet setup skills, create new spreadsheets, format cells, control the display of rows with conditional formatting | due 10/31 | |
| You will demonstrate that you can freeze panes, validate data, and hide data | due 10/31 | |
|
You will demonstrate that you know how to work with various formulas and functions |
due 10/31 | |
| Link to the intro demo file: covers all of the above | due 10/31 | |
| You will demonstrate how to pull vectored data from two sheets into a fomula | vector demo file | due 10/31 | |
| You will demonstrate charting and chart formatting and chart annotating | chart demo file | due 10/31 | |
| You will demonstrate facility with filtering and sorting, subtotalling, totalling, and commenting | associated files | due 10/31 | |
| You will demonstrate how to print rows with column headers on each page | due 10/31 | |
| You will include headers and footers and setting up worksheets for printing and basic page layout | due 10/31 | |
| You will save and git push your document to CarolinaCloudApps task folder | due 10/31 | |
last page update: Friday Oct 20, 2017