What does importing data mean
Allows data produced in another application, to be used in a spreadsheet
What can improve presentation
Headers and footers
Outline the functions
SUM function of cells
AVERAGE functions of cells
MAX functions of cells
MIN function of cells
What is a function
Part of the software application that performs a specific task
How is a IF statement used
Statement examines a condition, resulting in one of two actions being carried out
How is a vlookup used
Function uses the value inna selected cell to lookup a match in a column of a lookup table
What is a relative cell reference
Changes a formulas cell reference to refer to the next cells when the formula is copied down a column or across a row
What is absolute cell reference
When a formula is copied to other cells, part of the cell reference does not change as the formula is modified(pounds to euros, exchange rate is same for each calculation)
What is a macro
A small program written to preform a repetitive task automatically
What is data modelling
Uses mathematical formulas and calculations on data to help predict outcomes for given situations
