Summative Assessment 119708

1. Create a table with 2 columns and 7 rows that contains the following contents: (4)

Subject                               Marks

Afr                                       78

Eng                                     81

Science                               76

Biology                                65

Maths                                  67

Accounting                          56

2. Delete the word Accounting and insert Art (2)
3. Insert a row below Art and enter the text Geography in the created row’s 1st cell. (4)
4. Copy the mark for Eng (81) into the last cell as the mark for Geography. Call the trainer when performing this instruction.    (2)
5. Delete the cell in row 2 containing the marks for Afr, when prompted click on “shift cells left”. (2)

6. Draw a table and add the following information. Make sure the facilitator observes you drawing the table:  (3)

7. Type the following information and convert to a table. (2)

Mogoane       A.M

Golele           H.A

Duma T.P

Gabathole      G.S

8. Change the column width of the column containing the subjects to 1.5” (4)
9. Change the row height of the first row to 0.3” (4)
10. Set the formatting of all the cells containing marks to center. (2)
11. Change the borders around the first row to 2 ¼ pt and set as grid. (4)
12. Change the shading in the first row to light green (5)
13. Change the font colour of geography to brown and art to red. (2)
14. Change the border colour of all the lines except line 1 to sea green. (5)
15. Copy the entire table and paste it below the original table. AutoFormat the table to Table Colourful one. (2)
16. In table 2, merge cells 2-7. (2)
17. In table 2, sort the subjects alphabetically (ascending). (2)
18. In table two, insert a row at the bottom. Use the bottom right Cell and add all the marks using the formula function. (4)

19. Open the Princess document and do the following: insert two columns for the entire document. (2)
20. Start a new column in the middle of the second column on page 1. (2)
21. Balance your columns (2)
22. Start a new column in the middle of the second column on the last page. Delete the column. Call the facilitator to observe this. (2)
23. Resize the columns to make them wider. Call the facilitator to observe this. (2)
24. Insert a vertical line between the columns (2)
25. Insert a heading on the first page above the columns (2)
26. Insert a heading on the second page, inside the columns, to span both columns (2)
27. Insert a linked text box at the bottom of page 2 to flow into a linked text box on page 3. (6)

Save, and then upload the files created in the previous question