PRA PTS-1 - INFORMATIKA 7

• =SUM(D4+E4)

• =SUM(E3+F3)

• =COUNT(F2:G2)

• =COUNT(G1+H1)

• =AVERAGE(D4:E4)

• =AVERAGE(D4+E4)

• =MAX(D4:E4)

• =MAX(D4+E4)

• =SUM(D4:D6)

• =SUM(D4+D6)

• =COUNT(D4:D6)

• =COUNT(D4+D6)

• =COUNT(C4+D4+E4+2*F4)/5

• =AVERAGE(C4+D4+E4+2*F4)/5

• =SUM(C4+D4+E4+(2*F4))/5

• =COUNTA(C4+D4+E4+(2*F4))/5

• =COUNT(B4:B6)

• =COUNTA(B4:B6)

• =SUM(B4:B6)

• =AVERAGE(B4:B6)

• =COUNT(G4:G6)

• =SUM(G4:G6)

• =MAX(G4:G6)

• =MIN(G4:G6)

• =AVERAGE(G4:G6)

• =SUM(G4:G6)

• =MAX(G4:G6)

• =MIN(G4:G6)

• =AVERAGE(G4:G6)

• =SUM(G4:G6)

• =MAX(G4:G6)

• =MIN(G4:G6)

Mengisi RUMUS-1 adalah

• =SUM(C5:D5)

• =SUM(C5*D5)

• =COUNT(C5:D5)

• =COUNT(C5*D5)

Mengisi RUMUS-2 adalah

• =SUM(10%XE5))

• =SUM(10%*E5)

• =COUNT(10%XE5)

• =COUNT(10%*E5)