Spreadsheet Flashcards
What is merge and centre
Merges cells together and puts text in the centre
What is conditional formatting
Setting formatting in a cell to change based on the value in the cell
What is data type
Setting values in the cell to set data type
What is validation
Setting cells to only expect certain values
What is a temples
Creating a set layout for others to use and amend for example account documents in business
What is the sum function
Add all cells in a cell range
What is the max function
Finds the highest value in a given cell range
What is the min function
Finds the lowest value in a given cell range
What is the average function
Calculates the mean of values in a set range
What is the if function
If uses a logical operator to check if the cell in question meets a set criteria and the outputs a value if the condition is met or a different value if it is not met.
What is the Vlookup function
Vlookup look up a value in a table and outputs value
from another column in the same table. It is made up of
How to write a Vlookup function
=Vlookup(the lookup cell, the range for the table to search in, the column to display, True (exact match) or false (approximate match))
What is a macro
Small automated programs that perform repetitive tasks. In spreadsheets these are mainly used with buttons to move sheets or print
What is absolute cell referencing
When you use the fill handle to replicate the formula the cell references will automatically update to match the row/column this is called relative cell referencing.