CIS assignment

Instructions: Excel 2019 Module 2 End of Module Project 2 Formatting Worksheets For this assignment, you will demonstrate your ability to professionally format a worksheet using the skills introduced in Module 2. Follow each step carefully and ensure your formatting matches the required standards. 1. Format the Worksheet Title Locate the main worksheet title in Row 1. Merge and center the title across all columns containing data. Increase the font size to make the title prominent. Apply bold formatting. Ensure the title is visually distinct from the rest of the worksheet. 2. Format Column Headings Select the header row containing column labels. Apply bold formatting. Center-align the headings. Apply an appropriate fill color if required. Add All Borders to the header row. Apply a Thick Outside Border around the header row to define the table structure. 3. Adjust Column Widths AutoFit all columns so that all content is fully visible. Ensure there is no text truncation or unnecessary excessive spacing. 4. Format Numerical Data Appropriately Currency Values Format all monetary values using the Currency format. Ensure two decimal places are displayed. Percentages Apply Percent Style formatting where required. Adjust decimal places as necessary. Large Numbers Use Comma Style formatting for totals or large numeric values when appropriate. 5. Format Totals Row Bold the totals row. Apply the correct number formatting (Currency or Comma Style). Add a Top Border above the totals row to visually separate it from the data. 6. Apply Cell Styles Use built-in Cell Styles where appropriate, such as Title, Heading, or Total. Ensure consistent and professional formatting throughout the worksheet. 7. Freeze Panes Freeze the top row so column headings remain visible while scrolling. 8. Page Layout and Print Settings Adjust page orientation if required. Set appropriate margins. Scale the worksheet to fit on one page wide if instructed. Ensure the worksheet is print-ready and professionally formatted. 9. Final Review Before Submission Before submitting your assignment: Confirm all formatting matches the instructions. Verify that all number formats are correct. Ensure borders are consistent and clean. Check alignment and spacing. Save the file using the required naming convention.