Click on the formulas that have been incorrectly entered., =A1+A2, =SUM(A1:A2), =A1-A2, SUM(A1:A2), A1+A2, A1/A2, Click on the formulas that can be used to subtract one number from another., =A1-A2, =SUM(A1-A2), =A1/A2, =SUM(A1:A2), =A1*A2, =A1+A2, Click on the formulas that can be used to multiply one number by another., =A1*A2, =SUM(A1*A2), =A1/A2, =SUM(A1:A2), =A1-A2, =A1+A2, Click on the formulas that can be used to divide one number by another., =A1/A2, =SUM(A1/A2), =A1-A2, =SUM(A1:A2), =A1*A2, =A1+A2, Click on the formulas that can be used to calculate column totals., =SUM(B1:B10), =SUM(G10:G25), =B1:B10, =AVERAGE(A1:A10), =COUNT(A1:A10), =MIN(A1:A10), Click on the formulas that can be used to calculate row totals., =SUM(A1:F1), =SUM(L10:S10), =A1:F1, =AVERAGE(A1:A10), =COUNT(A1:A10), =MIN(A1:A10), Click on the formulas that can be used to calculate totals., =SUM(A1:F20), =SUM(H10+H11), =A1:F1, =AVERAGE(A1:A10), =COUNT(A1:A10), =MIN(A1:A10), Click on the missing parts of this formula... SUMB25:D25, =, ", (, ), /, *, Click on the mathematical operators for multiply and divide, *, /, %, £, +, -.
0%
Microsoft Excel Level 4 Basic Formulas
Kongsikan
Kongsikan
Kongsikan
oleh
Alexcampbellx
Edit Kandungan
Cetakan
Benamkan
Lebih lagi
Tugasan
Papan mata
Paparkan banyak
Paparkan sedikit
Papan mata ini berciri peribadi pada masa ini. Klik
Kongsikan
untuk menjadikannya umum.
Papan mata ini telah dilumpuhkan oleh pemilik sumber.
Papan mata ini dinyahdayakan kerana pilihan anda berbeza daripada pemilik sumber.
Pilihan untuk Kembali
Kuiz
ialah templat terbuka. Ia tidak menjana skor untuk papan mata.
Log masuk diperlukan
Gaya visual
Fon
Langganan diperlukan
Pilihan
Tukar templat
Paparkan semua
Lebih banyak format akan muncul semasa anda memainkan aktiviti.
)
Buka keputusan
Salin pautan
Kod QR
Padam
Pulihkan autosimpan:
?