Pass-Fail Assignment

You must turn this assignment in, 100% correct, by the fourth class period or I will drop you from the class roll for failure to satisfy prerequisites.  If you turn it in correct on the second class period, it will count as a 100% quiz grade.

The purpose of this assignment is to make sure you are ready to quickly and efficiently master new techniques in Excel.  Therefore, do not use a different method to get the same answers; use exactly the methods required below.

Widgets are shipped in boxes of ten; if an order is not evenly divisible by ten, the last box is partially filled with widgets and padded with extra packing material.  An important customer insists in ordering by the dozen and half dozes.

Starting from a new blank Excel worksheet, do the following:
Put your name in cell A1

Put the number 1 in cell A2 and the word "Dozens" in cell B2

Put the number 12 in cell A3 and the words "Widgets per dozen" in cell B3

In cell A4, write an Excel formula that finds the number of widgets by multiplying the contents of cell A2 times the content of cell A3.  The formula must NOT contain the number 1 or the number 12; it must use Excel cell references.

Put the word "Widgets" in cell B4

Put the number 10 in cell A5 and the words "Widgets per box" in cell B5

In cell A6, use the Excel function ROUNDUP with cell references to cells A4 and A5 to calculate the number of boxes required.  Since an integer number of boxes will be needed, the number of digits to round to is zero.

Put the word "Boxes" in cell B6

Put the word "Dozens" in cell A8; make sure column A is wide enough to hold it.
Put the numbers .5, 1, 1.5, 2 and so on through 8.0 in cells A9 through A24

Put the word "boxes" in cell B7
Put the simple Excel formula    =A6    in cell B8

Highlight cells A8 through B24 and create a real Excel Data Table in the range.
You get to data table from the "Data" menu in classic Excel,
or from the "What-if" menu in Excel 2007
Use A2 as the column input cell.  Leave the row input cell untouched.

Turn in two printouts of your spreadsheet, one in numeric mode and on in formulas mode.
To switch between the two modes, hold the Ctrl key and touch the tilde key near the upper left of the keyboard.  Tilde is the wavy line character  ~