1) What is represented with a Letter? a) Column b) Row c) Cell 2) What is represented with a Number? a) Column b) Row c) Cell 3) What must all formulas begin with? a) = b) Cell Reference eg A1 c) SUM d) Function 4) B3 is an example of a a) Column b) Row c) Cell Reference 5) = B1 + B2 will do what? a) Add b) Subtract c) Multiple  d) Divide 6) = B1 - B2 will do what? a) Add b) Subtract c) Multiple d) Divide 7) = B1 * B2 will do what? a) Add b) Subtract c) Multiple d) Divide 8) = B1 / B2 will do what? a) Add b) Subtract c) Multiple d) Divide 9) =COUNT will do what? a) Add all of the numbers together b) Count how many total cells there are c) Count how many of the cells have numerical data 10) =SUM will do what? a) Add all of the numbers together b) Count how many total cells there are c) Count how many of the cells have numerical data 11) =MAX will do what? a) Find the lowest value b) Find the highest value c) Find the average d) Add all of the cells together 12) =AVERAGE will do what? a) Find the lowest value b) Find the highest value c) Find the average d) Add all of the cells together 13) When should you use =SUM? a) When adding 2 numbers together b) When adding 3 or more numbers together 14) =MIN will do what? a) Find the lowest value b) Find the highest value c) Find the average d) Add all of the cells together

Functions 1 - Excel Quiz

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?