1) How would you calculate the total of values in cells A1 to A5 in Excel? a) =SUM(A1+A5) b) =TOTAL(A1:A5) c) =A1+A2+A3+A4+A5 d) =SUM(A1:A5) 2) Which function would you use to find the average of values in cells A1 to A10 in Excel? a) =AVERAGE(A1-A10) b) =MEAN(A1:A10) c) =TOTAL(A1:A10) d) =AVERAGE(A1:A10) 3) If cell A1 contains the value 10 and cell A2 contains the value 5, what is the result of the formula =A1 - A2 in Excel? a) 10 b) -5 c) 15 d) 5 4) How would you multiply the values in cells A1 and A2 in Excel? a) =A1 * A2 b) =MULTIPLY(A1:A2) c) =PRODUCT(A1, A2) d) =SUM(A1:A2) 5) What function would you use to find the maximum value in cells A1 to A10 in Excel? a) =MAX(A1:A10) b) =LARGEST(A1:A10) c) =MAXIMUM(A1:A10) d) =HIGHEST(A1:A10)

Microsoft Excel_Easy Calculations

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?