Which one finds the highest figure?, SUM, AVERAGE, COUNTA, MAX, MIN, What does * do in a spreadsheet?, Multiply, Divide, Subtract, Add, What does - do in a spreadsheet?, Multiply, Divide, Subtract, Add, What does + do in a spreadsheet?, Multiply, Divide, Subtract, Add, Which one finds the LOWEST figure?, SUM, AVERAGE, COUNTA, MAX, MIN, What does / do in a spreadsheet?, Multiply, Divide, Subtract, Add, Which one adds a range of cells?, SUM, AVERAGE, COUNTA, MAX, MIN, Which one finds the number of?, SUM, AVERAGE, COUNTA, MAX, MIN, Which one of these formulae is correct?, =(sum B2:B4), =SUM(B2;B4), =SUM(B2:B4), SUM(B2:B4), Which one is correct for finding the highest sales?, =sum(B2:B4), =counta(B2:B4), =average(B2:B4), =max(B2:B4), Which one of these formulae is correct?, =(averageB2:B4), =average(B2;B4), =average(B2:B4), averageB2:B4), Which one of these formulae is correct?, =(maxB2:B4), =max(B2;B4), max(B2:B4), =max(B2:B4), Which one is correct for finding the lowest sales?, =min(B2:B4), =counta(B2:B4), =average(B2:B4), =max(B2:B4), How should column E be formatted?, Bold, Italics, Currency, Accounting, Which one is correct for finding the number of months?, =sum(B2:B4), =counta(B2:B4), =average(B2:B4), =max(B2:B4), Which one is correct for finding 20% of 5,000?, =20% / 5000, =20% + 5000, =20 * 5000, =20% * 5000, =20% - 5000, What formula should be in E2, =C2+D2, =C2-D2, =C2*D2, =sum(C2:D2), How has cell C1 been formatted, Bold, Italics, Currency, Accounting, Text Wrap, Right aligned

Spreadsheet Formula

ustvaril/-a
Natisni
Vdelaj

Lestvica vodilnih

Vizualni slog

Možnosti

Preklopi predlogo

Obnovi samodejno shranjeno: ?