Y7 Spring Term - Spreagsheet & Flowol Flashcards
What are the coordinates of a cell in Excel/Spreadsheet called?
The cell reference.
What is a “row” in a spreadsheet?
The horizontal range of cells. Rows have numbers.
What is the vertical range of cells called in a spreadsheet.
A column.
Define a “cell” in spreadsheet.
A rectangular box that can contain any value.
What is a “sheet” in a spreadsheet?
A single page in a spreadsheet.
What is a “workbook” in a spreadsheet?
A collection of sheets.
Define a “formula” in a spreadsheet.
A mathematical operation performed on values in the spreadsheet.
What is the “tab” in a spreadsheet?
The button which changes which sheet is being viewed.
Explain what “formatting” is in a spreadsheet.
Formatting is the appearance of the cell.
What is “conditional formatting”?
Changing the format of the cell based on a condition.
What is an “If statement”?
A function that sees if a condition is met.
What is the copying of data in a cell to another called?
Cell replication.
What is “validation”?
When the computer checks if the data input is allowed.
What is the “Absolute Cell Reference”?
Makes the cell static/unable to change, even when copying a formula.
What does a colon do in a spreadsheet
Defines a range of cells. E.g. A2:D5
What is a static and dynamic cell?
Static cell: cell’s value has to be changed manually.
Dynamic cell: cell value changes automatically based on contents from another cell.
What does =IF do?
Creates an If Statement.
What is an algorithm in Flowol?
A list of step-by-step instructions to solve a problem.
What is a Flowchart in Flowol?
A visual representation of the steps in an algorithm.
What is the Terminator symbol in Flowol?
Starts and stops an algorithm.
What is the Decision Box in Flowol?
The diamond shape used to show a decision. Usually a yes or no.
What is a Mimic in Flowol?
The interactive image used in Flowol alongside the Flowchart.
Define a subroutine in Flowol.
A set of instructions made to perform another operation within an operation.
