Task 04 Spreadsheets
Task04 GRADE SHEET Revised June 3, 2018 | 8:00 pm (minor typos corrected; please use this gradesheet if you have downloaded one before this date. | Tasks due by 11:59 p.m. on due date.
| You will download the INLS-161-2018-SS1-project-workbook.xlsx. (be careful not to Google search for this site, you might end up on a previous semester site that is archived.) | due 06/10 | |
| If you have not yet downloaded Task04-01_Intro.xlsx, Download it here to follow along in the intro class | ||
| You will demonstrate sheet setup skills, create new spreadsheets, format cells, control the display of rows with color formatting | due 06/10 | |
| You will demonstrate that you can freeze panes, validate data, and hide data | due 06/10 | |
|
You will demonstrate that you know how to work with various formulas and functions |
due 06/10 | |
| You will demonstrate how to pull vectored data from two sheets into a formula. Instructions in this file: Vector Example | due 06/10 | |
| You will demonstrate charting and chart formatting and chart annotating | due 06/10 | |
| You will demonstrate facility with filtering and sorting, subtotaling (example in this file)subtotaling (Make sure you use the Subtotal Tool for the Subtotals worksheet tasks) and commenting | due 06/10 | |
| You will demonstrate how to print rows with column headers on each page | due 06/10 | |
| You will include headers and footers and setting up worksheets for printing and basic page layout | due 06/10 | |
| You will save and put in your opal task folder | due 06/10 | |