ICT Learners

Module 03 | Prepare Spreadsheets

Lecture Notes

• Task 01 (C01) - Format worksheet

- The created worksheet should have a name which is relevant to the contents and saved in the location according to the given instructions.

- The page setup should match the requirements of the draft.

- Worksheet should be formatted as per the requirement.

- Data in the work sheet should be valid according to the original document.

• Task 02 (C02) - Apply built-in functions and formulas

- Formulae should be generated by using cell referencing and arithmetic operators as per the instructions given.

- Table created should be formatted to match the dataset. (column width, row height).

- Appropriate functions and user defined formulas should be selected to suit the required operations.

- Cell border, width, style, color modified, shading added to the cells as required.

- The output should be validated for accuracy.

• Task 03 (C03) - Fill, Sort, and Filter data

- The work sheet should be filled with data as per the requirement.

- A cell range should be sorted and filtered according to the given criterion.

- The sorted and filtered results should be validated for accuracy.

• Task 04 (C04) - Prepare graphs and charts

- The data range and both axis should be selected to represent the whole set of data in the chart.

- The chart type should be selected according to the nature of the data and the requirement.

- The chart should be formatted to represent all information in the data set with titles and labels.

• Task 05 (C05) - Use data tools

- The duplicated data values should be removed as expected.

- The data should be valid according to the given instructions.

- It should be ensured that what-if analysis is accurate.

- The linked data sources should be accessible within the worksheet.

• Task 06 (C06) - Create a pivot table

- The data set should be selected according to the pivot table requirement.

- The data should be analyzed according to the given instructions.

• Task 07 (C07) - Develop and customize the workshee

- Worksheet settings should be applied as per the requirement.

- Rows and columns should be freeze or unfreeze according to the requirement.

• Task 08 (C08) - Set page properties and print spreadsheet

- Header and footer / page margins / breaks should be arranged according to the given instructions.

- Print area and scaling should be selected according to the printer connected.