Use absolute cell referencing and the percentage Gross Sales Increase from the Assumptions Table to calculate the project.
Excel Assignment 1 1. Create a projected profits worksheet using the template available in D2L under the content tab entitled Excel Assignment 1 Template. 2. Bold all text in column…