Introduction

In lecture this week, we have started to take a look at Microsoft Excel and spreadsheets. In lecture, you have learned the first set of functions: SUM, SUMIFS, COUNT, COUNTIFS, AVERAGE, and AVERAGEIFS. You will use these functions to complete the lab today.

Completing the Lab

Download the lab

To get started, first download the Excel (.xlsx) file for Lab 7 here.

Complete the lab wihtin Excel

The Excel file you just downloaded contains ten questions as part of the spreadsheet. The questions are clearly marked throughout the spreadsheet.

Submission

To submit your lab, you must submit your completed Excel file to the CS 105 website.