Basics Every formula starts with an ____ The little boxes in a spreadsheet are called ____ . A cell reference is made up of the ____ and the ____ . Charts There are several types of charts. When creating charts you need to choose a chart type based on the type of ____that is to be displayed. The charts you can choose from include: ____ – to show a change over time ____ chart – shows the individual parts that make up a whole (%) ____ chart - compare things that aren’t directly related There are a number of symbols used in formulas or calculations. These are the most common ones: ‘+’ ____ ____ subtract (take away) ‘*’ ____ ‘/’ ____ Functions make more complex calculations: ____ - adds up values in selected cells MIN – finds the ____ value ____ – finds the largest value AVERAGE – finds the average ____ COUNT – counts how many of the selected ____ have ____ in them

Spreadsheet skills

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?