M.+Excel+Test

You need to create a workbook for your business that you started during our Microsoft Word Unit. Below are the requirements:

o 4 worksheets (could be 3 cities, 1 total sheet like NextDVR) o 1 chart sheet

__ Worksheet Data __
o Name cells (at least 4) o Use the NOW function to enter the date o Change column width o Change row height o Borders o Shading o Fill Color o Font Color o Use Fill Series o Conditional formatting o Use the following functions at least once: o IF function o SumIf o CountIf o Sum o Average o Max o Min o Sort a field alphabetically o Merge and Center o Format dollars, units as needed o Format as a table (at least once) o Add a data validation rule to at least one field o At least 12 records o At least 8 fields o Name sheet tabs o Color sheet tabs o Reorder sheet tabs as needed o Use multiple lines in a cell (alt+enter) o 2 formulas of your choice o Use at least one cell style o Header & Footer on all worksheets o Make sure each worksheet fits on one page o Change margins, orientation, etc as needed o Center data horizontally on the page

__ Chart Formatting __
o Choose a chart that best fits your data o Format colors of all pieces of chart o Add at least 2 shapes to the chart o Use WordArt for the title o No legend o Chart sheet name o Chart sheet color o Chart should be after all data (sheet tabs)

When you finish the test, have Mrs. Nitchals come to your desk and she will check it with you showing her where you performed the operations.

= __TV Commericial for your Business__ =

Create a TV commercial for your business.
Movie - 75 points
 * Script due before issued a camera - 25 points
 * :45 - 1:30 in length
 * Use Windows Movie Maker to edit movie
 * Be CREATIVE!!!
 * Add text to movie
 * You could also add music, etc
 * Finish movie - Save to computer
 * Drop WMV movie file into Nitchals folder for points