You must submit your completed file(s) through the CS101 Submit Assignments tool.
This assignment is due on Friday, February 9, 2018 at 11:59:59 PM Eastern Time. Late work will be accepted for reduced credit until Tuesday, February 13, 2018 at 11:59:59 PM Eastern Time.
This assignment is worth 50 points. A grading rubric is provided at the end of the assignment instructions.
Help & Resources
Associated Learning Objectives
This assignment covers the following course and unit learning objectives:
|C01||Build spreadsheets to perform calculations, display data, conduct analysis, and explore what-if scenarios.|
|C05||Identify, access, and evaluate information to solve real world problems.|
|C01.ED02||Create and manage workbooks, worksheets, and their data.|
|C01.ED03||Format worksheets and cells to create professional reports.|
|C01.ED04||Write formulas using cell references and functions to calculate data.|
|C01.ED05||Use tables and PivotTables to organize data.|
|C01.ED06||Use charts, PivotCharts, and sparklines to present data in a graphical format.|
|C01.ED07||Use what-if analysis tools to project future values and prepare different scenarios.|
|C05.ED01||Locate and access data and resources necessary to solve problems.|
|C05.ED08||Interpret and analyze spreadsheet data|