Page 31 - Knowledge Organiser Yr7 24-25

3. Symbols in spreadsheet
=
All formulas start with an equals.
+
This symbol is used to add numbers together.
-
This symbol is used to takeaway numbers.
*
This symbol is used to multiply numbers together.
/
This symbol is used to divide numbers.
1. Introduction to Spreadsheets
1.1 spreadsheets 1.2
1.3 formula 1.4
1.5 1.6 1.7
2.1
2.2 SUM
2.3 MIN
2.4 MAX
2.5 AVERAGE
Are used to store information and data. 3.1 3.2
uses of spreadsheets
• Budget tracker Stock tracking of a business Money use in a business Teacher may use it to keep a record
of pupils’ grades.
Formulas are used to work out calculations.
3.3 3.4 3.5
4. Key words
worksheet A collection of cells organized in rows and columns.
cell A box in which you can enter a single piece of data.
sort The arrangement of data into a specific sequence. E.g. A-Z, smallest to largest.
active cell
When you click on a cell to choose it, it becomes the active cell and has a thick black line around it.
row
The grid has rows labelled with numbers. A row goes across the grid.
columns
The grid is made up of columns that are labelled with letters. A column goes down the grid.
values
Values are the numbers we have to put into a spreadsheet so that it can do calculations for us.
ascending
Arranged in a series that begins with the least or smallest and ends with the greatest or largest.
descending
Arranged in a series that begins with the greatest or largest and ends with the least or smallest.
labels
Labels are pieces of text that we add to the spreadsheet to give us information about the numbers.
2. Functions in Spreadsheets
function
When you add a word to a formula (e.g. SUM) then it becomes a function. Each function performs a specific task.
Adds up a range of selected cells.
Finds the minimum value of selected cells.
Finds the maximum value of selected cells.
Finds the average of selected cells.
formatting To change the appearance, layout or organisation of a spreadsheet.
graphs and charts
A visual representation of data from a worksheet that can bring more understanding to the data than just looking at the numbers.
31
Knowledge Base: Computing Spreadsheets Year 7 | Term 3