Rank
Country
Population 2012
Population 2014
1.
China
1,343,239,923
1,355,692,576
2.
India
1,205,073,612
1,236,344,631
3.
United States
313,847,465
318,892,103
4.
Indonesia
248,645,008
253,609,643
5.
Brazil
199,321,413
202,656,788
6.
Pakistan
190,291,129
196,174,380
7.
Nigeria
170,123,740
177,155,754
8.
Bangladesh
161,083,804
166,280,712
9.
Russia
142,517,670
142,470,272
10.
Japan
127,368,088
127,103,388
This taskset is to provide practice working with tables. The document that you start with has a single table already defined without boundary lines. To facilitate viewing the cells in the table, you should make sure that gridlines are visible. If gridlines are not visible turn them on by first clicking on any cell in the table. This makes the table menu tabs visible. Click on the Layout tab to show the Layout ribbon. Click on the View Gridlines menu icon.
Task #
Points
Task Description
1
5
Add a new row to the top of the table, merge the new row so that it only has one cell. Cut the title above the table and paste the text into the new table row.
2
3
Insert a new column to the right of the fourth column.
Enter the title "Percentage Change" in the second row of the new column. Autofit the column to the new text.
4
Now that you have added another column, you need to merge that new cell into the heading. Merge the two cells in the first row.
10
Enter the percent of change values in the Percentage Change column to reflect the percent of change between the two years.
Percentage Change
0.93
2.59
1.61
1.67
3.09
4.13
3.23
-0.03
-0.21
6
If gridlines are showing on the table, turn them off. Add borders to the table. Select all the cells in the entire table and choose "All borders" using the Borders icon on the Table-Design ribbon.
7
Below the first table create a new table with four columns and five rows using the Graphic Grid on the Insert Table drop down.
8
Merge the first row of the table to make it one large cell.
9
Enter the title "Sales by Division 2016" without the quotes in the merged cell. Change the alignment to centre and the font size to 14pt.
Enter the titles "North East", "South East" and "Mid-West" without the quotes centred in the first through third columns of the second row.
11
Insert a new column to the left of the first column and merge the first row again so that it only displays one cell.
12
Enter the titles "Jan-Apr", "May-Aug" and "Sept-Dec" without the quotes in rows three through five of the first column.
13
Using the information shown in the figure enter the sales figures for each division in the table.
North East
South East
Mid-West
Jan-Apr
25698
45874
69852
May-Aug
23874
46581
72154
Sept-Dec
28658
45895
74589
14
Enter the heading "Total Sales" without the quotes in the second row of the last column.
15
Calculate the total sales for Jan-Apr by using the formula =SUM(LEFT).
16
Using the same =SUM(LEFT) formula calculate the total sales for the other months.
17
Right align all the numbers in the table.
18
Apply the "Grid Table 5 Accent 6" design to the table. This is the last column and fifth row of the Grid Table Styles.
19
0
Save your file. Navigate to the Assignment ribbon and Submit your work for grading.
Total:
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here