Computer Studies·Spreadsheets · NSSCO 3.1.2
Spreadsheets: formatting, functions, referencing & charts
Narrated lesson · press play
A spreadsheet turns a plain grid of boxes into a powerful calculator. In this lesson we build a Grade 10 mark sheet and a tuck-shop stock list, and let the computer add up, decide, look up and draw charts for us using functions like SUM, AVERAGE, IF and VLOOKUP.
What you'll learn in this lesson
By the end you should be able to (NSSCO Computer Studies 3.1.2):
- Customise a spreadsheet window; insert/remove toolbars in spreadsheets; create and save new spreadsheet workbook
- Apply formatting in spreadsheets: align data in cells, rotate text, wrap text, shrink to fit, merge cells, apply a background colour (shading) to a cell
- Shift between different views in spreadsheets; freeze panes in spreadsheets
- Use printing options in spreadsheets: print entire workbook, print selected pages, print a worksheet, print only a selected part of a worksheet, scale the worksheet before printing, select a print area, print labels (title rows) on every page, print worksheet in draft quality
- Use functions in spreadsheets: statistical functions such as SUM, AVERAGE, MAX, MIN, COUNT; logical functions such as the IF function; Date functions such as TODAY() and YEAR(); VLOOKUP; HLOOKUP; CONCATENATE; ROUND, ROUNDUP and ROUNDDOWN
- Paste a link, including advanced Paste Special features
- Use absolute and relative referencing in spreadsheets
- Apply sorting and filtering functions in spreadsheets
- Create different types of charts in spreadsheets: bar, pie, column, line
Loading your lesson…
You're watching a free 3-minute preview — create a free account to keep going.
Quick revision
Revise this in 5 minutes
Miss Maria and Mike talk through the whole topic — with the figure and working drawn live.