I need excel help.

Job ID: 33674553

Budget: $20 – $50 USD

I need the 5 questions answered and need to have a brief explanation on how it was done. Complete the questions formulaically and without the use of pivot tables and copying and pasting data sets.