Scoring & Directions
The Excel project will be graded as follows:
Remember at least two of the numbers in the sum and average components must have three decimal places.
The headings are to be centered and bold. Five items for each section are required. In the "Sum" and "Average" columns you must have at least two numbers with three or more decimal places. Three or four decimal places is adequate. If you input numbers with an excessive amount of places, it will be difficult to format your worksheet. Don't forget to format (round) the sum to hundredths and the average to tenths. Also, these two cells, sum and average, must have a fill color and a font color that is not black. The font for these two cells must be bold. If you select a fill color and a font color that make the cells difficult to see, you will lose points. Don't forget to include "Sum =" and "Average =" These cells are to be formatted bold and aligned right. Remember, all formulas start with an equal sign (=). Do not center the numbers in the “Sum” and “Average” columns.
In the invoice section, the headings must also be centered and bold. The "total =" cell and the actual total must be bold. All of the cells with money must be formatted with the "accounting - two decimal places" option. Numbers in the "Quantity" and "Items" columns must be centered. Sales tax is 7.5%. Remember to change the percent to a decimal.
Four cells have the "thick bottom border." You can view which cells require this border by selecting the link at the bottom of this page. Go to format, cells, border and select the location of the thick border.
All three components (sum, average, invoice) are to be on one work-sheet and it (the tab) must be named - Sum. You must change the name from "Sheet 1" to "Sum".
Follow the directions listed here and those given in class. Refer to the example that can be viewed by clicking on the link at the bottom. The use of any other formatting options will result in lost points. If you use different font colors or fill colors in cells that are not specified, you will lose points.
The file is to be named - sum.xls You do not need to write ".xls" The "save" and "save as" features will do that for you.
It is to be saved in a folder named - math in your H drive.