What is the amount sold by each salesperson
Using Pivot Tables to answer questions
WRITE THIS ESSAY FOR ME
Tell us about your assignment and we will find the best writer for your paper.
Get Help Now!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 the Subtotal 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.
- 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?
- 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.
Submit your answers for this assignment by pasting the worksheet screenshots in 1- to 3-page Word document.
SLP Part II
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.
SLP Assignment Expectations
Your assignment will be graded following these expectations:
- SLP Part I and II must be submitted in one combined Word document containing 2-5 pages properly labeling each section.
- Submit a Word document with screen copies of the Excel worksheet by pasting them in 1-3 pages. Answer the security question in 1-2 pages.
- Precision: the questions asked are answered.
- Clarity: Your answers are clear and show your good understanding of the topic.
- Breadth and depth: The scope covered in your paper is directly related to the questions of the assignment and the learning objectives of the module.
- Your paper meets the page requirements not counting the cover page or the references pages.
Introducing our Online Essay Writing Services Agency, where you can confidently place orders for a wide range of academic assignments. Our reputable homework writing company specializes in crafting essays, term papers, research papers, capstone projects, movie reviews, presentations, annotated bibliographies, reaction papers, research proposals, discussions, and various other assignments. Rest assured, our content is guaranteed to be 100% original, as every piece is meticulously written from scratch. Say goodbye to concerns about plagiarism and trust us to deliver authentic and high-quality work.
WRITE MY ESSAY NOW
