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

โดย
สั่งพิมพ์
ฝัง

ลีดเดอร์บอร์ด

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

คืนค่าการบันทึกอัตโนมัติ: ใช่ไหม