Microsoft Office Tutorials and References
In Depth Information
Case Problem 3
Data Files needed for this Case Problem: Contacts.doc and Budget.doc
Contact List for Flower Box Bakery Ken Yamamoto recently opened Flower Box Bakery, a
wholesale bakery catering to upscale cafes and tea shops in suburban St. Louis. He has just
acquired a list of potential sales contacts from the local chamber of commerce via e-mail.
The information consists of names, phone numbers, and managers for a number of new
cafes and restaurants in the St. Louis area. The information is formatted as simple text, with
the pieces of information separated by commas. Ken asks you to convert this text into a
table and then format the table to make it easy to read. When you’re finished, he needs you
to sum a column of numbers in his Advertising Budget table. Complete the following:
Go beyond what you’ve
learned to convert text
into a table and then
use other advanced
table commands to
enhance the table.
1. Open the file named Contacts located in the Tutorial.03\Cases folder included with
your Data Files, and then save it as Sales Contacts in the same folder. Check your
screen to make sure your settings match those in the tutorials.
2. Select the entire document, click Table on the menu bar, point to Convert, and then
click Text to Table. In the Convert Text to Table dialog box, make sure the settings
indicate that the table should have three columns. Select the AutoFit to contents
option button to ensure that columns are sized appropriately, select the Commas
option button, and then click the OK button. Word converts the list into a table.
3. Replace the name “Enrique Mendoza” with your first and last name.
4. Insert a new row at the top of the table, and then insert appropriate column headings.
5. When you need to format a table quickly, you can allow Word’s AutoFormat com-
mand to do the work for you. Click anywhere in the table, click Table on the menu
bar, and then click Table AutoFormat to open the Table AutoFormat dialog box. Scroll
down the Table styles list box to see the available options. Click options that interest
you, and observe the sample tables in the Preview box. Note that you can deselect
the check boxes in the “Apply special formats to” section to remove boldface or
shading from columns or rows that don’t require it. Select a table style that you think
is appropriate for the Contacts table, deselect check boxes as you see fit, and then
click the Apply button.
6. Sort the table alphabetically by column A.
7. Place the pointer over the Table Resize handle, just outside the lower-right corner of
the table. Drag the double-arrow pointer to increase the height and width of each cell
to a size of your choice. Notice that all the parts of the table increase proportionally.
8. Save your work, preview the table, print it, and then close the document.
9. Open the file Budget located in the Tutorial.03\Cases folder included with your Data
Files, and then save it as Advertising Budget in the same folder. If necessary, open the
Tables and Borders toolbar.
10. Select the cell containing the word “Total” and the blank cell to its right. Click the
Merge Cells button on the Tables and Borders toolbar. The two cells are merged into
one. Format the word “Total” so that it aligns on the right side of the new, larger cell.
11. Click the blank cell to the right of the Total cell, and then click the AutoSum button
on the Tables and Borders toolbar. Word automatically sums the costs in the third col-
umn and displays the total ($400.00) in the selected cell.
12. Change the cost of the Missouri Monthly advertisement to $250, click the cell con-
taining the total ($400.00), and then click the AutoSum button again. Word updates
13. Save your work, preview the document, and then close it.