80-100 ict

A single item of data in a database

• Record

• Field

• Table

Table which is organized by columns & rows

• Cell reference

• Function

• Spreadsheet

The intersection of a row and a column

• Charts

• Formula

• Cell

Used in Situations in which the cell reference must remain the same when copied or when using AutoFill

• Formulas

• Absolute Cell References

• Relative cell references

Used to adjust and change when copied or when using AutoFill.

 

• Sheet name

• Absolute Cell References

• Relative cell references

Test data at the upper or lower limits of expectations that should be accepted by the data model

• Erroneouss data

• Boundary data 

• Abnormal data

test data that falls outside of what is acceptable and should be rejected by the data model.

• Abnormal data

• Data analysis

• Normal data

Function which checks for the given condition and provides results as per condition satisfaction.

• IF

• AND

• OR

This function used in excel when we want to check whether two conditions are satisfied or not

• NOT

• AND

• OR

This function gives results if anyone logic or condition satisfies.

• IF

• AND

• OR