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

打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？