ict help guide: lesson 2 using basic functions...ict help guide: lesson 2 using basic functions a...
TRANSCRIPT
![Page 1: ICT Help Guide: Lesson 2 Using Basic Functions...ICT Help Guide: Lesson 2 Using Basic Functions A function is a pre programmed set of instructions that will automatically calculate](https://reader036.vdocuments.us/reader036/viewer/2022062603/5f515b90e5f918157102d2f1/html5/thumbnails/1.jpg)
ICT Help Guide: Lesson 2
Using Basic Functions
![Page 2: ICT Help Guide: Lesson 2 Using Basic Functions...ICT Help Guide: Lesson 2 Using Basic Functions A function is a pre programmed set of instructions that will automatically calculate](https://reader036.vdocuments.us/reader036/viewer/2022062603/5f515b90e5f918157102d2f1/html5/thumbnails/2.jpg)
A function is a pre programmed set of instructions that will automatically calculate or solve a problem when a specific formula is input into the spreadsheet
What is a function?
SUM Min Max Average
Some Key Functions:
Finds the MEAN value of a specific cell range
Identifies the LARGEST data value in a data set
Identifies the SMALLEST data value in a data set
Calculates the total some of specific cell
![Page 3: ICT Help Guide: Lesson 2 Using Basic Functions...ICT Help Guide: Lesson 2 Using Basic Functions A function is a pre programmed set of instructions that will automatically calculate](https://reader036.vdocuments.us/reader036/viewer/2022062603/5f515b90e5f918157102d2f1/html5/thumbnails/3.jpg)
How to use AutoSum: Method 1AutoSum is an automatic function that adds up multiple cells together
Step 1: Highlight all the numbers you want to add up
Step 2: Click on the AutoSum button
![Page 4: ICT Help Guide: Lesson 2 Using Basic Functions...ICT Help Guide: Lesson 2 Using Basic Functions A function is a pre programmed set of instructions that will automatically calculate](https://reader036.vdocuments.us/reader036/viewer/2022062603/5f515b90e5f918157102d2f1/html5/thumbnails/4.jpg)
How to use AutoSum: Method 2AutoSum is an automatic function that adds up multiple cells together
Step 1: type in the cell you wish to put your answer =SUM and double click on the word
SUM
Step 2: Highlight ALL the cells you wish to add together and press enter
![Page 5: ICT Help Guide: Lesson 2 Using Basic Functions...ICT Help Guide: Lesson 2 Using Basic Functions A function is a pre programmed set of instructions that will automatically calculate](https://reader036.vdocuments.us/reader036/viewer/2022062603/5f515b90e5f918157102d2f1/html5/thumbnails/5.jpg)
Min functionStep 1: type in the cell you wish to put your
answer =Min and double click on the word MinStep 2: Highlight ALL the cells you wish to include in
your search and press enter
Identifies the SMALLEST data value in a data set
![Page 6: ICT Help Guide: Lesson 2 Using Basic Functions...ICT Help Guide: Lesson 2 Using Basic Functions A function is a pre programmed set of instructions that will automatically calculate](https://reader036.vdocuments.us/reader036/viewer/2022062603/5f515b90e5f918157102d2f1/html5/thumbnails/6.jpg)
Max functionStep 1: type in the cell you wish to put your
answer =Max and double click on the word MaxStep 2: Highlight ALL the cells you wish to include in
your search and press enter
Identifies the LARGEST data value in a data set
![Page 7: ICT Help Guide: Lesson 2 Using Basic Functions...ICT Help Guide: Lesson 2 Using Basic Functions A function is a pre programmed set of instructions that will automatically calculate](https://reader036.vdocuments.us/reader036/viewer/2022062603/5f515b90e5f918157102d2f1/html5/thumbnails/7.jpg)
Average functionStep 1: type in the cell you wish to put your
answer =Average and double click on the word average
Step 2: Highlight ALL the cells you wish to find the average of
Finds the MEAN value of a specific cell range