1) Manipulate cells, rows, columns including inserting, deleting and hiding of cells, rows and columns. 2) Format cells and ranges including number formats, borders, font colours and background colour fills,

and conditional formatting. 3) Create, organise and document both computational and exploratory models. 4) Format the model so as to distinguish between different types ofvariables. 5) Construct model using formula and functions such as: • IF() SUM(), SUMIF(), SUMIFS() COUNT(), COUNTA(), COUNTIF(), COUNTIFS() AVERAGE(), AVERAGEIF(), AVERAGEIFS() • MIN(), MAX() • CONCATENATE(), & operator VLOOKUP(), HLOOKUP(), LOOKUP() MATCH(), INDEX() • ROUND(), FLOOR(), CEIL() PMT(), PV(), FV(), RATE(), NPER() DATE() NPV), IRR( INTO, MODO SUMPRODUCT() Note that above functions are not exhaustive. Other business-related functions not listed above may be required. Students are expected to be able to search for appropriate functions using built-in F1 help feature of Excel. Apply Conditional Formatting to Models to highlight important results and data. O Apply Color-scales formatting to tables for sensitivity analysis. O Apply Goal Seek to problem solving. Apply Solver including setting Objective, Constraints and Input Ranges. 0) Interpret and Comment on results of models from a business perspective. ) Plot graphs from tabular data along with proper labeling of the graphs.