Question: NEED HELP WITH EXCEL PROBLEM USING FORMULAS!! Practice Problem 2 for you to complete on your own Objective: Find Target Customer. Target customers are those
NEED HELP WITH EXCEL PROBLEM USING FORMULAS!!
| Practice Problem 2 for you to complete on your own | |||||||||
| Objective: Find Target Customer. Target customers are those who are female, of age less than 45, and have children | |||||||||

AutoSave OFF ACO IF_example-2 (1).xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments DI Arial v 10 LG = = ~ a Wrap Text General A Mo { 28 O o Paste .00 Insert BI av A. Av Delete Merge & Center & +1 V $ % ) Format V .00 Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data F5 A B D G H | J L M N O fx E F G 1 Practice Problem 2 for you to complete on your own 2 Objective: Find Target Customer. Target customers are those who are female, of age less than 45, and have children 3 4 Age Target Customers? 45 26 40 Name A1 B1 C1 A2 B2 C2 A3 B3 C3 51 29 State CA MA CO AK MS LA CA MA AK MS LA Gender F F F F F F F F F F M M F F 25 Children Yes Yes Yes Yes No Yes Yes Yes Yes No Yes Yes 35 36 49 44 19 20 A4 ? ? B4 C4 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 Exercise AND OR IF_Example Practice Problem 1 Practice Problem #2 Practice Problem #3 Ready 3 153%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
