Chapter 4 - Spreadsheet Applications Flashcards
What is a spreadsheet workbook?
A workbook contains sheets
What is a worksheet?
A page in a spreadsheet that looks like a grid
What is a spreadsheet?
Software designed to perform calculations and recalculations automatically
What is a cell?
a rectangle in a worksheet grid
What is a range of cells?
When a group of cells on a spreadsheet are selected together
What is a cell reference?
The address of a cell on a worksheet, given as a letter and number, e.g. A4
The letter represents the column and the number represents the row
What data types can be applied to cells?
Number
Currency
Date/time
Text
What is validation?
Rules applied to ensure an entered value is reasonable
What is a template?
A document that has a preformatted layout and can be copied to make new documents
What is a wizard?
A software tool that helps a user complete a complex process by guiding them through the process step-by-step
What does a formula always start with?
=
What are the 4 parts of a function?
=function_name(?)
- =
- function name
- brackets
- something inside the brackets (changes depending on the function)
e.g.
=if(condition, value if true, value if false)
What is the =sum() function used for?
Adding a range of cells
What is the =average() function used for?
Finding the average of a range of cells
What is the =min() function used for?
Finding the smallest value in a range of cells
What is the =max() function used for?
Finding the largest value in a range of cells
What is the =if() function used for?
Deciding on a value based on a condition
What is the =vlookup() function used for?
The vertical lookup function looks up a value in a table and returns information based on that value.
What is a relative cell reference?
When a formula is replicated (copied) down or across, the values will change to be relative to the cell it has been copied into
What is an absolute cell reference?
When a formula is replicated (copied) down or across, any cell reference in the formula that has a $ in front of it will not change relative to the new cell, but will remain the same.
What is a macro?
A small program written to carry out a repetitive task
What types of chart are available in a spreadsheet?
Bar/column chart
Pie chart
What is data modelling?
A model that is controlled by a set of rules defined by formulas
Allows ‘what if?’ questions to be answered
