Spreadsheets Skills
The following are the Basic Skills for statistics on Excel. These Basic Skills need to be continually revised and tested.
BASIC SPREADSHEET SKILLS
By using the tutorial on this website you will learn how to:
- enter data into a spreadsheet
- describe cell ranges in the spreadsheet in the form A1:A5 etc
- write mathematical formulas as spreadsheet formulas and vice versa
- enter formulas into a spreadsheet
- adjust column width
General
- highlight groups of cells
- insert columns and rows
Patterns
- write formulas using arithmetic operations
- use formulas for sum and
- copy down formulas and numbers
- generate patterns (sequences) using formulas
- generate arithmetic patterns using shortcut methods
Format
- borders and shading
- numbers
- fonts
- alignment within and across cells
- cell size
Graphs
- use chartwizard to draw and label
- column graphs
- pie graphs
- line graphs
- XY (Scatter) graphs
- change shape, size and position of a graph on your worksheet
- use the chart toolbar to make changes to a graph
- use the chart toolbar to add data to a graph
- use shortcut methods to add data to a graph
- edit the attributes of your graph.
