Question: Examine the SalesEntryForm worksheet and correct its formula error. Create validation rules so that unique sales rep names appear in a drop-down list using the

Examine the SalesEntryForm worksheet and correct its formula error. Create validation rules so that unique sales rep names appear in a drop-down list using the data on the SalesRepSummary worksheet, sales dates are limited to valid dates in 2022, and sales amounts must be positive values. Annotate the validation rules so users entering the data will know what data to enter and what is allowed. MTSU Auto Sales Rep Sales Data Entry Form A B 5 Sales Rep Name ---------------- 6 Sales Date -------------- 7 Sales Amount ---------------- 8 Commission #NAME? =@RUND(B7*B11,2) 9 Commission Percentage: 7.75% MTSU Auto Sales Rep Commission Data For the Current Month A B C D 5 Sales Rep Name Sales Date Sales Amount Commission 6 Tony Morrison 7/14/2022 $2,200.00 $165.00 7 Steven White 7/14/2022 $1,900.00 $142.50 8 Emily Newhouse 7/14/2022 $1,450.00 $108.75 9 Marsha Littlefield 7/14/2022 $1,875.00 $140.63 10 Emily Newhouse 7/16/2022 $1,750.00 $131.25 11 Tony Morrison 7/17/2022 $2,500.00 $187.50 12 Steven White 7/17/2022 $1,800.00 $135.00 13 Sam Smith 7/17/2022 $2,300.00 $172.50 14 Emily Newhouse 7/17/2022 $1,750.00 $131.25 15 Sam Smith 7/19/2022 $2,525.00 $189.38 16 Sam Smith 7/19/2022 $1,775.00 $133.13 17 Emily Newhouse 7/19/2022 $1,825.00 $136.88 18 Marsha Littlefield 7/19/2022 $1,875.00 $140.63 19 Marsha Littlefield 7/20/2022 $1,950.00 $146.25 20 Emily Newhouse 7/21/2022 $1,875.00 $140.63 21 Emily Newhouse 7/24/2022 $1,790.00 $134.25 22 Marsha Littlefield 7/24/2022 $1,875.00 $140.63 E F G 1 Row Labels Sum of Sales Amount Sum of Commission 2 Emily Newhouse 10440 783.01 3 Marsha Littlefield 7575 568.14 4 Sam Smith 6600 495.01 5 Steven White 3700 277.5 6 Tony Morrison 4700 352.5 7 Grand Total 33015 2476.16

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!