Computerized Accounting

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