Every formula starts with an ____ . The little boxes in a spreadsheet are called ____ . A cell reference is made up of the ____ and the ____ . There are several types of charts. When creating a chart you need to choose a chart type based on the type of ____ that needs 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 - to 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) ‘*’ ____ ‘/’ ____ Basic Functions Functions make more complex calculations: ____ - adds up values in selected cells MIN – finds ____ value ____ – finds largest value AVERAGE – finds the average ____ COUNT – counts how many of the selected ____ have ____ in them. More functions When analysing raw data there are other functions we can use: The ____ function is used to count the number of cells in a range that are not empty. The ____ function counts the number of cells that meet a criterion. If you needed to count on more than one range of data at the same time then the ____ function would be used. The ____ function is used to add up cell values based on a certain condition. Pivot tables Pivot tables can be used to ____ raw data quickly. They are particularly useful for spotting ____ and trends in the ____. Pivot tables are used to create data ____ which allow users to see an overview of analysed data in a ____ format making the data easier to ____

Spreadsheet skills HA

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?