Create a data model

Develop a data model. Students should be capable of: Notes and Guidance Creating and modifying a spreadsheet model, adding and removing cells, rows, and columns, and merging cells. Formulating calculations using cell references and replicating these calculations with both absolute and relative references as necessary. Employing arithmetic operators in calculations such as addition, subtraction, multiplication, division, and exponentiation. Utilizing named cells and ranges. Applying functions such as sum, average, maximum, minimum, integer, rounding, counting, LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP, and IF. Incorporating external data sources within functions and using nested functions. Students should comprehend: The distinction between formulae and functions, the order of operations in mathematical calculations, including the use of brackets to ensure correct formula execution, and the characteristics and application of absolute and relative cell referencing.