Please enable JavaScript.
Coggle requires JavaScript to display documents.
UNIT 20 - Coggle Diagram
UNIT 20
test a data model
test/ing data: checks validation
expected outcome: results you want to see when objectives obeyed
normal data: data with the rule
abnormal data: outside the rule requirement
extreme data: result on the boundary of the requirement
actual outcome: the results that came
Addition- =A1+B2
Subtraction- =A1-B2
Multiplication- =A1*B2
Division- =A1/B2
Exponent- =A1^B2
Cell
is the intersection between a row and a column on a spreadsheet.
Formula is an expression which calculates the value of a cell.
Function
is a formula that performs calculations using specific values in a particular order
Row
is a series of cells horizontally. and...
Column
is a series of vertical cells in a spreadsheet.
Tab
is used to display the worksheet that a user is currently editing
Page
is a worksheet of spreadsheet
Chart
- graph is a visual representation of data from a worksheet
data entered in the spreadsheet must be accurate so it can be presented clearly and the future results can be reliable
Use mathematical operators, including: add, subtract, multiply, divide, indices, where necessary
absolute reference is to keep a row and/or column constant. e.g.($A1 / A$1 / $A$1)
Cell reference is referring to cells in the same or different worksheet
Use functions, including: sum, average, maximum, minimum, integer, rounding, counting, LOOKUP, VLOOKUP, HLOOKUP, IF and nested functions, when necessary
Explain the need to test a model before it is used
Search using a single criterion and using multiple criteria, where appropriate, with a variety of operators like: AND, OR, NOT, LIKE, >, <, =, >=, <=
Sort data using a single criterion and using multiple criteria into ascending or descending order, as required
Adjust row height, column width and cell sizes so that all data, labels, and formulae are fully visible
Use features to enhance a spreadsheet, including: text colour, cell colour, bold, underline, italic and shading to meet the needs of the audience
Format numeric data to display the number of decimal places, a variety of different currency values, percentages as appropriate
Set the spreadsheet to display formulae and values
Set the page layout so that it prints on a specified number of pages
Justify the choice of test data