• You are entering product ID codes in the cell range A1: A15. Product ID codes must always end with the characters xyz. Use data validation to ensure that each product ID code entered ends with xyz. Use the Custom setting and the RIGHT function.

 

Transcribed Image Text:

A В D F G H K L 1 2. 4 WALMART price 5 gumballs 6 musketeers 7 hershey 8 menthos price CVS price Target gumballs price 0.52 hershey Walgreens price Osco 0.6 0.92 Baby Ruth 0.97 dove bar 0.61 0.63 musketeers 0.67 lifesavers 0.58 mentos 0.78 Reece's 0.94 Baby Ruth lifesavers 0.74 gumballs 0.7 menthos 0.6 1 hershey 0.52 dove bar 0.74 0.79 0.84 menthos 0.75 Reece's 0.78 10 11 12 A В D F G H K L 1 2. 4 WALMART price 5 gumballs 6 musketeers 7 hershey 8 menthos price CVS price Target gumballs price 0.52 hershey Walgreens price Osco 0.6 0.92 Baby Ruth 0.97 dove bar 0.61 0.63 musketeers 0.67 lifesavers 0.58 mentos 0.78 Reece's 0.94 Baby Ruth lifesavers 0.74 gumballs 0.7 menthos 0.6 1 hershey 0.52 dove bar 0.74 0.79 0.84 menthos 0.75 Reece's 0.78 10 11 12

Answer rating: 100% (QA)

The step by step solution given below Step 1 Select the cell range A1A15 and click the Data ... View the full answer