Less 4: basic actions sheets

• Informatica
• Secundair onderwijs

Les 4: basishandelingen spreadsheet

Workbook title

Formula bar

range

Tab

Range

use CAPS

 start with =

followed by (

a group of adjacent cells uses a   :

a group op non-adjacent cells uses  a ;

end your range witha a  )

=(B1:B8) the range B1 till B8.  this means all cells between cel B1 en B8 including B1 en B8

=B1;B8 this means cell B1 andB8
=(B1:B8);(C3:C6)  the range B1 till B8 and the range C3 till C6

What is the range of 1

What is the range of 2

What is the range of 3

What is the range of 4

What is the range of 5

Doorvoeren

What is the name of the little black cross (bottom right)

1. Fill handle
2. plus (addition )
3. resize

Navigation

What is the quickest way to make a cell fitting

1. drag the column header around
2. Use the RMB to resize
3. double click in between column headings

Can you change the content of a cell if you only click once

1. yes
2. no
3. yes, but not in the cell itself

De snelste manier om een rij / kolom te selecteren is

1. ctrl + A
2. klikken op de kop
3. klik en slepen