Yr 7 - Spreadsheet / KEQ

In a spreadsheet is a group of cells located horizontally on the worksheet, they are represented by numbers

 In a spreadsheet is a group of cells located vertically on the worksheet, they are represented by letters

• Row
• Cell
• Column
• Sheet

Is a place in the spreadsheet, which is a small box, where values can be entered

Is a specific location in the spreadsheet, it is a name of an individual cell, such as B5

• Spreadsheet label
• Cell reference
• Cell address
• Data point

Where colours, fonts and borders are used to make the spreadsheet look more professional

• Sorting data in ascending order.
• Formatting the spreadsheet with colors, fonts, and borders.
• Using formulas to calculate values.
• Inserting images into the spreadsheet.

They calculate values in a spreadsheet, they always start with equals. E.g =A1+A2, this would add the values in the two cells

These are preset formulas, which are used to calculate certain values in the cells

• Constants
• Functions
• Parameters
• Variables

A function used to add up the total of all values

• calculate
• totalize
• sum
• aggregate

A function used to find the lowest value

• max
• average
• sum
• min

A function used to find the highest value

• min
• average
• sum
• max