Spreadsheets Flashcards
(18 cards)
What is a Worksheet?
A page within a spreadsheet
What is a Workbook?
Multiple worksheets in a spreadsheet
What is a Cell?
An individual box within a spreadsheet
What is an Active cell?
The cell you are currently click on or have selected
What is a Formula?
Starts with = and is used to complete calculations
What is a Value?
Text or number that is represented
What is a Column?
A vertical line of cells in a spreadsheet. Labelled with the column headers A, B, C, D, E etc.
What is a Row?
The horizontal lines in a spreadsheet. Labelled with the row headers 1, 2, 3, 4, etc
What does the SUM function do?
The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.
For example: =SUM(A2:A10)
What is Addition?
Adding numbers together using +
What is Multiplication?
Times numbers using *
What is Subtraction?
Take away/ minus numbers using -
What is Division?
Dividing numbers using /
What is the Use of Spreadsheets?
Spreadsheets can be used by accountants and within businesses to create budgets, produce graphs and charts, and for storing and sorting data
Replicate content
In the active cell, use the small square at the bottom right hand corner, to replicate/copy your data or formula into other cells.
What does VLOOKUP do?
Looks at the value in a certain cell, checks it against a vertical list in a table and returns the value from another column on the same row to display it to the user.
What does COUNTIF do?
A COUNTIF statement will check against a given criteria to see if it matches and return a statement to show whether it does or not.
