Task 04 Spreadsheets
Task04 GRADE SHEET | Tasks due by 11:59 p.m. on due date.
| You will download the INLS-161-2018-project-workbook.xlsx and modify 18 to 20 spreadsheets. Be sure to use this file and not a file from another semester. (be careful not to Google search for this site, you might end up on a previous semester site that is archived.) | due 03/27 | |
| Download this excel file 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 03/27 | |
| You will demonstrate that you can freeze panes, validate data, and hide data | due 03/27 | |
|
You will demonstrate that you know how to work with various formulas and functions |
due 03/27 | |
| You will demonstrate how to pull vectored data from two sheets into a formula. Instructions in this file: Vector Example | due 03/27 | |
| You will demonstrate charting and chart formatting and chart annotating | due 03/27 | |
| 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 03/27 | |
| You will demonstrate how to print rows with column headers on each page | due 03/27 | |
| You will include headers and footers and setting up worksheets for printing and basic page layout | due 03/27 | |
| You will save and put in your opal task folder | due 03/27 | |