• Students will be able to create a table in Word.
• Students will be able to incorporate formulas to solve math problems in a table in Word.

You have been hired by "Chocolates Are Us" to design a weekly sales record and an order form template to use for customer orders. You will create your table in Microsoft Word.

-Open a New document in Microsoft Word.

 -Click on View-> Header and Footer and type your name and hour in the Header. Click Close

-Click on View-> Toolbars-> Tables and Borders

- Click File ->Page Setup->Click the Landscape Radio Button->Click OK to close the Page Setup Dialog Box

Gift Item:	Price:
Chocolate Cell Phone:	$ 7.95
1 Dozen Chocolate Long Stem Roses::	$ 39.95
Chocolate Pizza:	$ 6.95
Chocolate CD:	$ 11.95
Chocolate Baby Shoes:	$ 9.95
Chocolate Computer:	$ 11.95

• You will now enter the number of each gift items sold per day. Use the table below to find the fictitious numbers you will enter as sold per day.

To understand where your formulas and what numbers you will use, look at the table below. You now know how the table is laid out so all you will need to do is enter formulas that will automatically calculate the daily and weekly sales of each sales item as well as the total amount for each day and the total sales for the week.

**You will need to enter a formula that will multiply the number of items sold that day by the cost of each item. Position the insertion point in D3 (check the table page layout document above) and follow the directions below to enter a formula that will automatically calculate daily and weekly sales: See Print Out

• Click Table and then Formula.
• At the Formula dialog box, you want to enter the formula =B3*C3 to multiply the cost of the item (B3) by the number sold (C3)
• Click OK
• $95.40 should now appear in the cell

** The Total for Week is the daily cost added for Monday, Tuesday, Wednesday, Thursday, and Friday. You first need to write down the cells where the daily cost are displayed. To calculate the Total for Week: See Print Out

• Click Table then Formula
• At the Formula Dialog Box, enter the following formula to add the daily cost for the Chocolate Cell Phone:
  • First write down the daily sales cell number for Monday, Tuesday, Wednesday, Thursday, Friday (D3, F3, H3, J3, L3)
  • You want to add (+) these numbers together, so at the Formula Dialog Box, enter =(D3 + F3 + H3 + J3 + L3) to add all the numbers in these cells together
  • Click OK
  • $1033.50 should now appear in the Total Sold For Week Column

The bottom row will hold the Total Sales of all Gift Items Daily and Weekly. You will need to write down the cells that hold the numbers that you will use to get the Daily and Weekly Results. You will also split the cells into two rows in order to make the data more acceptable to read.

To split the cell immediately to the right of Total Sold Each Day:

• Place your cursor in the cell you wish to split
• Click Table on the Menu Toolbar and Select Split Cells
• At the Split Cells Dialog box, the default is to split columns into two columns, however, we want to split the cell into two rows. Change the columns default of 2 to 1 and then change the rows default of 1 to 2
• Click OK
• The cell should now be split horizontally
• Continue with the next four cells (refer to table example above)
• Type the name of the week in the top of the cell and you will enter a formula in the bottom of the cell

**To Calculate the Total Daily Sales for Monday:See Print Out

• Write down the cells you want to add together (D3, D4, D5, D6, D7, D8)
• Place your cursor in the cell directly under the cell that contains the word Monday
• Click Table and then select Formula
• At the Formula Dialog box, enter the formula that will calculate the total amount of cells for Monday: =(D3 + D4 + D5 + D6 + D7 + D8)
• Continue entering formulas to calculate the total for the remaining days of the week

• Shade the first and second rows completing the following steps:

• Save your Table in your My Documents Folder and upload your Table to your webpage.

You will now create a form document that will be used to evaluate customer satisfaction. You will first create a template document so you can use the document over and over again without having to create a new document every time a customer fills one out. To create a template, follow the steps below:

• Click File, and then New.
• At the New dialog box with the General tab selected, make sure Blank Document is selected in the list box.
• Click Template in the Create New section at the bottom right corner of the dialog box.
• Click OK or press Enter.
• At the document screen, make sure the default font is 12-point Times New Roman.
• Turn on the display of the Forms toolbar by clicking View->Toolbars-> Forms. This is the toolbar that should appear:
• 

• Key the beginning portion of the form shown below up to the colon after Name:.

• At the Forms toolbar, click the Text Form Field button .

• After inserting the form field, press the Enter key, and then create the remaining text and text form fields as shown below. Your fields will appear gray in Microsoft Word.

• To create the check boxes after Yes and No, position the insertion point where you want the check box to display, and then click the Check Box form Field button  on the Forms toolbar.

Chocolates Are Us Service Evaluation Form

Name: (Text field)
Address: (Text field)
Date of Birth: (Text field)
Occupation: (Text field)

1. Is this the first time you have used Chocolates Are Us?

Yes(Checkbox field) No (Checkbox field)

2. How would you rate our service?
Excellent (Checkbox field)
Fair (Checkbox field)
Poor (Checkbox field)
Worst Experience I have ever had!!! (Checkbox field)

3. How did you hear about us?
Friend (Checkbox field)
Advertisement on a Webpage (Checkbox field)
Using a Search Engine (Checkbox field)

Click the box next to the items you purchased:

Chocolate Phone (Checkbox field) How many? (Text field)
Dozen Long Stem Roses (Checkbox field) How many? (Text field)
Chocolate Pizza (Checkbox field) How many? (Text field)
Chocolate CD (Checkbox field) How many? (Text field)
Chocolate Baby Shoes (Checkbox field) How many? (Text field)
Chocolate Computer (Checkbox field) How many? (Text field)

Fill in any additional information that could help us better serve our customers in the text box below.

• After the form is completed, protect the document by clicking the Protect Form button
   on the Forms toolbar.

• Save the document to your student folder with the name Chocolate Customer Form.

• Save your Template in your My Documents Folder and upload your template to your web page. 

A table can be very useful when creating a form with form fields. A table can be customized to create a business form such as an invoice or a purchase order. Follow the directions below to create a form using the table feature:

• Click File and then New
• At the New dialog box with the General tab selected, make sure Blank Document is selected in the list box.
• Click Template in the Create New section at the bottom right corner of the dialog box.
• Click OK.
• At the document screen, make sure the default font is 12-point Times New Roman.
• Display the Forms toolbar.
• Click the Draw Table button  on the Forms.

• Use the buttons on the Forms(shown below) (if not visible, click View>Toolbars>Forms) to draw the table lines shown below:
  

• Change the text alignment to Align Center for specific cells by completing the following steps:
  • Select the cells that will contain the text Date, Description, Amount, and Ref #.
  • Click the down-pointing triangle at the right side of the Align Top Left button on the Tables and Borders toolbar.
  • At the drop-down palette of choices, click Align Center (second option from the left in the second row).
  • Continue to key the above information in along with the form fields.
  • After the table is completed, protect the document by clicking the Protect Form button on the Forms toolbar.
  • Key the customer information from your customer service forms into your form. You should end up with two forms saved with two different names.