1) Columns are displayed vertically and are labelled with... a) Letters b) Symbols c) Numbers 2) Rows are displayed horizontally and are labelled with... a) Symbols b) Numbers c) Letters 3) What is the correct cell reference for the cell with the dog? a) C1 b) 1C c) C d) C3 4) What is the correct cell reference for the cell with the dog? a) C2 b) B2 c) 2B d) A2 5) What is the correct formula to use in E3? a) SUM(B3:D3) b) =SUM(B3;D3) c) =B2-C2-D2 d) B2+C2+D2 6) What formula should you use to find the highest value in a range of cells? a) =MAX b) =MIN c) =COUNT 7) What formula should be used to count the number of cells containing values? a) =MAX b) =MIN c) =COUNT 8) What formula should you use to find the lowest value in a range of cells? a) =MAX b) =MIN c) =COUNT 9) What symbol is used to multiply cells together? a) / b) * c) - d) + 10) What symbol is used to divide cells? a) / b) * c) - d) +

Spreadsheet Practice

สั่งพิมพ์
ฝัง

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

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

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