What is the amount sold by each salesperson

Assignment Help Management Information Sys
Reference no: EM13928513

Electronic Commerce and the Social Enterprise

In Part I, you will create an Excel Pivot tables, and in Part II you will and evaluating security measures to protect Internet consumers.
Refer to tutorials at http://www.gcflearnfree.org/excel2013 and watch the videos.

1. Track Change and Comments [Video 24]
2. Finalizing and Protecting Workbooks [Video 25]
3. Conditional Formatting [Video 26]
4. Pivot Tables [Video 27]
5. What-If Analysis [Video 28]

For this assignment, first watch the below videos by clicking the links:

Pivot Tables:


IF functions


Using PivotTables to answer questions

Suppose we wanted to answer the question: "What is the amount sold by each salesperson?" for the sales data in the example below. Answering this question could be very time-consuming and difficult-each salesperson appears on multiple rows, and we would need to total all of their different orders individually. We could use theSubtotal command to help find the total for each salesperson, but we would still have a lot of data to work with.

Fortunately, a PivotTable can instantly calculate and summarize the data in a way that is both easy to read and manipulate. Perform the following.

1. Use the PivotTable to calculate and summarize the data.

2. Once you have created a PivotTable, change the order amount to currency.

3. What is the amount sold by each salesperson?

4. What is the total amount sold in each month?

5. Take a screenshot or use the Snipping tool to copy the worksheet where the new pivot table and pivot table fields appear to show your work. Paste the screen images into a Word doc.

For Part II, prepare a 1- to 2-page Word document paper addressing the following question.

Research 2-3 security measures that are available to protect customers shopping on the Internet. Define the measure and find the benefits and limitations of each approach.

Reference no: EM13928513

Write a research report that cover a description of each erp

Write a minimum of three page research report, using current APA formatting. The report should cover the previously listed MS Dynamics ERP systems, a description of each ERP a

What are the major strategies and why is it important

What are the major strategies and why is it important to implement security policy's in today's organizations? Include all references (books, web sites, etc.) where you collec

Factors that lead to mss success or failure

Outsourcing as a viable option for management support system (MSS) and factors that lead to MSS success or failure. Introduction: You have had the opportunity to learn about

Provide an example of how to use the formula

What explanation would you give so that your staff understands that formula? Provide an example of how to use the formula. Develop a matrix using the formula as part of your e

Identify creational design pattern and describe a situation

From the e-Activity, using UML and text, identify a creational design pattern and describe a situation where it could be applied. Provide a justification as to why it should

Advantage the proposal brings to the company

Justify the implementation of one of the proposals by doing the following: Discuss one short-term advantage the proposal brings to the company. Discuss one long-term advantage

Explain the systems development life cycle

Explain the systems development life cycle and how it is used in HCIT. Examine the role of a health care manager in a typical IT project. Compare the project management life c

Create a section in the plan to list all of the policies

create a 2-3-page section in the plan to list all of the policies that you would have for your organization and a brief description of what each policy will contain. After t


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd