3 Essential Spreadsheet Functions Free Online FlashCards

What character must begin a spreadsheet formula?

Spreadsheet formulas begin with an equals sign (=).

How do you calculate a row total from quantity in B2 and unit price in C2?

Use =B2*C2. It multiplies the quantity in B2 by the unit price in C2.

Which function adds the values in a range?

SUM adds values in a range, such as =SUM(G2:G100).

Which function finds the arithmetic mean of a range?

AVERAGE finds the arithmetic mean of values, for example =AVERAGE(G2:G100).

How do COUNT and COUNTA differ?

COUNT counts numeric cells; COUNTA counts nonempty cells, including those containing text.

What does the IF function do?

IF tests a condition and returns one result when it is true and another when it is false.

How do AND and OR differ when combining conditions?

AND is true only when every condition is true; OR is true when at least one condition is true.

What does IFERROR do, and what is a risk of using it indiscriminately?

IFERROR returns a chosen value when a formula produces an error. Replacing every error with zero can hide data or formula problems.

What does TRIM do to text?

TRIM removes leading and trailing spaces and reduces repeated spaces between words.

How do LEFT and RIGHT differ?

LEFT returns characters from the beginning of text; RIGHT returns characters from the end.

What happens to a number when TEXT formats it?

TEXT converts a number into formatted text. Keep the original numeric value for later calculations.

What does TODAY() return, and when can its result change?

TODAY() returns the current date, and its result can change when the spreadsheet recalculates.