- Finish the instructions in the Sheet1 sheet.
- Navigate to the Posters & Co. sheet and complete the given instructions.
- In Posters & Co., make the following changes:
- Change Maslin Lester's "Shipping" value to $3.25 in cell H8.
- Modify Samantha Tin's number of orders from 10 to 9 in cell F6.
- Change Joe Smith's "Price per Poster" to $10.50 in cell G4.
- Insert a new row above Maslin Lester with the following data:
- Date: 6/11/19
- First: Bailey
- Last: Jones
- Phone: 281-285-6849
- Email: firstname.lastname@example.org
- # of Posters: 5
- Price per Poster: $11.35
- Shipping: $7.25
- In J4 write a formula to determine the Date of Shipping. This is determined by adding 4 business days to the order date in column A. Autofill it for the rest of the rows.
- Save your file!