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
