Task 04 Spreadsheets
Task04 GRADE SHEET | Tasks due by 11:59 p.m. on due date.
| 1. | Your INLS-161-2018-fall-project-workbook.xlsx is in your dropbox on sakai. Download this to you computer. Rename it to 04-lastname.firstname.xlsx |
|
| 2. | Download the gradesheet and look over the tasks. Note that the first two task deal with sheet creation, the next seven tasks deal with formatting, the next two tasks deal with freezing panes and then there are two tasks concerning hiding data | |
| It is best to come to class to follow the demos. The links below are to help you in addition to coming to class. If you depend only on these links, you may not get everything done exactly correctly. create new spreadsheets, format cells, control the display of rows with color formatting | due 10/30 | |
| Additional help: center across selection video (jump to 1:23), freeze panes, validate data, and hide data | due 10/30 | |
|
Here are some basic functions you should know about: max | min | average | sum | count | countblank | countif |
due 10/30 | |
| How to pull vectored data from two sheets into a formula. Instructions in this file: Vector Example | due 10/30 | |
| Additional help:charting and chart formatting and chart annotating | due 10/30 | |
|
sorting, filtering, and commenting lesson files subtotaling lesson files (Make sure you use the Subtotal Tool for the Subtotals worksheet tasks) and commenting |
due 10/30 | |
| Additional help: print rows with column headers on each page | due 10/30 | |
| Additional help:headers and footers and setting up worksheets for printing and basic page layout | due 10/30 | |
Save and put in your opal task folder and update the link on your inls161.html page on your website. |
due 10/30 | |