home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip 2004 September
/
Chip_2004-09_cd1.bin
/
chplus
/
excelent
/
dil_4
/
obrazky
/
psoucty1.png
< prev
next >
Portable Network Graphic
|
2004-02-16
|
9KB
|
539x585
|
4-bit (12 colors)
Labels:
earth
|
fence
|
grandstand
|
person
|
poster
|
road
|
rock
|
shelf
|
sky
|
stairs
|
tree
|
window
|
windowpane
OCR:
Pocet Jmeno Sber kilogramu Toma: briza Milena [kontryhel Tomas brizs briza 10 Petra alergie 11 Marie 12 LuCEK 13 14 =MAX(C4:C12) Maximum nasbiranych kilogramu sberu 15 =MIN(C4:C12) Minimum nasbiranych kilogramu sberu Soucet kilogramd nasbiranych Tomasem 1F 18 =SUMA((A4:A1 12= Tomas" *C4:C12) (maticovy vzorec) 18 =SUMIF (4:12 Tomas C4:C12) Totez vyuzitim funkce SUMIF Soucet kilogr amd brizy nasbir anvch 18 15 =SUMA((A4:A12=TomaS")*(B4:B12="bRiza")*C4:C12) Tomasem (maticovy vzorec) Soucet kilogramu brizy celkem (maticovy 19 =SUMA(B4:B12="bfiza)*C4:C12) vzorec Nejcastejsi pocet kilogramd 20 =MODE(C4:C12) odevzdaneho sheru Pocet zaku kteri nasbirali alespon =SUMA((B4:B12="kopfivy )*(C4:C1 2>=4 kopriy (maticovy vzorec) Pocet zaku kteri prinesli od 3 do 7 kg =COUNTIF(C4:C1 2>=3) -COUNTIF(C4:C1 2 ...
