Requirements

Sales sheet

• Using Excel formulas, create a new column called "New Sales Price" that replaces the last two digits in each row of the "Sales Price" column with your age. For example, if your age is 26 and one of the sales numbers is 27,340 it would become 27,326 in the new column.

• Using Excel formulas, create a new column called "New Salesperson" that replaces all salespeople named "Arthur" with your first name.