To add multiple cells together to calculate a total, I must use..., =COUNT, =SUM, =AVERAGE, To find the average of a range of cells, I must use..., =AVERAGE, =COUNTA, =SUM, To count cells containing words (and not values), I must use..., =COUNT, =COUNTBLANK, =COUNTA, COUNTA, To calculate the smallest number in a range of cells, I must use..., =MAX, =SUM, =COUNTA, =MIN, 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..., =SUM, SUM, =IF, =MAX, To calculate the largest number in a range of cells, I must use..., =MAX, =MIN, MAX, MIN, To count cells containing values (and not words), I must use..., COUNT, =COUNT, =COUNTBLANK, =COUNTA, What would be a suitable named cell for B11?, VAT, =VALUEADDEDTAX, 20%.

Using Excel

autors:
Drukāt
Iegult

Līderu saraksts

Vizuālais stils

Iespējas

Pārslēgt veidni

)
Atjaunot automātiski saglabāto: ?