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) = MAX(B2:B6) will do what a) calculate the largest value b) calculate the smallest value c) calculate the average value d) calculate the amount of cells 10) = MIN (B2:B6) will do what a) calculate the largest value b) calculate the smallest value c) calculate the average value d) calculate the amount of cells 11) = AVERAGE (B2:B6) will do what  a) calculate the amount of cells b) calculate the average value c) calculate the largest value d) calculate the smallest value 12) = COUNT (B2:B6) will do what a) calculate the smallest value b) calculate the largest value c) calculate the amount of cells d) calculate the average value

Formulas Excel Quiz

Imprimare
Încorporează

Clasament

Stilul vizual

Opţiuni

Comutare șablon

Restaurare activitate salvată automat: ?