Get Essential Spreadsheets Exercises

This guide provides clear and detailed instructions on how to successfully complete the Essential Spreadsheets Exercises online. Each section of the form is broken down step-by-step to help users navigate the process with ease.

Follow the steps to complete your exercises effectively.

1. Click the ‘Get Form’ button to obtain the form and open it in your editor.
2. Review the introduction section of the form to understand the objectives and requirements of the Essential Spreadsheets Exercises.
3. Begin with 'Workspace 1.' Open the appropriate file and rename 'Sheet1' to ‘Year 14-15’ while setting the tab color to red.
4. Adjust the width of column B to fit the text in rows 3-12. Ensure the data is clearly readable.
5. Modify the height of row 7 to match the height of other rows for a consistent appearance.
6. Align the widths of columns D-I to ensure they are consistent and that dates in row 12 are visible.
7. Transfer data from cells D20:I26 to the range D3:I9 to organize the sheet effectively.
8. Remove column C as it is empty, enhancing the clarity of the data presented.
9. Utilize the autofill feature to fill in the months from October to March in row 2.
10. Insert a new row labeled ‘Hospitality’ between existing items in column B, followed by entering the hospitality values for Oct-March.
11. Continue this process through each exercise outlined, completing calculations, using functions, and simplifying data entry as directed.
12. Once completed, save changes to the document, and choose from options to download, print, or share your progress.

Start filling out the Essential Spreadsheets Exercises online today!