| Computerized Accounting | |||||||||||
Homework #12 – Formulas for Accountants: Tables & Filtering |
|||||||||||
| Practice: | |||||||||||
| 1) | Convert the data below into a Table (insert ribbon) | ||||||||||
| 2) | Add a row for Belhaven; add numbers for the sports listed | ||||||||||
| 3) | Add a total row at the bottom of the table (right mouse on any cell in the table, Select “Table” and “Total Row” | ||||||||||
| 4) | Copy the total formula to each sport and check the results | ||||||||||
| 5) | Name your table (Table Tools, Design, Table Name-upper left corner) | ||||||||||
| 6) | Change the style of your table to one you like (Table Tools, Design, Table Styles) | ||||||||||
| 7) | Enter a formula to add the two schools that start with “M” in the row provided below the table. | ||||||||||
| 8) | Filter the School Name to show totals for Mississippi State & Missouri; compare to manual calculation in row 40 | ||||||||||
| 9) | Clear the filter on school | ||||||||||
| 10) | Sort the table by School name. Note that the manual calculation below the table for “M” schools is no longer correct | ||||||||||
| 11) | Filter the School Name to show all schools that start with the letter ‘T’; Type the Total for Tennis in the cell provided below the table. | ||||||||||
| 12) | Clear the filter on school name | ||||||||||
| 13) | Filter Baseball data as greater than 60. Note the different options for numbers’ columns vs. text columns. | ||||||||||
| 14) | Type the Total in the cell provided below the table | ||||||||||
| School | Football | Basketball | Baseball | Tennis | Soccer | Track | |||||
| Alabama | 150 | 75 | 90 | 53 | 97 | 71 | |||||
| LSU | 143 | 68 | 83 | 46 | 90 | 64 | |||||
| Auburn | 136 | 61 | 76 | 39 | 83 | 57 | |||||
| Texas Tech | 135 | 60 | 75 | 38 | 82 | 56 | |||||
| Tennessee | 123 | 48 | 63 | 26 | 70 | 44 | |||||
| Ole Miss | 120 | 45 | 60 | 23 | 67 | 41 | |||||
| Florida | 118 | 43 | 58 | 21 | 65 | 39 | |||||
| South Carolina | 115 | 40 | 55 | 18 | 62 | 36 | |||||
| Georgia | 112 | 37 | 52 | 15 | 59 | 33 | |||||
| Mississippi State | 98 | 23 | 38 | 1 | 45 | 19 | |||||
| Vanderbilt | 96 | 21 | 36 | -1 | 43 | 17 | |||||
| Missouri | 95 | 20 | 35 | -2 | 42 | 16 | |||||
| Enter Formula for “M” Schools-all sports | |||||||||||
| Type the “T” Schools’ total for Tennis | |||||||||||
| Type the total for Baseball > 60 | |||||||||||
Last Updated on February 11, 2019 by Essay Pro