Excel Functions and Formulas

Front

What is the correct formula for SUM  in Excel?

Back

=SUM(B3:B9)

Front

Which button can you click to add up a series of numbers?

Back

The autosum button

Front

Which formula gets the biggest value of a range of cells? Options: MAX, MIN, LARGE, SUM

Back

MAX

Front

Which formula gets the smallest value of a range of cells?

Back

MIN

Front

Which symbol must all formula begin with?

Back

=

Front

What text formula joins the text from two or more cells?

Back

concatenate

Front

Which formula will calculate the average based on a condition? (return the average of sales if over $20)

Back

averageif

Front

Which formula would you use to calculate how many sales are over $20 from a series.

Back

countif

Front

Which formula will automatically capitalize the first letter of a word? Options: abra-ka-dabra, proper, capitalize, upper-case

Back

proper

Front

Which tool is used to add a graphic representation of data based on a condition within a cell? For example, adding green data bars to a column of data.

Back

conditional formatting