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.
|
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..
|