how to find projected sales for 10%-clothes just for children 1 or more. Provide steps

 

Home Paste J17 234 A 1 Customer # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 2 3 Insert Draw Page Layout X 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 V Calibri (Body) I U B fx B Children V 0 0 2 2 0 1 0 1 3 1 2 3 2 3 3 1 0 0 3 2 0 2 1 0 1 3 1 0 0 0 V V 12 4 3 4 2 1 4 3 1 2 2 3 4 1 3 1 3 32 2 3 1 2 C D E Household Ir Number of V Mobile Use 2 71 4 46 2 73 2 97 2 72 3 68 82 15 34 18 3 334 3 Formulas Data 4 1 V V A^ A V A 99 60 70 92 52 75 41 45 24 61 36 100 18 9 Review 54 23 57 36 34 48 1 0 0 0 0 0 0 0 1 0 1 0 1 1 1 0 0 0 1 1 0 1 1 1 0 0 1 0 1 1 View F Region V * 6 U 00 8 5 5 1 8 4 8 5 8 5 1 34 4 5 7 528 4 8 8 7 7 2 8 2 2 6 4 Automate ab General $ % 95.00 V 38 57.9 37.5 49.7 43.7 66.7 70.7 60.1 Tell me 89.8 97.2 123 20.3 146.9 48.5 G H SALES W/O PROM SALES W/ PR PROJECTED SALES FOR 10% CLOTHES 22.95 22.6 27.7 26.3 31.6 146.9 .00 .0 50.4 V | V Conditional Format Formatting as Table J V Cell Styles K Insert v Delete Format v *18* Ou V V 11 12 3 Grand Total V number of children Sort & Filter Grand Total number of children 1 N 2 3 Find & Select Comments Analyze Data M Sha Sensitivity Average of SALES W/ PROMO 79.36564885! 78.32314815 82.04126984 79.98082192 Average of SALES W/ PROMO 79.36564885 78.32314815 82.04126984 79.98082192 0