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

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?