Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For excel, i just need help with questions 10, 11 and 13 please. thank you. 10 11 On the Expenses worksheet use Quick Analysis to

For excel, i just need help with questions 10, 11 and 13 please. thank you. image text in transcribed
image text in transcribed
image text in transcribed
10 11 On the Expenses worksheet use Quick Analysis to apply Data Bars to the range F4:F11. Note, Mac users, apply Solid Blue Data Bars to the range. Insert a Right Block Arrow shape in the Government Expenses chart pointing to the Capital Projects data for the 4th Quarter. Position the shape in row 18 and resize the shape so that the Height is 0.20 and the Width is 1.07. 12 On the Pie Chart sheet, insert a Text Box in the Department Total chart. Position the text box in the pie shape to the right of the 29% data label. In the text box, type Largest percent, apply Bold to the text, and then resize the Text Box to Height 0.30 and Width 1.2. 13 Change the Chart Layout to 1. Use the snipping tool to take a rectangular snip of the Pie Chart Area including the title. Copy and then paste the snip in cell 12 of the Expenses worksheet. Resize the snip so that the upper left corner sits just inside the cell borders of 12, Height 5.91 and Width 6.67 . Chart 2 X A D G H 2 4 3 Department 5 Legislative 6 City Manager 7 ty D ve lephant 8 Chy Services 9 Engineering City Government Expenses Tot Quarter 2nd Quarter 3rd Quarter 4th Quarter Department Total $ 321,816 5 335,809 $ 3637925 377785 1.399,202 806,680 841752 911,899 946,971 3,507302 701,156 731,641 792,611 823,095 3,048,502 2,472,333 2,123,305 2,292,524 2,076,218 8,964,380 410,228 428,064 463737 481,572 1783,602 983,228 1,025,977 1,111,475 1.154,223 4.274,903 637,261 664,969 720,382 748,089 2,770702 39047) 407 448 441403 3,458,380 4697702 $ 6,723,174 $ 6,558,964 $ 7,097,822 $ 10,066,334S 30446,294 Percent of Expenses 4.6% 11.5 10.0% 29.4% 5.9% 14.09% 9.1% 15.4% 10 Finance 11 Publik Warlos 12 Capitol Projects 13 Total Expenses Government Expenses 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 54,000,000 $3,500,000 $3.000.000 $2.500.000 12,000,000 $1,500,000 $1,000,000 $500.000 - Ta Love ting 2nd Quote dre () OM ry Deventy ahli Wenus Cral ks 31 32 33 34 35 37 39 40 41 crutarea rtment Total 5% 15% 12% 9% 10% 14% leglove Cry Manager Oly Development Cry Services Engineering Fhone Public Works Cophrol Projects 6% 29%

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

Oracle Database 19c DBA By Examples Installation And Administration

Authors: Ravinder Gupta

1st Edition

B09FC7TQJ6, 979-8469226970

More Books

Students also viewed these Databases questions

Question

How do Data Types perform data validation?

Answered: 1 week ago

Question

How does Referential Integrity work?

Answered: 1 week ago