Use functions including sum, average, maximum, minimum, integer, rounding, counting, LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP, IF

File/data structures including field length, field name, data type, coding of data for example M for male, F for female

The need to identify the inputs, outputs and processing of the current system, problems with the current system, the user and information requirements for the new system