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, *, /, %, £, +, -.

Microsoft Excel Level 4 Basic Formulas

oleh
Cetak
Menyematkan

Papan Peringkat

Gaya visual

Pilihan

Berganti templat

)
Pulihkan simpan otomatis: ?