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 works
1 of 11
List the different data types
General, Number, Currency, Date, TIme, Percentage
2 of 11
List the different Functions
MAX, MIN, AVERAGE, COUNT, SUM, IF
3 of 11
What is the IF function?
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.
4 of 11
What are the MAX and MIN functions?
The MAX and MIN functions find the largest or the smallest value stored in a group of cells.
5 of 11
What is the SUM function?
The SUM function calculates the total of a group of selected cell values.
6 of 11
What is the AVERAGE function?
The AVERAGE function calculates the average of a group of selected cell values.
7 of 11
What is the COUNT function?
The COUNT function will count the number of cells containing data out of selected cell values.
8 of 11
What is Absolute Cell Reference?
The absolute cell reference is a cell address that contains a $ sign in the row or column coordinate, or both. It tells excel that the Cell Reference is not a relative reference, but an absolute reference.
9 of 11
Why is testing a spreadsheet important?
It is important to test a spreadsheet so you can find and remove any errors in the spreadsheet, and to test that when you enter a new value the calculations related to it will adjust automatically.
10 of 11
What steps can be taken to ensure results produced are accurate?
You can Manually calculate answers with a calculator to check your answers are correct, and enter new values to ensure the spreadsheet will calculate new answers using these values
Comments
No comments have yet been made