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

Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?