Word Product Activation Failed Gahune Chris M Design Layout References Malings Review View Help 8. 9. Acrobat Tell me what you want to do AuBbCct Aalbcet Aolloca AaB Aatbci About AaBbC Ast Ticomet 1 Man 1 Normal 1 Port 1 SAM C Switch to the Perez worksheet, which contains a table named Perez that lists data for real estate agent Arturo Perez. Apply the Olive Green, Table Style Medium 12 table style to the Perez table, and then display the filter buttons to match the formatting of the other tables in the workbook. Nico noticed that the Perez table includes a duplicate record. Use a table tool to remove the duplicate record based on the values in the Listing ID and Listing Date columns. 10. The data bars in the last two columns of the table make some numbers hard to read and could coordinate better with the formatting of the Perez table. Edit the Data Bars conditional formatting rules for the range E3:F13 to use a Gradient Fill with the Gold, Accent 5 fill color (9th column, 1st row in the Theme colors palette). [Mac hint: Only change the positive value.] 11. Switch to the All Agents worksheet, which contains a table named Agents listing data for all of the Hallas Realty agents. Freeze the first two rows of the worksheet to display the worksheet title and column headings when the worksheet is scrolled. 12. Nico wants to calculate the totals for the agent data and the difference between the asking prices and sales prices. In cell 13, use the COUNTA function with a structured reference to count the values in the [Listing ID] column of the Agents table. In cell 34, use the SUM function with a structured reference to total the values in the [Asking Price] column of the Agents table. In cell 35, use the SUM function with a structured reference to total the values in the [Sales Price] column of the Agents table. 13. Nico added a table column to the end of the Agents table to calculate the difference between the asking prices and sales prices. Use Difference as the column heading. In cell G3, enter a formula using structured references but no function to subtract the value in the [Sales Price] column (cell F3) from the value in the [Asking Price] column (cell E3). Fill the range G4:G39 with the formula in cell G3 if Excel does not automatically do 50. Your workbook should look like the Final Figures on the following pages. Save your changes, completed project. close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your & Create and Share Regent Adobe FC Sigm Activate Windows search 9 41 Survy DAK