14 F G H M N B C D E 1 udson Ford Realty October Sales 2 Property Asking Price Sales Price 122 Wed 4000 W 5 4567 SW 5750 W 6 123 Alam 3000 www 79000 Bric 2500 WWW 8 5596 Pov 2250 ## www 3 8900 NS 4200 H TH A l 10 75 Mayn: 2475 11 12 13 14 15 16 Question 4 (10 marks) (a) Format the font in cell references A3 to D1 as times new roman font, 12 pt (1 mark) (b) Put a red double lined border around the outside of cell referencen A3 to D10. Format the same cell range to display blue solid lines between cells inside the red border Apply light yellow shading to this cell range Resize column widths so that the text in cells B3, C3 and D3 are contained within one cell (3 marks) et tabel Judson Ford Realty - October Sales in cell A1 a word art, substitute your name. You may choose any design that you wish. (2 marks) (d) Insert a picture of a house next to the information in the property table. You may use clipart or download an image from the internet (1 mark) (e) Create a column chart on this worksheet that displays the address of each property on the x ais and the sales price on the y access Change the colour of each data point on this chart and remove the gridlines Ensure that you have labelled each axis (3 marks) 22 Q2 08 04 Os Summary Week+ Week 2 Week 3 Week 4 14 F G H M N B C D E 1 udson Ford Realty October Sales 2 Property Asking Price Sales Price 122 Wed 4000 W 5 4567 SW 5750 W 6 123 Alam 3000 www 79000 Bric 2500 WWW 8 5596 Pov 2250 ## www 3 8900 NS 4200 H TH A l 10 75 Mayn: 2475 11 12 13 14 15 16 Question 4 (10 marks) (a) Format the font in cell references A3 to D1 as times new roman font, 12 pt (1 mark) (b) Put a red double lined border around the outside of cell referencen A3 to D10. Format the same cell range to display blue solid lines between cells inside the red border Apply light yellow shading to this cell range Resize column widths so that the text in cells B3, C3 and D3 are contained within one cell (3 marks) et tabel Judson Ford Realty - October Sales in cell A1 a word art, substitute your name. You may choose any design that you wish. (2 marks) (d) Insert a picture of a house next to the information in the property table. You may use clipart or download an image from the internet (1 mark) (e) Create a column chart on this worksheet that displays the address of each property on the x ais and the sales price on the y access Change the colour of each data point on this chart and remove the gridlines Ensure that you have labelled each axis (3 marks) 22 Q2 08 04 Os Summary Week+ Week 2 Week 3 Week 4