Get Cgs2060 Ms Excel Basic Spreadsheet Assignment

This guide provides a comprehensive overview of how to successfully complete the CGS2060 MS Excel Basic Spreadsheet Assignment. By following these instructions, users can navigate the assignment with ease, ensuring all requirements are met and submitted correctly.

Follow the steps to complete the assignment accurately.

1. Click ‘Get Form’ button to acquire the CGS2060 MS Excel Basic Spreadsheet Assignment document and open it in your preferred online tool. This will enable you to begin filling out the necessary information.
2. Start by using your Assignment #4 as a foundation for this task. Make sure to select 'Excel Workbook (*.xlsx)' in the 'Save As Type' field while naming your file appropriately to meet submission criteria.
3. Review the top row of your spreadsheet to ensure the months are arranged in the correct order: January, February, March, April, May, June, July, August, September, October, November, and December.
4. Create 12 individual sheets for each month. Label these sheets exactly as follows: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec.
5. Replicate the required categories from the Budget sheet onto each month's sheet. Establish separate tables for Variable, Fixed, and Income, ensuring the Variable and Fixed expenses include columns for Category, Actual, Budget, and Delta, while the Income table includes only the Actual value.
6. Implement a drop-down menu for selecting expense categories in the Category column. Suggested categories include Housing, Grocery, Living, Entertainment, Medical, Charity, etc.
7. Create an additional sheet titled 'MonthlyBudget' containing two columns: one for the expense category and the other for the respective amounts allocated for those expenses.
8. Populate the Actual column in the MonthlyBudget sheet with either fictional or actual amounts as needed.
9. Ensure to replace any hard-coded values in the Budget page with the corresponding Actual values drawn from each month’s sheets. For example, entries such as the grocery bill for March should pull directly from the designated Grocery row in the March sheet.
10. Transform simple IF statements into more complex variations, ensuring that at least two questions are asked to derive results reflecting different scenarios based on yearly leftover amounts.
11. Alter the color scheme of the data columns for each month's sheets for aesthetic distinction.
12. Enhance the visual appeal by bolding all titles and ensuring text is formatted to size 12 and in a pleasant font style.
13. Add page numbers to the footers of each page to maintain organized documentation.
14. Align all sheets in the following order: BudgetXX, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec, MonthlyBudget.
15. Define the print area for each page, configure the layout for landscape orientation, and ensure the view is set to 100% for clear display.
16. After completing all sections, save your changes and explore the options to download, print, or share the form as needed.

To achieve the best results, complete your document online and follow these guidelines closely.