please show what steps (what buttons to click) or formulas. thanks!

a. 12. Add the SOLD picture, and then apply a style, resize and move the picture. Insert the SOLD picture downloaded from the Resources link. b. Apply the Metal Frame picture Quick Style (the third style from the left in the top row of the style gallery) to the picture. c. Resize the picture so it is 1.5 inches wide. Do not change the aspect ratio of the picture d. Reposition the picture so it is located near the bottom right corner of the chart as shown in Figure EX 7.67. Add a picture from to the worksheet header. a. Add the RealtyLogo picture (downloaded from the Resources link) to the left section of the worksheet header. Hint: Because this worksheet is a chart sheet, you cannot switch to Page Layout view. You will need to use the Page Serap dialog instead. If you need help with this method, refer to another webed box in the Adding a Picture to a Header skill. Challenge Yourself 7.4 (Mac 2016) Last Updated 3/2/18 Ppproach: Excel 2016 Chapter 7: Exploring Advanced Charts and Graphics b. Preview how the worksheet will look when printed to verify that you inserted the correct pieture into the header. It should look similar to Figure EX 7.67. 1 and 2 Bedroom Condo Sales SOL FOKO SALE Home Insert Page Layout Formulas Data Review View Cut Arial 10 AA- Wrap Text General Copy Paste U- A. Merge & Center $ % > Format Conditional F Formatting as H2 x fx D E F G H ! K L M N O P o B 1 House Type 2 Modem 59,505.000 3 Condo $13,205,000 4 Ranch $18,515,000 5 Mediterranean $15,855,000 6 7 Sales by House Type Sales by House Type Modern $20.000.000 9 10 11 $18.000.000 Mediterranean 20% $15,000,000 $14.000.000 $12.000.000 13 14 15 16 17 18 $10.000.000 Condo 21% uli 5.000.000 56.000.000 20 $4,000,000 $2,000,000 Ranca 33N Matem eando Ranch Mediterranean 50 Modem Cande Ranch Mediterranean 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 42 43 44 45 47 49 50 51 > Summary by Type Condo Sales Sales Data + Ready Home Insert Page Layout Formulas Data Review View Chart Design Format Cut Calibri (Body). 9 A- A- 2 Wrap Teat General Copy - Paste BIU Merpe & Center Forma S. Insert Format Conditional Format Formatting able Cell Shes H2 X 1 and 2 Bedroom Condo Sales $600.000 $500.000 . $400,000 $100 000 $200.000 $100.000 50 wins + 100 11 1/15/12 WANY Summary by Type Cond Sales Sweat Home Insert Page Layout Formulas Data Review View Table Cut Arial - 10 A- A+ Currency Copy To Wrap Text Paste B I U. Format Merge & Center $ . % +0 Conditional Format Formatting as Table Cell in Styles C140 vfx SUBTOTAL(109. Purchase Price]) K M Grande B C D E F G H Date of Purchase House Type Purchase price Agent Byens Bedro Bathrooms Fireplace 50 3/4/17 Condo $425,000 Roma Wilson 2 Yes 3/4/17 Condo $385.000 By Owner Zimmerman 1 Yes 9/17/16 Condo $225,000 Roma Jackson 2 No 9/17/10 Condo $355,000 Century 21 2 2 No 90 /15/16 Conto 1440,000 By Owner Chipman 1 2 No 102 7/18/10 Condo $550,000 Century 21 Holland 2 1 Yes 15 7/18/16 Condo $550,000 Remas Net 2 1 No 7/16/16 Condo 5550.000 By Ourer Hawkins 2 1 Yes 4/20/16 Condo $385.000 homes and Garden Melon 2 1 No 4/2016 Condo $425.000 Home and Garden Party 1 1 Yes 140Total 54.250.000 10 1.8 14 141 142 143 Near Shoe Rate No 5.75% People's No 6.75% Bank Of America Yos 5.50% First Federal Yes 6.50% First Federal Yes 6.75% Citywide No 5.504 Citizens Yes 6.25% Fist Federal No 6.75% People's Yes 5.75% Nations NO 6.75% Bank of America 6.23% Mortgage Year 15 30 30 30 30 30 40 15 15 30 26.5 147 148 149 150 151 152 153 154 155 15 190 157 558 156 589 160 100 161 162 163 10 164 165 10 1 157 156 168 16 STO 174 175 178 17T 178 179 Summary by Type Condo Sales Srles Data + SOLD FOR SALE a. 12. Add the SOLD picture, and then apply a style, resize and move the picture. Insert the SOLD picture downloaded from the Resources link. b. Apply the Metal Frame picture Quick Style (the third style from the left in the top row of the style gallery) to the picture. c. Resize the picture so it is 1.5 inches wide. Do not change the aspect ratio of the picture d. Reposition the picture so it is located near the bottom right corner of the chart as shown in Figure EX 7.67. Add a picture from to the worksheet header. a. Add the RealtyLogo picture (downloaded from the Resources link) to the left section of the worksheet header. Hint: Because this worksheet is a chart sheet, you cannot switch to Page Layout view. You will need to use the Page Serap dialog instead. If you need help with this method, refer to another webed box in the Adding a Picture to a Header skill. Challenge Yourself 7.4 (Mac 2016) Last Updated 3/2/18 Ppproach: Excel 2016 Chapter 7: Exploring Advanced Charts and Graphics b. Preview how the worksheet will look when printed to verify that you inserted the correct pieture into the header. It should look similar to Figure EX 7.67. 1 and 2 Bedroom Condo Sales SOL FOKO SALE Home Insert Page Layout Formulas Data Review View Cut Arial 10 AA- Wrap Text General Copy Paste U- A. Merge & Center $ % > Format Conditional F Formatting as H2 x fx D E F G H ! K L M N O P o B 1 House Type 2 Modem 59,505.000 3 Condo $13,205,000 4 Ranch $18,515,000 5 Mediterranean $15,855,000 6 7 Sales by House Type Sales by House Type Modern $20.000.000 9 10 11 $18.000.000 Mediterranean 20% $15,000,000 $14.000.000 $12.000.000 13 14 15 16 17 18 $10.000.000 Condo 21% uli 5.000.000 56.000.000 20 $4,000,000 $2,000,000 Ranca 33N Matem eando Ranch Mediterranean 50 Modem Cande Ranch Mediterranean 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 42 43 44 45 47 49 50 51 > Summary by Type Condo Sales Sales Data + Ready Home Insert Page Layout Formulas Data Review View Chart Design Format Cut Calibri (Body). 9 A- A- 2 Wrap Teat General Copy - Paste BIU Merpe & Center Forma S. Insert Format Conditional Format Formatting able Cell Shes H2 X 1 and 2 Bedroom Condo Sales $600.000 $500.000 . $400,000 $100 000 $200.000 $100.000 50 wins + 100 11 1/15/12 WANY Summary by Type Cond Sales Sweat Home Insert Page Layout Formulas Data Review View Table Cut Arial - 10 A- A+ Currency Copy To Wrap Text Paste B I U. Format Merge & Center $ . % +0 Conditional Format Formatting as Table Cell in Styles C140 vfx SUBTOTAL(109. Purchase Price]) K M Grande B C D E F G H Date of Purchase House Type Purchase price Agent Byens Bedro Bathrooms Fireplace 50 3/4/17 Condo $425,000 Roma Wilson 2 Yes 3/4/17 Condo $385.000 By Owner Zimmerman 1 Yes 9/17/16 Condo $225,000 Roma Jackson 2 No 9/17/10 Condo $355,000 Century 21 2 2 No 90 /15/16 Conto 1440,000 By Owner Chipman 1 2 No 102 7/18/10 Condo $550,000 Century 21 Holland 2 1 Yes 15 7/18/16 Condo $550,000 Remas Net 2 1 No 7/16/16 Condo 5550.000 By Ourer Hawkins 2 1 Yes 4/20/16 Condo $385.000 homes and Garden Melon 2 1 No 4/2016 Condo $425.000 Home and Garden Party 1 1 Yes 140Total 54.250.000 10 1.8 14 141 142 143 Near Shoe Rate No 5.75% People's No 6.75% Bank Of America Yos 5.50% First Federal Yes 6.50% First Federal Yes 6.75% Citywide No 5.504 Citizens Yes 6.25% Fist Federal No 6.75% People's Yes 5.75% Nations NO 6.75% Bank of America 6.23% Mortgage Year 15 30 30 30 30 30 40 15 15 30 26.5 147 148 149 150 151 152 153 154 155 15 190 157 558 156 589 160 100 161 162 163 10 164 165 10 1 157 156 168 16 STO 174 175 178 17T 178 179 Summary by Type Condo Sales Srles Data + SOLD FOR SALE