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

Homework #12 – Formulas for Accountants: Tables & Filtering