Skip to main content

Spreadsheet Intro

Download the Task 04 Grade Sheet from the Sakai Site.

Visit the Data Setup Class Web Page and download the task04.datasets.xlsx file. Follow the instructions there regarding not enabling content.

Here is the formatting-fuctions-formula.pptx file I used in the class sessions and can be seen in the zoom recordings. If you were not in class and if you have not yet watched the videos, then you should take a look at the first few slides, or the class video, before opening the file.

We will use the Powerpoint for our guide to complete the following:

  1. Formatting a Worksheet
  2. Setting up A Workbook
  3. Setting up Conditional Formatting
  4. Freezing Panes
  5. Hiding Data: Columns
  6. Hiding Data: Rows
  7. Understand and Use Functions
  8. Understand and Use Formulas

However, we will move these items to be the last thing that we do: https://ils.unc.edu/courses/2021_fall/inls161_001/11b.02.setupbook.html on the last session. You will not find them detailed in the PowerPoint or the class recordings.