Hello! Need help with this please! ASAP!! Do not give me any codes!!! NO CODES!! Please show me what I have to click on excel!! Show pictures of it from excel please! I have the data and steps I just need help with what I need to click on excel. Remember NO CODES because I dont understand that and its not what Im asking for. Thank you for the one who helps.

1. Open the Wilson Home-05 start file. The file will be renamed automatically to include your name Change the project file name it directed to do so by your instructor, and save it 2. Group all the worksheets. 3. Edit and format grouped sheets a Select cells A1:B2 and click the Launcher in the Alignment group (Home tab). Choose Center Across Selection from the Horizontal list and click OK. b. Click the Launcher in the Page Setup group [Page Layout tab] and click the Margins tab c. Choose Horizontally from the Center on page list and click OK d. Edit the contents of cell A10 to read Cash paid for marketing e. Select cell A1 and ungroup the sheets 4. Select the CashFlow sheet 5. Build a static data consolidation for the cash flow from operations section a Select cells B4:812 b. Use SUM to consolidate the data from the three location sheets without links (Figure 5-76). 6. Build a static data consolidation for the Cash flow from Reset Progre banking and investment section in cells B15:B21 Delete the references in the Consolidate dialog box and use SUM as the function Conde Fondi tum Benne For Brewi aed A terences Champaigns $12 3545012 Eacilanda Det CK Close 7. Build a static data consolidation for the Cash balance at the beginning of the quarter amounts in cell B24 with SUM as the function Use labels 8. Insert a picture from a file Top row Le column Gente links to ourte dite a Delete the contents of cell A1 on the CashFlow sheet b. Click cell D2 Figure 5-76 Consolidato dialog box for cash flow c. Click the Pictures button (Insert tab, Illustrations group) and choose This Device Alternate Click the Pictures button [Insert tab, Wustrations group] a Find and select WHES from your student data files e Click Insert the picture is placed at a default size 1. Click the Height box [Picture Formar tab, Size group] Alternate Click the Height box [Picture Tools Format tab Size group] g. Change the height to 1.2" n. Format the height of row 1 to 86.25 (115 pixels) 1. Point to the logo frame to display a move pointer 1 Drag the image to appear in cell A1 as a main label for the worksheet (Figure 5-77). k. Click cell D2 to deselect the image 9. Insert and copy a hyperlink a Click cell C3 on the Peoria worksheet Reset Pictures 17.751 SH 9. Insert and copy a hyperlink a Click cell C3 on the Peoria worksheet b. Create a hyperlink that displays Total Cash Flow and Wat Hard switches to cell A1 on the Cash Flow worksheet (Figure 5-78) Statement of Cash Flow c. Right-click cell C3 and choose Copy from the menu d. Select the Champaign sheet tab and paste the hyperlink in cell C3 e Select the Rockford sheet tab and paste the hyperlink in cell C3 1. Select the Peoria sheet and press Esc to remove the copy marquee if it is still visible g. Select cell C5 and then click the cell with the hyperlink to test it 10. Save and close the workbook (Figure 5-79) Wilson Home Entertainment Systems 3 cash flow froen corelations cash received fronciens 5 cash received from ser contracts Other cash received 7 Cash paid for lates and wages paid for inventory cash paid for office supolies 10 Cash paid for marketing 11 Cash paid for the 12 Other cash paid 13 Nel chromoperations 14 Cash flow marking and Investment 29,150 1.000 565 250 25,546 Figure 5.77 Image positioned as title 0 Statement of Cash Flow Ich DI Reset C ca C A Wilson Home Entertainment Systems 2 Statement of Cash Flow 3 Cash flow from operations 4 Cash received from clients 5 Cash received from service contracts 6 Other cash received 7 Cash paid for salaries and wages 8 Cash paid for inventory 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17 cash received from rental and lease agreements CashFlow Peoria Champaign $ Rockford C B U A $ 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17 Cash received from rental and lease agreements 18 Cash received from interest on deposits 19 Other cash received 20 Cash paid for purchase of equipment 21 Other cash paid 22 Net cash from banking and investment 23 Increase (decrease) in cash during the quarter 24 Cash balance at the beginning of the quarter 25 Cash balance at the end of the quarter $ $ $ Cash Flow Peoria Champaign Rockdord A B C 1 Wilson Home Entertainment Systems 2 Statement of Cash Flow 3 Cash flow from operations 4 Cash received from clients 5 Cash received from service contracts $ 7,521 $ 12,345 6 Other cash received $ 10,875 $ 450 $ 125 $ 135 7 Cash paid for salaries and wages 8 Cash paid for inventory 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17 Cash received from rental and lease agreements CashFlow Pearia Champaign $ 8,281 $ 1.200 Rockford B A $ 125 $ 135 $ 8,281 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17 Cash received from rental and lease agreements 18 Cash received from interest on deposits 19 Other cash received 20 Cash paid for purchase of equipment 21 Other cash paid 22 Net cash from banking and investment 23 Increase (decrease) in cash during the quarter 24 Cash balance at the beginning of the quarter 25 Cash balance at the end of the quarter $ 1,200 $ 325 $ 1,525 $ 9,806 45,755 $ $ 55,561 CashFlow Peoria Champaign Rockford + B A 1 Wilson Home Entertainment Systems 2 Statement of Cash Flow 3 Cash flow from operations 4 Cash received from clients 5 Cash received from service contracts $ 5,645 $ 15,345 6 Other cash received $ 8,750 $ 345 $ 125 7 Cash paid for salaries and wages 8 Cash paid for inventory 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17. Cash received from rental and lease agreements CashFlow Peoria Champaign $ 11,770 Rockford Das A B 345 $ $ 125 $ 11,770 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17 Cash received from rental and lease agreements 18 Cash received from interest on deposits 19 Other cash received 20 Cash paid for purchase of equipment 21 Other cash paid 22 Net cash from banking and investment 23 Increase (decrease) in cash during the quarter 24 Cash balance at the beginning of the quarter 25 Cash balance at the end of the quarter $ $ 1,255 $ 1,255 13,025 $ $ $ 35,234 48,259 CashFlow Peoria Champaign Rockford A 00 B C 1 Wilson Home Entertainment Systems 2 Statement of Cash Flow 3 Cash flow from operations 4 Cash received from clients $ 4,565 5 Cash received from service contracts $ 10,900 6 Other cash received $ 9,525 $ 550 $ 95 7 Cash paid for salaries and wages 8 Cash paid for inventory 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate $ 5,295 $ 3,500 17 Cash received from rental and lease agreements Cashflow Peoria Champaign 450 S Rockford 1 B B C $ 95 $ 5,295 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17 Cash received from rental and lease agreements 18 Cash received from interest on deposits 19 Other cash received 20 Cash paid for purchase of equipment 21 Other cash paid $ 3,500 $ 450 $ 650 $ 4,600 $ 9,895 22 Net cash from banking and investment 23 Increase (decrease) in cash during the quarter 24 Cash balance at the beginning of the quarter 25 Cash balance at the end of the quarter 32,575 $ $ 42,470 CashFlow Peoria Champaign Rockford + 1. Open the Wilson Home-05 start file. The file will be renamed automatically to include your name Change the project file name it directed to do so by your instructor, and save it 2. Group all the worksheets. 3. Edit and format grouped sheets a Select cells A1:B2 and click the Launcher in the Alignment group (Home tab). Choose Center Across Selection from the Horizontal list and click OK. b. Click the Launcher in the Page Setup group [Page Layout tab] and click the Margins tab c. Choose Horizontally from the Center on page list and click OK d. Edit the contents of cell A10 to read Cash paid for marketing e. Select cell A1 and ungroup the sheets 4. Select the CashFlow sheet 5. Build a static data consolidation for the cash flow from operations section a Select cells B4:812 b. Use SUM to consolidate the data from the three location sheets without links (Figure 5-76). 6. Build a static data consolidation for the Cash flow from Reset Progre banking and investment section in cells B15:B21 Delete the references in the Consolidate dialog box and use SUM as the function Conde Fondi tum Benne For Brewi aed A terences Champaigns $12 3545012 Eacilanda Det CK Close 7. Build a static data consolidation for the Cash balance at the beginning of the quarter amounts in cell B24 with SUM as the function Use labels 8. Insert a picture from a file Top row Le column Gente links to ourte dite a Delete the contents of cell A1 on the CashFlow sheet b. Click cell D2 Figure 5-76 Consolidato dialog box for cash flow c. Click the Pictures button (Insert tab, Illustrations group) and choose This Device Alternate Click the Pictures button [Insert tab, Wustrations group] a Find and select WHES from your student data files e Click Insert the picture is placed at a default size 1. Click the Height box [Picture Formar tab, Size group] Alternate Click the Height box [Picture Tools Format tab Size group] g. Change the height to 1.2" n. Format the height of row 1 to 86.25 (115 pixels) 1. Point to the logo frame to display a move pointer 1 Drag the image to appear in cell A1 as a main label for the worksheet (Figure 5-77). k. Click cell D2 to deselect the image 9. Insert and copy a hyperlink a Click cell C3 on the Peoria worksheet Reset Pictures 17.751 SH 9. Insert and copy a hyperlink a Click cell C3 on the Peoria worksheet b. Create a hyperlink that displays Total Cash Flow and Wat Hard switches to cell A1 on the Cash Flow worksheet (Figure 5-78) Statement of Cash Flow c. Right-click cell C3 and choose Copy from the menu d. Select the Champaign sheet tab and paste the hyperlink in cell C3 e Select the Rockford sheet tab and paste the hyperlink in cell C3 1. Select the Peoria sheet and press Esc to remove the copy marquee if it is still visible g. Select cell C5 and then click the cell with the hyperlink to test it 10. Save and close the workbook (Figure 5-79) Wilson Home Entertainment Systems 3 cash flow froen corelations cash received fronciens 5 cash received from ser contracts Other cash received 7 Cash paid for lates and wages paid for inventory cash paid for office supolies 10 Cash paid for marketing 11 Cash paid for the 12 Other cash paid 13 Nel chromoperations 14 Cash flow marking and Investment 29,150 1.000 565 250 25,546 Figure 5.77 Image positioned as title 0 Statement of Cash Flow Ich DI Reset C ca C A Wilson Home Entertainment Systems 2 Statement of Cash Flow 3 Cash flow from operations 4 Cash received from clients 5 Cash received from service contracts 6 Other cash received 7 Cash paid for salaries and wages 8 Cash paid for inventory 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17 cash received from rental and lease agreements CashFlow Peoria Champaign $ Rockford C B U A $ 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17 Cash received from rental and lease agreements 18 Cash received from interest on deposits 19 Other cash received 20 Cash paid for purchase of equipment 21 Other cash paid 22 Net cash from banking and investment 23 Increase (decrease) in cash during the quarter 24 Cash balance at the beginning of the quarter 25 Cash balance at the end of the quarter $ $ $ Cash Flow Peoria Champaign Rockdord A B C 1 Wilson Home Entertainment Systems 2 Statement of Cash Flow 3 Cash flow from operations 4 Cash received from clients 5 Cash received from service contracts $ 7,521 $ 12,345 6 Other cash received $ 10,875 $ 450 $ 125 $ 135 7 Cash paid for salaries and wages 8 Cash paid for inventory 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17 Cash received from rental and lease agreements CashFlow Pearia Champaign $ 8,281 $ 1.200 Rockford B A $ 125 $ 135 $ 8,281 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17 Cash received from rental and lease agreements 18 Cash received from interest on deposits 19 Other cash received 20 Cash paid for purchase of equipment 21 Other cash paid 22 Net cash from banking and investment 23 Increase (decrease) in cash during the quarter 24 Cash balance at the beginning of the quarter 25 Cash balance at the end of the quarter $ 1,200 $ 325 $ 1,525 $ 9,806 45,755 $ $ 55,561 CashFlow Peoria Champaign Rockford + B A 1 Wilson Home Entertainment Systems 2 Statement of Cash Flow 3 Cash flow from operations 4 Cash received from clients 5 Cash received from service contracts $ 5,645 $ 15,345 6 Other cash received $ 8,750 $ 345 $ 125 7 Cash paid for salaries and wages 8 Cash paid for inventory 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17. Cash received from rental and lease agreements CashFlow Peoria Champaign $ 11,770 Rockford Das A B 345 $ $ 125 $ 11,770 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17 Cash received from rental and lease agreements 18 Cash received from interest on deposits 19 Other cash received 20 Cash paid for purchase of equipment 21 Other cash paid 22 Net cash from banking and investment 23 Increase (decrease) in cash during the quarter 24 Cash balance at the beginning of the quarter 25 Cash balance at the end of the quarter $ $ 1,255 $ 1,255 13,025 $ $ $ 35,234 48,259 CashFlow Peoria Champaign Rockford A 00 B C 1 Wilson Home Entertainment Systems 2 Statement of Cash Flow 3 Cash flow from operations 4 Cash received from clients $ 4,565 5 Cash received from service contracts $ 10,900 6 Other cash received $ 9,525 $ 550 $ 95 7 Cash paid for salaries and wages 8 Cash paid for inventory 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate $ 5,295 $ 3,500 17 Cash received from rental and lease agreements Cashflow Peoria Champaign 450 S Rockford 1 B B C $ 95 $ 5,295 9 Cash paid for office supplies 10 Cash paid for promotion 11 Cash paid for taxes 12 Other cash paid 13 Net cash from operations 14 Cash flow from banking and investment 15 Cash received from sale of equipment 16 Cash received from sale of real estate 17 Cash received from rental and lease agreements 18 Cash received from interest on deposits 19 Other cash received 20 Cash paid for purchase of equipment 21 Other cash paid $ 3,500 $ 450 $ 650 $ 4,600 $ 9,895 22 Net cash from banking and investment 23 Increase (decrease) in cash during the quarter 24 Cash balance at the beginning of the quarter 25 Cash balance at the end of the quarter 32,575 $ $ 42,470 CashFlow Peoria Champaign Rockford +