• 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.

• The last row needs to be adjusted to show the total amount of all gifts sold per day, as well as for the week. The first thing that needs to be done is to merge cells. To merge cells, select the first two columns by dragging the mouse through the cells, click Table on the Menu Toolbar, then select merge cells. Continue to merge two cells at a time, leaving the last cell as one. Refer to the table above.
• Before you enter formulas, you must understand the way the cells are aligned within the table. Columns are represented by the letters of the alphabet, beginning with the letter A, and continuing B, C, D, and so forth.
• Rows are represented by numbers (1, 2, 3, 4, etc.) See the table below (Notice I have not included the last row in the representation because you will not need to use any of these cells for your formulas):

Table Columns and Rows Layout

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.

Yellow-Where you will place your formula
Red-The columns that contain the data you wish to calculate

• 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:
  • 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
• Continue to enter formulas across cells multiplying (*) the cost of the item by the number sold. Check your answers on the calculator under Accessories on the Computer (Start>Program>Accessories>Calculator)

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:

• 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
• Continue entering formulas for the rest of the gift items using the appropriate cells

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:

• 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:

• 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.
• Key the beginning portion of the form shown below up to the colon after Name:.
• Turn on the display of the Forms toolbar by clicking View, pointing to Toolbars, and then clicking Forms. This is the toolbar that should appear:



• 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.

• 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.
• Have 2 people fill out your form and save it to your folder under their name.

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 No (Checkbox field)

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

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

Click the box next to the items you purchased:

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

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

Creating a Template Invoice Form

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 Toolbar.
• Use the buttons on the Tables and Borders toolbar (shown below) (if not visible, click View>Toolbars>Tables and Borders) 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.