1) A vertical reference in a spreadsheet a) Row b) Column c) Cell 2) A function that adds up a column of numbers is called __________. a) SUM b) AVERAGE c) MIN d) MAX 3) A mathematical operation is called a _____. a) formula b) function c) SUM d) graph 4) A group of cells is called a _____. a) range b) group c) label d) box 5) What do all formulas begin with? a) Equals b) Minus c) Add d) Percentage e) Brackets 6) What symbol do we use for multiplication in a Spreadsheet program? a) Asterix b) Slash c) Add d) Percentage e) Equals 7) What symbol do we use for division in a Spreadsheet program? a) Slash b) Asterix c) Percentage d) Colon 8) Which of the following tells a spreadsheet to subtract the value in cell A4 from the value in cell A3? a) =A3-A4 b) =A4-A3 c) SUM(A3,A4) d) :(A3)-(A4) 9) Which of the following is a correct example using the SUM function? a) =SUM(A1:A10) b) =SUM A1 to A10 c) SUM A1 - A10 = d) (A1:A10)=SUM 10) AVERAGE, SUM, MIN and MAX are examples of what? a) Functions b) Formulas c) Cheats d) Labels e) Graphs

Spreadsheet Terms

打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？