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

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?