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

Drucken
Einbetten

Bestenliste

Visueller Stil

Einstellungen

Vorlage ändern

Soll die automatisch gespeicherte Aktivität wiederhergestellt werden?