| Why we do this | What we are to do |
|---|---|
| to create a new workbook from existing worksheets |
Download this workbook from Canvas and use it for this week's spreadsheet tasks.
Then save the downloaded worksbook to a location on your laptop where you will save your task04 work and name the saved/stored workbook with a standard (i.e., lastname_firstname_YYYYMMDD_task04a.xlsx) file name |
| to create a new worksheet within this workbook | Insert a new worksheet, place it fifth in the sequence of worksheets, and name it 05-Summary. |
You can download the task 04 gradesheet from Canvas to give you a checklist to follow.
The gradesheet follows the steps in all the task 04
Recitation sessions.
| Why we do this | What we are to do |
|---|---|
| to demonstrate cell formatting skills for worksheet management purposes |
On the 01-US Census Data worksheet,
select all the cells from A1 to CM3273, and Format as Table (Blue, Table Style Medium 2). |
|
to demonstrate cell formatting skills based on the type of data the cells contain
(we will filter the worksheet by cell formatting later) |
On the 01-US Census Data worksheet,
format the cell that shows your home county name in column C with a with a hexidecimal color #bf5700 fill color If you are from Bexar County, TX, for instance, your cell is C2584. If you have no home county in the US, pick any county name. If you don't like #bf5700, fill the cell with any color of your choice. |
| to demonstrate understanding of how and why to freeze panes |
On the 01-US Census Data worksheet,
freeze the appropriate cell so that the header row always appears and the FIPS and State columns always appear |
| to validate data in a column |
On the 01-US Census Data worksheet,
validate the data in column D so that new data added to this column must be a whole number, less than or equal to 9 |