Spreadsheets

?
  • Created by: Matthew__
  • Created on: 16-11-17 11:16
What are features of a spreadsheet?
• They perform calculations and recalculations automatically
1 of 10
State for data types.
Auto-number/text/number/currency
2 of 10
State 2 fuctions and explain them.
Max:The MAX function finds the largest value stored in a group of cells. MIN:The MIN function finds the smallest value stored in a group of cells.
3 of 10
List different functions
MAX/MIN/AVERAGE/SUM/COUNT/IF
4 of 10
What is absolute cell reference?
It is a cell address that contains a dollar sign in the row or column coordinate, or both. When you enter a cell refernce in a formula, excel assumes it is a relative refernce unless you change it to an absolute refernce
5 of 10
Define Data Validation
Data validation makes it possible to control the values input into a given cell.
6 of 10
What are Macros
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.
7 of 10
Give 2 examples of Macros
• Producing a graph from a table of data
8 of 10
Explain the function of COUNT.
The COUNT function will calculate the number of entries there are, e.g. the number of cells that contain data
9 of 10
How is a macro created in a spreadsheet
1. Use the record new macro function to carry out a task like the examples listed on last page.
10 of 10

Other cards in this set

Card 2

Front

State for data types.

Back

Auto-number/text/number/currency

Card 3

Front

State 2 fuctions and explain them.

Back

Preview of the front of card 3

Card 4

Front

List different functions

Back

Preview of the front of card 4

Card 5

Front

What is absolute cell reference?

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Spreadsheets resources »