Courses/Computer Science/CPSC 203/CPSC 203 Template/Winter 2010 Lab Manual/CPSC203 Spreadsheets review

From wiki.ucalgary.ca
Jump to: navigation, search

This lab provides a review on some of the tasks that you have done during the five previous modules. This review covers:

  • Simple calculations
  • Complex calculations
  • If statement
  • Lookup function
  • Pivot tables
  • Charts

The following Excel sheet has some basic data, and some tasks that you should do on that data. Please note that the file includes two sheets having two examples. Media: Spreadsheets module review.xls