Tools for Information Literacy ⑪ Data control

Get some experience in setting up a worksheet

You can download the task 04 gradesheet 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 create a new workbook from existing worksheets	Download this workbook from Canvas and use it for all your spreadsheet tasks. then save all the worksheets to a new workbook named with a standard (i.e., lastname_firstname_YYYYMMDD_task04.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.

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.
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