• They perform calculations and recalculations automatically, • They allow results to be displayed in tabular or graphical format, • They consist of a table divided into rows and columns to produce cells, They consist of a number of worksheets
1 of 15
List the different data types:
General, currency, number, date, time, percentage etc.
2 of 15
List the different functions:
SUM, MIN, MAX, AVERAGE, COUNT, IF
3 of 15
What is the MIN function?
The MIN function finds the smallest value stored in a group of cells
4 of 15
What is the MAX function?
The MAX function finds the largest value stored in a group of cells
5 of 15
What is the COUNT function?
The COUNT function will count the number of enteries in the table
6 of 15
What is the SUM function?
The SUM function calculates the total of a group of selected cell values
7 of 15
What is the AVERAGE function?
The AVERAGE function calculates the average of a group of selected cell values
8 of 15
What is the formulae for addition?
+
9 of 15
What is the formulae for subtraction?
-
10 of 15
What is the formulae for multiplication?
*
11 of 15
What is the formulae for division?
/
12 of 15
What is absolute cell referencing?
If you don’t want the cell reference to change when you copy a formula, you can make it an absolute cell reference. Eg $I$5 always refers to cell I5 and a formula containing $I$5 keeps the $I$5 even if copied down a column or across a row
13 of 15
What is data validation?
Data validation makes it possible to control the values input into a given cell. For example the number here represents an assignment mark out of 25
14 of 15
What is a Macro?
A macro is a way to automate a task or procedure which you perform on a regular basis. A macro is a set of instructions and/or actions that can be recorded or saved and then set to run whenever you need to perform the task in the future
15 of 15
Other cards in this set
Card 2
Front
List the different data types:
Back
General, currency, number, date, time, percentage etc.
Comments
No comments have yet been made