Recap and Action Items for Office Applications

REMINDER: We do not check your assignments, they are for your own self-study and practice purposes 🙂
For your reference, consult our Assignment and Quizzes cheat sheet for guidance.

DO NOT FOLLOW the contents of the sample screenshot in the video. It does NOT contain the right answer.

NOTE: Label the Y-axis with “Amount Purchased” and the X-axis with “Customers”. (It was the other way around in the video).

Assignment:

Your client gave you her sales report for the 1^st Quarter of 2012.

https://docs.google.com/spreadsheets/d/1biRfB0489dlh2k_jeNoWvCj7Zh4WUR01M52JbxXine8/edit?usp=sharing

• Create a copy of the Sheet for your own purposes. File > Make a Copy (No need to request for edit access)
• Compute the sales total using a Google Sheets formula.
• Present the data in a Pie Chart representing the percentage of each sale from each customer. Entitle it: Percentage of Sales by Customer
• Now, present the data in a line graph. Label the Y-axis with “Amount Purchased” and the X-axis with “Customers”. Entitle the chart as “Sales Chart for the 1^st Quarter” and change the colors to your preferred ones.  Take a screenshot and save it for our portfolio lesson.