M.+Excel+Chapter+5

=Creating, Sorting, and Querying a Table=

Objectives

 * Create and manipulate a table
 * Delete sheets in a workbook
 * Validate data
 * Add calculated columns to a table
 * Use icon sets with conditional formatting
 * Use the VLOOKUP function to look up a value in a table
 * Print a table
 * Add and delete records and change field values in a table
 * Sort a table on one field or multiple fields
 * Display automatic subtotals
 * Use Group and Outline features to hide and unhide data
 * Query a table
 * Apply database functions, the SUMIF function, and the COUNTIF function
 * Save a workbook in different file formats

__**Notes**__
New functions - for each function - DEFINE and write the general form of each. Example: IF - function dependent on a logical test ~ =if(logical_test, value_if_true, value_if_false)
 * VLOOKUP
 * DCOUNT
 * DAVERAGE
 * SUMIF
 * COUNTIF

**__Assignments__**
Lab 1 - Page 405 - 30 points - steps 1-7 Lab 2 - Page 408 - 60 points - Parts 1, 3 (you do not need to do document properties), and 4