Hello, I was sent an excel sheet to provide solution as the first stage in my interview process. Below is the instructions and screenshot of the excel sheet. I need guidance on how to provide solution to the case study. Thank you so much Instructions: 1. Use the data on the GFD and CHARITY tabs to provide the details on the SUMMARY. Please note that the format on the SUMMARY tab is only meant as a guide to the desired output, You may present the requested data in the format you think best displays the information and showcases your capabilities

Hey Temitope, You need to use SUMIFS, COUNTIFS, and AVERAGEIFS. To learn how to use these functions you can see the respective lectures in the Intro to Excel course. Once you have done that, I'll be happy to help with specific questions. Best, Ned

Hi Ned, I have gone through the lectures and understand how to use the functions. below is the instruction i was given for the case study practice. Instructions: 1. Use the data on the GFD and CHARITY tabs to provide the details on the SUMMARY. Please note that the format on the SUMMARY tab is only meant as a guide to the desired output, You may present the requested data in the format you think best displays the information and showcases your capabilities. Kind Regards. Temitope.

Hello, Still waiting for a response. Thank you.

Hey Temitope, I would be ok to help with some parts of the question if you ask me specific questions. But I can't solve the entire task. I don't think that's fair. Best, Ned