Task 2 - Spreadsheet Creation Task

You are required to design and create a spreadsheet to present sales income data to management at the meeting scheduled for next week.

Use your textbook and MS Excel online help if required.

Instructions:

Open a new Microsoft Excel spreadsheet.

Enter the following data:

Income Categories	2019	2020	2021
Share Portfolios	5600	5800	formula
Banking Services	8844	9040	formula
Debt Elimination	500	750	formula
Insurance	2500	3550	formula
Superannuation	3110	2940	formula
TOTAL	AutoSum Function	AutoSum Function	AutoSum Function
Average Service Income	Formula (NOT a Function)	Formula (NOT a Function)	Formula (NOT a Function)
Difference between 2021 and 2020 service income			Formula

Formula Requirements:

You must use all four arithmetic operators: addition (+), subtraction (-), multiplication (*), and division (/) in your spreadsheet.

Calculate the 2021 income by applying a 10% increase to the 2020 income figures.

Enter 10% in a cell outside the table, define it as a named range called Sales_Increase.

Use this named range in your formulas for the 2021 income.

Use AutoSum to calculate totals.

Use arithmetic formulas (not functions) to calculate average income.

Use a formula to calculate the difference between 2021 and 2020 total service income.