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

הדפסה
הטבעה

לוח תוצאות מובילות

סגנון חזותי

אפשרויות

החלף תבנית

האם לשחזר את הנתונים שנשמרו באופן אוטומטי: ?