Answered step by step
Verified Expert Solution
Question
1 Approved Answer
.' Numbers File Edit Insert Table Format Arrange View Share Window Help 4; L2 it Sat11251 AM Q 6 5E r . O Module-01-Assignment(1) .
.' Numbers File Edit Insert Table Format Arrange View Share Window Help 4;\" L2 it Sat11251 AM Q 6 5E r . O Module-01-Assignment(1) . v 125%V The Boston Globe Close ( Egg; www.bostonglobe.com 38 This small town in Massach... Settings Start here Calculations Functions My Practice Data 1 X Your name goes here 1 Instructions: Average Percent or Location gammy February March Total Sales Sales Total 1 Merge and center the titles over the data columns North 100 75 250 2 Format the titles as 14 pt bold South 200 80 245 3 Row 4 data should be 12 pt and a different color East 300 70 145 4 Calculate Total Sales West 200 55 90 5 Calculate Average Sales Grand Total 6 Calculate the grand total ' 7 Calculate percent of total (total sales divided by gr 8 From the Number panel, format column E as Curre 9 Format Column F with two decimal places 10 Format column G as Percentage, no decimal places 11 Create a bar or column chart from the uncalculatel 12 Move the chart to a new sheet entitled my chart Nothing Selected 13 Add a relevant clipart (online picture) 1 59'9\" 3\" Obie\" '0 form\"- 14 Move the clip art under the data HtHAM law All X 169'\". E3 ill%@ 3%u?@
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started