ICT Chapter 11 – Spreadsheet and modelling software

HideShow resource information
Spinners
Allow you to edit the value in a CELL by clicking either UP or DOWN.
1 of 15
List boxes
This allows a CELL to have a choice of data for a user to select. This data is limited to a list that has been created by the creator. List boxes tend to have a scroll bar.
2 of 15
Combo boxes
The list for this box will only appear if the user clicks on the drop down arrow. Combo boxes are used when you have fixed numbers of choices e.g. Days of the week, months of the year, sizes (S,M,L).
3 of 15
Logical Boolean
Only stores two values for the user to answer.
4 of 15
Option buttons
used when alternative options need to be selected. For example different age ranges
5 of 15
Aligning cells
LEFT,CENTRE, RIGHT
6 of 15
Formatting fonts
Font type – changes shapes of letters and numbers Font size – changing the size of characters in a CELL Font style – Bold, Italic, underline
7 of 15
Text alignment
Changing the degree of the text (orientation) Adding colour/Shading/Borders
8 of 15
Percentages
Numbers with % symbol on the side
9 of 15
Decimal places
Specify the number of decimal spaces you want in your final number
10 of 15
Currency
This is specified to two decimal places and has a sign attached to the number.
11 of 15
Fractions
You can perform calculations involving fractions using a spreadsheet.
12 of 15
Text
can consist of letters from the alphabet and other characters on your keyboard
13 of 15
Date/Time
storing date and time within a spreadsheet
14 of 15
Logical/Boolean
Can only have two values e.g. (YES/NO) , (MALE/FEMALE)…..
15 of 15

Other cards in this set

Card 2

Front

List boxes

Back

This allows a CELL to have a choice of data for a user to select. This data is limited to a list that has been created by the creator. List boxes tend to have a scroll bar.

Card 3

Front

Combo boxes

Back

Preview of the front of card 3

Card 4

Front

Logical Boolean

Back

Preview of the front of card 4

Card 5

Front

Option buttons

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 »