functions (excel). we can make simple countings with the excel
DESCRIPTION
SZUM függvény We can add the values of the given cells SZUM function=SUMTRANSCRIPT
FUNCTIONS(Excel)
We can make simple countings with the Excel
SZUM függvényWe can add the values of the given
cells
SZUM function=SUM
How a function looks like
1. We always start with a (=) sign! 1.
2. The name of the function
2.
3. Opening
3.
4. The name of cells separated by a double dot
the cells we would like to use
4.
5. Closing
1. Just click on the cell where we want to see the result
How to insert a function
2. I choose from the menu the function I need
How to insert a function
3. Choose the cell where we want to see the result
How to insert a function
4. Press Enter
How to insert a function
Here is the result
6. Check that if it is correctHow to insert a function
MAX függvényWe can find the highest value among
the cells
MAX function=MAXIMUM
How the MAX function looks like
1. We always start with the (=) symbol! 1.
2. The name of the function
2.
3. Opening
3.
4. The name of cells separated by a double dot
the cells we would like to use
4.
5. Closing
MIN függvényWe can find the smallest values
among the cells
MIN function=MINIMUM
How the MIN function looks like
1. We always start with the (=) symbol! 1.
2. The name of the function
2.
3. Opening
3.
4. The name of cells separated by a double dot
the cells we would like to use
4.
5. Closing
1. Select the cells we need to useHow to make graphs/charts
Diagram készítése2. Insert/Diagram
orMenu/Diagram wizzard
How to make graphs/charts
Diagram készítése3. Select the type of chart
4. More options to change the look of the chart
How to make graphs/charts
Diagram készítése
5. Push the ”more”
How to make graphs/charts
Diagram készítése6. Is it ok in this way?
7. If yes, push the ”more”
How to make graphs/charts
Diagram készítése8. Name the chart
9. Push ”more”
How to make graphs/charts
Diagram készítése10. Decide where to put the explanation part
How to make graphs/charts
Diagram készítése
If it is not ticked there will not be explanation!
11. Do I need explanations?
How to make graphs/charts
Diagram készítése12. Where to put the explanation part
13. Push ”more”
If it ticked we will have explanation!
How to make graphs/charts
Diagram készítése14. We can decide what title we want give
15. Push ”more”
Now we can see the VALUES next to our chart
How to make graphs/charts
Diagram készítése16. We select where to put our chart
Place it on a new spreadsheet
How to make graphs/charts
How to make graphs/charts17. We can select where to put our chart
18. Finish We can place it on an existing spreadsheet
How to change the look of the ready chart