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 12
What types of data is there?
General, Number, Currency, Accounting, Data, Time and Percentage etc.
2 of 12
List the differeny functions?
MIN, MAX, AVERAGE, COUNT, SUM and IF
3 of 12
What does a formula look like for +?
=A1+B2
4 of 12
What does the formala look like for -?
=A1-B2
5 of 12
What does the formula look like for multiplying?
=A1*B2
6 of 12
What does the formula for dividing look like?
=A1/B2
7 of 12
What does an absolute cell reference look like?
=$A$1
8 of 12
What is meant by 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. In the data validation settings dialogue, you can define the data type (whole number) and range chec
9 of 12
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. A macro is
10 of 12
What does the COUNT function do?
The count function will count the number of entries there are e.g. how many cells contain data in them.
11 of 12
What does the IF function do?
The IF function sets the cell value depending on the result of examining a condition. IF condition is true THEN value 1 ELSE value 2.
12 of 12
Other cards in this set
Card 2
Front
What types of data is there?
Back
General, Number, Currency, Accounting, Data, Time and Percentage etc.
Comments
No comments have yet been made