Spreadsheets Flashcards
List five cell formats.
- Short date
- Time
- Text
- Numeric
- Currency
An absolute cell reference is a cell reference which…
does not change if the formula is copied down a column or across a row
An absolute cell reference is made by surrounding the column reference with…
dollar signs
An advantage of using a wizard to produce a graph is that it guides…
the user through the process, showing the result of each stage
An advantage of using a wizard to produce a graph is that it offers…
a number of options to the user in each step
It is important to test a spreadsheet to ensure that it meets…
user requirements
It is important to test a spreadsheet to ensure that formulas…
work
It is important to test a spreadsheet to ensure that data validation rules…
work correctly
It is important to test a spreadsheet to ensure that graphs produced appear…
as expected
It is important to test a spreadsheet to ensure that recalculations are…
automatic when a value in a cell is changed
List three aspects of a spreadsheet that should be tested.
- Formulas
- Data validation rules
- Graphs
It is important to evaluate a spreadsheet to consider how well the spreadsheet…
uses functions and formulas
It is important to evaluate a spreadsheet to consider whether graphs…
enhance the presentation of results
It is important to evaluate a spreadsheet to consider particular…
areas for improvement in the spreadsheet
To ensure results produced on a spreadsheet are accurate, the spreadsheet should be…
tested fully, worksheet by worksheet