Jumat, 21 Juni 2019
Rabu, 21 Februari 2018
FORMULA MICROSOFT OFFICE EXCEL
OK tuir mai ita kontinua deit ho formula excel.
1. Ita hahu ho formula : TOTAL, RATA RATA, MAXIMAL NO MINIMAL
exmplu hanesan imagen iha karaik ho nia exempu:
| Nee ita usa formula sum,average,max,min |
= SUM ( blok husi C2 ba to C7 )
=AVERAGE (SUM ( blok husi C2 ba to C7 )
=MAX (SUM ( blok husi C2 ba to C7 )
= MIN SUM ( blok husi C2 ba to C7 )
2. Formula IF
Exemplu
=COUNTIF(C44:C49,"F") konta total F
=COUNTIF(C44:C49,"F") konta total M
No
|
Nama Siswa
|
Jenis kelamin
|
1
|
Filomenu M.Soares
|
M
|
2
|
Lilita Dos Santos
|
F
|
3
|
Lucas de Jesus
|
M
|
4
|
Letino R.B Lopes
|
M
|
5
|
Mariano Pacheco da
Costa
|
M
|
6
|
Paulina dos Santos
|
F
|
TOTAL F
|
2
|
|
TOTAL M
|
4
|
|
4. Formula : LEFT, MID, RIGHT, LOWER, UPPER, LEN
Senin, 05 Februari 2018
IMAGEN NO ANIMASAUN BO'OK A'AN IHA POWER POINT
"SEMOGA ITA BOOT SIRA BELE UTILIZA"
KARIK IHA KRITIKA OU SUGESTAUN BELE KOMEN IHA KARAIK.
No. +670 77177601
facebook : https://www.facebook.com/leto.magno.31 ou Furak demais
email : estevaoaraujo020@gmail.com
Langganan:
Komentar (Atom)
FORMULA MICROSOFT OFFICE EXCEL,
-
O K tuir mai ita kontinua deit ho formula excel. 1. Ita hahu ho formula : TOTAL, RATA RATA, MAXIMAL NO MINIMAL ... -
Espesialmente atu loke aplikasaun ka programa ruma iha windows, sempre liu husi instrusaun neebe iha kedas ona aplikasaun nee rasik. K... -
KONHESEMENTU KOMPUTADOR SAIDA MAK KOMPUTADOR? Naran komputador tuir lolos mai husi lian latin COMPUTARE ne'ebe signifi...