1) Click on the formulas that have been incorrectly entered. a) =A1+A2 b) =SUM(A1:A2) c) =A1-A2 d) SUM(A1:A2) e) A1+A2 f) A1/A2 2) Click on the formulas that can be used to subtract one number from another. a) =A1-A2 b) =SUM(A1-A2) c) =A1/A2 d) =SUM(A1:A2) e) =A1*A2 f) =A1+A2 3) Click on the formulas that can be used to multiply one number by another. a) =A1*A2 b) =SUM(A1*A2) c) =A1/A2 d) =SUM(A1:A2) e) =A1-A2 f) =A1+A2 4) Click on the formulas that can be used to divide one number by another. a) =A1/A2 b) =SUM(A1/A2) c) =A1-A2 d) =SUM(A1:A2) e) =A1*A2 f) =A1+A2 5) Click on the formulas that can be used to calculate column totals. a) =SUM(B1:B10) b) =SUM(G10:G25) c) =B1:B10 d) =AVERAGE(A1:A10) e) =COUNT(A1:A10) f) =MIN(A1:A10) 6) Click on the formulas that can be used to calculate row totals. a) =SUM(A1:F1) b) =SUM(L10:S10) c) =A1:F1 d) =AVERAGE(A1:A10) e) =COUNT(A1:A10) f) =MIN(A1:A10) 7) Click on the formulas that can be used to calculate range totals. a) =SUM(A1:F20) b) =SUM(H10:S60) c) =A1:F1 d) =AVERAGE(A1:A10) e) =COUNT(A1:A10) f) =MIN(A1:A10) 8) Click on the formulas that can be used to calculate non-adjacent cell totals. a) =SUM(B2,J9,W15) b) =SUM(K50,T75, Z100) c) =A1:F1 d) =AVERAGE(A1:A10) e) =COUNT(A1:A10) f) =MIN(A1:A10)

Microsoft Excel Level 4 Basic Formulas

הדפסה
הטבעה

לוח תוצאות מובילות

סגנון חזותי

אפשרויות

החלף תבנית

האם לשחזר את הנתונים שנשמרו באופן אוטומטי: ?