Please submit the assessment even if you did not fully complete it in the time allocated. If you were unable to fully complete it, please include a brief explanation of where you had the most difficulty/ what took the most time. Please complete the following tasks within this worksheet and return the excel file to us via email within 1 hour. 1) The 'member names' and 'membership information' tabs contain (fictitious) member information. For context, we distinguish members by their location (local to LA or non-local) and the sector in which they work (for profit or non-profit). In Sheet 1, please count (using a formula) the number of 'local' and 'non-local' members we have based on the 'membership information' tab, and enter a chart that shows the proportion of one to the other. Choose the chart type that you think is best suited. 2) Create another sheet named 'chart training' in which you explain to a colleague how to create a chart like the one you created from a similar list of membership information, so they could repeat the process independently later. 3) The 'member names' tab contains 500 names and corresponding member ID; 'membership information' contains the membership descriptor and birthdates for 250 of those members, also with corresponding IDs. In Sheet 2, please create a list that matches member names with their membership information & birthdates using the Membership IDs provided. 2) Leave the formulas you used intact in Sheet 2 and copy the information as values into Sheet 3. (There should be a list of 250 members with IDs, names, birthdate, and membership information in Sheet 3 when you are done). 3) Create another sheet named 'matching training' in which you explain to a colleague how to match based on ID like you did in sheet 3, so they could repeat the process independently later. Please note: We expect you to use excel formulas to provide the most accurate result, but we do not expect you to know these formulas off the top of your head. You are encouraged to use online resources to find the formula to best provide the desired results. In your description of the process, please communicate as if the instructions are meant for a person with only basic excel skills.