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 https://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:

https://support.office.com/en-in/article/Create-a-PivotTable-and-analyze-your-data-7810597d-0837-41f7-9699-5911aa282760?ui=en-US&rs=en-IN&ad=IN

IF functions

https://support.office.com/en-in/article/Advanced-IF-functions-17341cef-510d-4d60-a657-913f878fdacf?ui=en-US&rs=en-IN&ad=IN

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

Questions Cloud

Applying the approach to ethics in the company : From the e-Activity, discuss the major challenges you would anticipate in applying the approach to ethics in the company you researched (and the specific challenges they face), as well as how those challenges might be addressed.
What real-life aspects can you glean from this video : View this video First IT Professional Services Call-http://www.screencast.com/t/lYHn48OZkE83 (under three minutes) and comment. While it's intended to be humorous, what real-life aspects can you glean from this video? Discuss
Insurance premium : overhead expenses are budgeted at $2000 per month. Included in the 2,000 are $500 of monthly depreciation expenses and $200 of allocated expenses related to the insurance premium that is paid on September.
How would the event affect the statement of cash flows : How would the event affect the statement of cash flows (inflow, outflow, no effect) and in what section?
What is the amount sold by each salesperson : Use the PivotTable to calculate and summarize the data. Once you have created a PivotTable, change the order amount to currency. What is the amount sold by each salesperson? What is the total amount sold in each month
How much can you withdraw from retirement plans : If you plan on making 20 equal withdrawals at the beginning of each year from the account (with the first withdrawal made at the end of the 30th year-the first year of retirement), how much can you withdraw?
Problem regarding the company ethical standards : Describe how a company's ethical standards are aligned with its decision-making approach (es) and how you would be certain that ethical decisions were being made. From the perspective of the executive suite, prioritize three of the responsibilitie..
Determine the cost basis of a new machine : determine the cost basis of a new machine and how to calculate the due date of a note
Ethical organizational culture and ethical decision making : You are managing your startup business and having some success, but there is still strong competition in the area. How do you stress an ethical organizational culture and still remain competitive? In the past, how have ethics impacted decision-mak..

Reviews

Write a Review

 

Management Information Sys Questions & Answers

  What are some examples of leading edge technology

Prepare a 3- to 4-page paper in which you describe relationships among technology convergence, leading edge technology, and bleeding edge technology. What are some examples of leading edge technology

  Define social responsibility

Define social responsibility and What are the similarities and differences between both companies regarding their corporate social responsibility efforts

  Jake''s computer repair service exercise

Jake's Computer Repair Service Exercise - True or false? The cash basis of accounting is required under Generally Accepted Accounting Principles (GAAP) when preparing financial statements. Explain, if necessary.

  A research the forms of data used in the system of your

a research the forms of data used in the system of your choice. this system could be your own health care organization

  Show the concept of environmental sustainability

The three teleological frameworks and the three deontological frameworks. What are the merits and demerits of each? Of these six frameworks, with which one do you most associate?

  Global data securitysafeguarding organizational data is

global data securitysafeguarding organizational data is always a high priority. what security systems would you

  What is the purpose of the system unit

What is the purpose of the system unit? List and define five primary components of the motherboard. List and define the three primary subunits of the CPU

  Management information systems

Management Information Systems.

  Current architecture of internet and on any planned changes

Compare and contrast each architecture and How are they unique? What do they share? What factors drive your decision?

  Systems solution online travel agencybusiness situation

systems solution online travel agencybusiness situation that requires a systems solution i have selected a small online

  Describe the routing and switching infrastructure

Describe the routing and switching infrastructure and the routing protocols used in the environment. Illustrate the secure routing and switching infrastructure topology through the use of graphical tools in Microsoft Word or Visio, or an open sourc..

  Understanding bgp and redundancy

Understanding BGP and Redundancy

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