The worksheet consists of two sections which is the input (i.e. What-If assumptions area) and information sections. Hence, where appropriate, ensure that the information section formulae reference the cell values contained in the input section.
1. Based on the given worksheet (i.e. [login to view URL]), you need to further improve the worksheet to make it appear more consistent, professional and well-organized. For example, include an appropriate header, footer, title (with current system date) and apply proper formatting to the cells and worksheet.
2. Add another row that assess the net income of each year below the "Net Income" row in the worksheet and name it as "Performance". The performance is assessed as "Excellence" if the net income is greater than RM200,000 otherwise it is "Good" only. Use IF function to build this logic.
3. Mr Forest wants the input and information sections printed on separate pages. For each section's printout, he wants the results printed on a single page. The printouts should utilize a portrait orientation and be centered horizontally and vertically.
** Find Attachment for full question **