Less 4: basic actions sheets

Les 4: basishandelingen spreadsheet
1 / 15
next
Slide 1: Slide
InformaticaSecundair onderwijs

This lesson contains 15 slides, with interactive quizzes and text slides.

time-iconLesson duration is: 50 min

Items in this lesson

Les 4: basishandelingen spreadsheet

Slide 1 - Slide

Workbook title
Formula bar
range
Tab

Slide 2 - Drag question

Slide 3 - Slide

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

Slide 4 - Slide


What is the range of 1

Slide 5 - Open question


What is the range of 2

Slide 6 - Open question


What is the range of 3

Slide 7 - Open question


What is the range of 4

Slide 8 - Open question


What is the range of 5

Slide 9 - Open question

Doorvoeren

Slide 10 - Slide

What is the name of the little black cross (bottom right)
A
Fill handle
B
plus (addition )
C
resize

Slide 11 - Quiz

Navigation

Slide 12 - Slide

What is the quickest way to make a cell fitting
A
drag the column header around
B
Use the RMB to resize
C
double click in between column headings

Slide 13 - Quiz

Can you change the content of a cell if you only click once
A
yes
B
no
C
yes, but not in the cell itself

Slide 14 - Quiz

De snelste manier om een rij / kolom te selecteren is
A
ctrl + A
B
klikken op de kop
C
klik en slepen

Slide 15 - Quiz