Tip sheets | Glossary | Home | Contents |
Description |
Resources |
|
1 | Start Microsoft Excel | How to start Microsoft Excel |
2 | Type in the headings and learners' names | |
3 | Sort the names alphabetically: You can enter names in any order, and Excel can sort them for you. | How to sort a list |
4 | Resize the column widths: This will allow cells to accommodate long names | How to resize column widths |
5 | Save the mark sheet: Remember to save your marksheet regularly | How to save a file |
6 | Type the learners' marks: Each mark should be in its own cell. | |
7 | Calculate the total for each learner | How to use the SUM function |
8 | Calculate the test average | How to use the AVERAGE function |
9 | Calculate each learners' percentage | How to use a formula |
10 | Insert borders around the information: You can print the marksheet with gridlines, making it easy to read. | How to insert borders |
11 | Format the text: Change the appearance of cells containing formulas to highlight them. You can also colour cells. | How to format cells |
12 | Save the mark sheet | How to save the marksheet |
13 | Preview the print version | How to use print preview |
14 | Close Microsoft Excel | How to close Microsoft Excel |
Related scenarios |
||