As you move through your courses, Microsoft Excel will be a tool you will continue to use in and out of the classroom

Subject:MS ExcelPrice:7.99 Bought10

Share With

As you move through your courses, Microsoft Excel will be a tool you will continue to use in and out of the classroom. It can be used for personal budgeting, planning for your financial future, and aiding in important decisions based on data. For this SLP assignment, you will apply basic Excel functions used as a tool (spreadsheet) to store, analyze, and manipulate data. Use the spreadsheet and the linked Excel tutorial videos provided to learn the steps required for each part of the SLP Assignment.

Manipulate the data in this sample order spreadsheet to address the following:

Sort your spreadsheet and then calculate each region's order totals.

1. Which region's order generated the highest dollar amount?
2. What percent of total sales does this region represent?
3. Insert a pie chart illustrating the sales by region.
4. Change the spreadsheet name from SalesOrders to SalesAnalysis

Evaluate each rep’s order total.

1. Add a new spreadsheet to your workbook.
2. Name the spreadsheet RepSales and change the color to blue.
3. Copy the data from the SalesAnalysis spreadsheet to the new RepSales spreadsheet.
4. Sort the data by rep.
5. Which rep generated the highest sales?
6. Insert a Pivot Table.

Save your Excel workbook. Label each worksheet.