90.2K

Verified Solution

Link Copied!

Question 4 (10 marks) (a) Format the font in cell references A3 to D10 as times new roman font, 12 pt (1 mark) (b) Put a red double lined border around the outside of cell relerences 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. Reske column widths so that the text in cells B3, C3 and D3 are contained within one cell. (3 marks) (c) Replace the label "Judson Ford Realty - October Sales" in cell A1 with word art of the same 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 intemet. (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 boint on this chait and remove the Question 4 (10 marks) (a) Format the font in cell references A3 to D10 as times new roman font, 12 pt (1 mark) (b) Put a red double lined border around the outside of cell relerences 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. Reske column widths so that the text in cells B3, C3 and D3 are contained within one cell. (3 marks) (c) Replace the label "Judson Ford Realty - October Sales" in cell A1 with word art of the same 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 intemet. (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 boint on this chait and remove the

Answer & Explanation Solved by verified expert

See Answer