Microsoft Excel is a
great tool for presenting, organizing, and calculating data. It can be used to
create budgets, track your weekly spending, or create detailed plans. This
assignment will give you an opportunity to crunch the numbers on your most recent
school supply purchases.
Assignment Requirement:
To successfully complete this assignment, submit this (1) Microsoft Excel sheet that includes the following information and formatting.
Steps:
1. Complete the steps listed in the "WK8_A2_Instructions" sheet.
2. Save your document with the following name – CIS105_Assignment2_FirstName_Last Name.xlsx
3. Submit your assignment in Week 8.
Recommended TestOut Desktop Pro Skills Labs to review prior to completing this assignment are:
3.2.4 Skills Lab: Create and Manage Workbooks
3.3.5 Skills Lab: Organize and Enter Data
3.5.6 Skills Lab: Format Cells
3.6.4 Skills Lab: Enter Simple Formulas
3.8.4 Skills Lab: Analyze Data in Charts
Recommended Lynda.com Videos to Watch
Microsoft Excel 2013
Lynda.com Video: Excel 2013 Essential Training
URL: https://www.lynda.com/Excel-tutorials/Excel-2013-Essential-Training/116478-2.html
Microsoft Excel 2016
Lynda.com Video: Excel 2016 Essential Training
URL: https://www.lynda.com/Excel-tutorials/Excel-2016-Essential-Training/376985-2.html
Excel for Mac 2011
Lynda.com Video: Excel for Mac 2011 Essential Training
URL: https://www.lynda.com/Excel-2011-for-mac-tutorials/essential-training/71210-2.html
Excel for Mac 2016
Lynda.com Video: Excel for Mac 2016 Essential Training
URL: https://www.lynda.com/Excel-tutorials/Excel-Mac-2016-Essential-Training/159244-2.html