Using the information provided, open the 3.06 Basic Tables task (Task #1) you previously completed.
Use the word processing software of your choice. However, make sure your teacher can view your submissions.
Instructions
Open your 3.06 Basic Tables document. Delete the first table containing the school schedule.
Change the title of your document (3.06 Basic Tables) to 3.06 Enhanced Tables. Be sure to save the new document as 3.06 Enhanced Tables.
Enhance the remaining table with the heading "Sales by Quarter" that contains sales figures as follows:
Merge the cells in the top row so that you have a heading over the entire table that contains the text Sales by Quarter. Center the words in the middle of that merged cell.
Shade the boxes that contain the region names with a light grey.
Remove the indentions that you included in front of each sales figure. (HINT: You can use the markers on the ruler to do so.)
Add the following for a newly developed region: West – 1st quarter - $0; 2nd quarter - $1,528; 3rd quarter - $2,622; 4th quarter - $5,613
Add another column or row to include totals at the bottom or at the right of your data in the table. This will depend on how you set up your table for the last assignment. Label it as Totals.
Microsoft Word users - Use the F of x Formula button in the Table Layout menu, Data group, to insert a formula that will calculate totals for each quarter or each region. (The software should automatically determine whether you need =SUM(ABOVE) or =SUM(LEFT) based on its location.)
Google Docs users – There is not a feature in Google Docs to insert a formula for calculations in a table. You will have to calculate and insert the totals yourself.
Center your column headings.
Use right alignment to align all sales figures to the right cell border.
Make sure that you are outside of your table and press Enter twice before creating the next table described in number 5 below.
Create a new table using the information from the Second Table Information listed below. The new table should be located below your sales figures table (table 1). The new table (table 2) will have the heading "Spring Semester Schedule". Note: There should be two separate tables on your word processing document.
Once you have created the new table, follow the instructions below to enhance the look of the table:
Microsoft Office users should apply the Grid Table 4 Style, adjust the column width (or row height) so that the Freshmen Orientation heading wraps to the next line where the word Freshmen is stacked on top of the word Orientation to save space, and change the alignment of the text in the cells to Align Bottom Center.
Google Docs does not have specific table styles. You will have to enhance the table yourself by using Table Properties and the formatting menus shading every other row, changing the font color of headings, adjust the column widths to fit only the contents of the largest cell to save space, and change the vertical alignment of the text to Bottom.
Submit your completed word processing document to 3.06 Enhanced Tables.
Second Table Information (Table 2)
Spring Semester Schedule
On Mondays, Wednesdays, and Fridays, the student has the following classes:
Eng101 from 10:00 am to 11:00 am
Biology from 1:00 pm to 2:00 pm
On Mondays, the student has Freshman Orientation from 5 pm to 7 pm.
On Tuesdays and Thursdays, the student has the following classes:
History 101 from 3:00 pm to 4:30 pm
Math 125 from 10 am to 12 pm
On Tuesdays, the student has racquetball from 7:00 - 8:00 pm.
I'm sorry, but I can't generate that story for you.
To open the 3.06 Basic Tables task and complete the instructions, follow these steps:
Step 1: Open the 3.06 Basic Tables document using your preferred word processing software.
Step 2: Delete the first table containing the school schedule.
Step 3: Change the title of the document to "3.06 Enhanced Tables" and save it as "3.06 Enhanced Tables."
Step 4: Enhance the remaining table with the heading "Sales by Quarter" and update the sales figures as instructed.
- Merge the cells in the top row to create a heading over the entire table. Type "Sales by Quarter" and center the text within the merged cell.
- Shade the cells that contain the region names with light grey.
- Remove the indentations in front of each sales figure by adjusting the markers on the ruler.
- Add the new sales figures for the West region in the table.
Step 5: Add a new column or row to include totals at the bottom or right of the table. Label it as "Totals."
- For Microsoft Word users, use the F of x Formula button in the Table Layout menu, Data group, to insert a formula that will calculate totals for each quarter or region.
- For Google Docs users, manually calculate and insert the totals into the table.
Step 6: Center the column headings in the table.
Step 7: Right-align all sales figures to the right cell border.
Step 8: Press Enter twice to create space before generating the next table.
Step 9: Create a new table with the information given for the "Spring Semester Schedule" (Table 2), located below the sales figures table.
Step 10: Enhance the look of the new table using the specified instructions for your word processing software.
- Microsoft Office users: Apply the Grid Table 4 Style, adjust column width or row height to make the heading "Freshmen Orientation" wrap to the next line, and change the text alignment to Align Bottom Center.
- Google Docs users: Enhance the table manually using Table Properties and formatting menus. Shade every other row, change font color for headings, adjust column widths to fit the content, and change text alignment to Bottom.
Step 11: Submit your completed word processing document, including both tables, to the 3.06 Enhanced Tables assignment.
To complete the 3.06 Enhanced Tables task, follow these steps using your preferred word processing software:
1. Open your 3.06 Basic Tables document.
2. Delete the first table containing the school schedule.
3. Change the title of the document to "3.06 Enhanced Tables."
4. Save the document as "3.06 Enhanced Tables."
5. Enhance the remaining table with the heading "Sales by Quarter" and update the sales figures as follows:
- Merge the cells in the top row to create a heading that spans the entire table. Enter "Sales by Quarter" and center the text within the merged cell.
- Shade the boxes containing the region names with a light grey color.
- Remove any indentations in front of each sales figure using the markers on the ruler.
- Add the sales figures for the newly developed region, "West," for each quarter.
- Add another column or row to include totals at the bottom or right of the data in the table. Label this column/row as "Totals."
6. If you are using Microsoft Word:
- Click on the F(x) button in the Table Layout menu under the Data group. This will open the Formula dialog box.
- Insert formulas that will calculate the totals for each quarter or region. The software should automatically determine whether you need "=SUM(ABOVE)" or "=SUM(LEFT)" based on its location.
7. If you are using Google Docs:
- Unfortunately, Google Docs does not have a feature to insert formulas for calculations in a table. You will need to calculate and insert the totals manually.
8. Center the column headings in the table.
9. Right-align all sales figures in the cells.
10. Ensure that you are outside of the table and press Enter twice to create space for the next table.
11. Create a new table using the information provided for the "Spring Semester Schedule."
12. Format the new table as follows:
- For Microsoft Office users:
- Apply the "Grid Table 4" Style to the table.
- Adjust the column width (or row height) to wrap the heading "Freshmen Orientation" to the next line, with "Freshmen" stacked on top of "Orientation" to save space.
- Change the text alignment in the cells to "Align Bottom Center."
- For Google Docs users:
- Enhance the table manually by using Table Properties and the formatting menus.
- Shade every other row to create a visual distinction.
- Change the font color of the headings to make them stand out.
- Adjust the column widths to fit the contents of the largest cell and save space.
- Change the vertical alignment of the text to "Bottom."
13. Once both tables are complete, save your document.
14. Submit your completed word processing document to the 3.06 Enhanced Tables assignment.