Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
.' 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Analysis For Management

Authors: Barry Render, Ralph M. Stair, Michael E. Hanna

11th Edition

9780132997621, 132149117, 132997622, 978-0132149112

More Books

Students also viewed these General Management questions