COMP1000 Web, Spreadsheets and Databases - Session 1, 2016 - Lab 3

After this lab you should be able to :

extract meaningful information from data using totals and pivot charts
perform what-if-analysis using data tables, goal seek and solver.

Instructions

This week there are 2 questions. Each question comes from the textbook, "Microsoft Office Excel 2010 Comprehensive", Grauer, Mulbery, Poatsy.

The questions can be found in COMP1000Lab3.pdf

Please ignore part a for the first 2 questions where it instructs you how to open the files and please ignore any parts of any of the questions that tell you to print out your document.

I have put the data for each of the first 2 questions into one workbook, with 2 worksheets for each question.

Please download the Lab3Workbook.xlsx

The marking scheme for each question is as follows:

Data Subtotals, Data 5 Marks
Budget, Q&A, 5 Marks

Saving your Work

Save your work and show to your tutor in the labs.