Resolved: Practical case study for excel interview
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.