Mark the steps as checked when you complete them.

Open the start file EX$2019-$SkillReview$-5-2.$ The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it$.$

If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.

Format the data on the Sales Data worksheet as a table using the Blue, Table Style Medium $2$ table style:

a$.$ Select any cell in the data.

b$.$ On the Home tab, in the Styles group, click the Format as Table button to display the Table Styles gallery.

c$.$ Click the Blue, Table Style Medium $2$ Quick Style. It is the second option in the Medium section of the gallery.

d$.$ Verify that the My table has headers check box is checked and that the correct data range is selected.

e$.$ Click OK$.$

Add a Total row to the table to display the number of buyers; the average number of bedrooms and bathrooms for each sale; and the average purchase price, interest rate, and mortgage length.

a$.$ On the Table Design tab, in the Table Style Options group, click the Total Row check box.

Alternate On the Table Tools Design tab, in the Table Style Options group, click the Total Row ch

b$.$ In the Total row at the bottom of the table, click in the Buyers column, click the arrow, and select the Count