Last answered:

11 Feb 2022

Posted on:

07 Feb 2022

0

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 Solution sheet-SummaryInformation needed for Information needed for

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

4 answers ( 1 marked as helpful)
Instructor
Posted on:

08 Feb 2022

1

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

Posted on:

08 Feb 2022

0

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.

Posted on:

09 Feb 2022

0

Hello,
Still waiting for a response.

Thank you.

Instructor
Posted on:

11 Feb 2022

0

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

Submit an answer