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

Cetak
Menyematkan

Papan Peringkat

Gaya visual

Pilihan

Berganti templat

Pulihkan simpan otomatis: ?