1) To add multiple cells together to calculate a total, I must use... a) =COUNT b) =SUM c) =AVERAGE 2) To find the average of a range of cells, I must use... a) =AVERAGE b) =COUNTA c) =SUM 3) To count cells containing words (and not values), I must use... a) =COUNT b) =COUNTBLANK c) =COUNTA d) COUNTA 4) To calculate the smallest number in a range of cells, I must use... a) =MAX b) =SUM c) =COUNTA d) =MIN 5) To determine whether or not a discount should be applied to a value based on if the business exceeds last year's profit, I must use... a) =SUM b) SUM c) =IF d) =MAX 6) To calculate the largest number in a range of cells, I must use... a) =MAX b) =MIN c) MAX d) MIN 7) To count cells containing values (and not words), I must use... a) COUNT b) =COUNT c) =COUNTBLANK d) =COUNTA 8) What would be a suitable named cell for B11? a) VAT b) =VALUEADDEDTAX c) 20%

Using Excel

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?