FORMULA, Every single one of these must start with an equals sign ($=$). It tells the spreadsheet to do some math., CELL, The individual box where a row and a column meet. It's where you type your data., ROW, This runs horizontally (left to right) across your sheet and is always identified by a number., COLUMN, This runs vertically (up and down) and is always identified by a letter., SUM, This function adds up all the numbers and divides by how many there are to find the mean., MAX, The function used to find the biggest or highest value in a dataset., MIN, The function used to find the smallest or lowest value in a dataset., MODEL, A spreadsheet setup that mimics a real-world situation, like managing a budget for a school trip, to see what might happen in the future., FORECAST, To predict future trends or numbers based on the data you currently have., CURRENCY, The formatting style you apply to a number to instantly turn it into money, adding a pound sign (£) and two decimal places., MERGE, To combine two or more cells together to make one big cell, usually used for the main title of your spreadsheet., SORT, To organise your data into a specific order, like putting a list of names into alphabetical order (A to Z) or test scores from highest to lowest., ERROR, What the spreadsheet displays when a formula breaks or is written incorrectly (for example: #DIV/0! or #VALUE!)., RANGE, A collection or block of selected cells next to each other (for example: A1:B10)., GRIDLINES, The light grey lines that outline the cells on your screen so you can see the borders. You can turn them on or off.

L3 - Spreadsheet Modelling

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?