Spreadsheets and modeling software

HideShow resource information
Spinners
These let you alter the value in a cell by clicking on an up or down arrow.
1 of 9
List boxes
List boxes present a choice of data to be entered into a spreadsheet cell.
2 of 9
Combo boxes
These allow you to choose an entry from a list which only appears when you click on the arrow to drop it down.
3 of 9
Text
Text can consist of letters of the alphabet numbers and other characters on the keyboard
4 of 9
Data/Time
There are many different ways in which dates and times can be stored by a spreadsheet/database
5 of 9
Logical/Boolean (True or False)
These are sometimes called check boxes or tick boxes and they return a true of false depending on whether they are slectected or cleared
6 of 9
Forms toolbar
Contains lots of ideas for making it easier to add data as well as making data entry more accurate by restricting choices
7 of 9
Added colour/shading
Adding colours to text, borders and background colours for cells
8 of 9
Types of data
There are many different types of data that can put into a spreadsheet or database
9 of 9

Other cards in this set

Card 2

Front

List boxes

Back

List boxes present a choice of data to be entered into a spreadsheet cell.

Card 3

Front

Combo boxes

Back

Preview of the front of card 3

Card 4

Front

Text

Back

Preview of the front of card 4

Card 5

Front

Data/Time

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Spreadsheets and Databases resources »