Spreadsheets Flashcards
What are computer models used for?
To predict how devices behave in certain situations
What does a what if scenario tell us?
The results of different scenarios
Validation is
The checking of data by software to see if is reasonable/accurate
Verification
The checking of data by humans
Rows are numbered: True or False?
True
Columns are not lettered: True or False?
False
Spreadsheets can be used to
Display, store, calculate data
What is used to identify a cell?
Cell reference
What is the order in a cell reference?
Letter then number
What does a formula always start with?
Equals sign
Charts in a spreadsheet don’t have to be titled: True or False?
False
What symbol suggests an absolute cell reference?
$ the dollars sign
Can tabs be assigned colours in spreadsheets?
Yes
Sort means
Arranging data in order
What is a macro?
A small program that can be written by an user inside a spreadsheet