Question Details

ITM 301 Module 3 SLP
COLLABORATION TECHNOLOGIES AND IT INFRASTRUCTURE
Please review the following link and watch the section videos.
Refer to tutorials at http://www.gcflearnfree.org/excel2013 and watch the video:
1.	Freezing Panes and view Options [video 17]
2.	Sorting Data [video 18]
3.	Filtering Data [video 19]
4.	Groups and subtotals [video 20]
5.	Tables [video 21]
6.	Charts [video 22]
7.	Sparkline [video 23]
After watching the Excel videos, please continue developing the Abacus Excel spreadsheet exercises as noted below.
Basic Spreadsheet Concepts.(2009). Abacus training. Retrieved fromhttp://www.abacustraining.biz/Exercises/Excel/BasicSSConcepts.htm
Exercise 5 - Mike- Lunch Bar
Exercise 6 - Mike- Furniture Store
Exercise 7 - Weekly Income Schedule
Exercise 2 - Use the Sales and Produce Department spreadsheet created in the Intermediate Spreadsheet Exercise 2 at http://tfacomputers.weebly.com/uploads/1/3/3/5/13350957/excel_basic_exercises.pdf   to create the Pie Chart below.

 
Create similar Pie Charts for other Fruits in this spreadsheet such as kiwifruit, pears, and nectarines.  Hint: use the CTRL key to highlight or select the cells or columns you need to create these charts.
Create an Excel file with designated folders 1-4 to develop the above exercises.