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

打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？