81-100

Table which is organized by columns & rows

• Spreadsheet

• Formula

• Function

• Cell reference

• Charts

The intersection of a row and a column

 

• Cell

• Formula

• Function

• Spreadsheet

• Charts

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

• Absolute Cell References

• References

• Relative cell references

• Sheet name

• Formulas

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

 

• Relative cell references

• Absolute Cell References

• Sheet name

• Formulas

• Values

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

• Boundary data 

• Abnormal data

• Erroneouss data

• Normal data

• data model

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

• Abnormal data

• Data analysis

• Boundary data 

• Normal data

• data model

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

• IF

• AND

• OR

• XOR

• NOT

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

• AND

• IF

• OR

• XOR

• NOT

This function gives results if anyone logic or condition satisfies.

• OR

• IF

• AND

• XOR

• NOT

This function returns True value if only one condition satisfies out of two.

• XOR

• IF

• AND

• OR

• NOT