Lesson 2
- create advanced arithmetic formulae based on given tasks/activities
- use the appropriate functions such as to achieve given result
- distinguish between relative and absolute cell addressing
- replicate formulae into other cells using absolute and relative cell address appropriately.
- manipulate data ,columns and rows
- format spreadsheet using appropriate numeric data, texting, alignment and borders formatting.
- Explain the importance of primary and secondary fields when sorting records in spreadsheet
- List the steps to sort records in spreadsheet based on given conditions
- Sort spreadsheets correctly
- Invoke row and column title locking
- create appropriate charts (bar, line, pie) to reflect given data.
excelworkshop-0408-vlookup.xls |