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

인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?