Excel Challenge help again…

I need help with the  following excel challenges….the excel file, instructions and solution file is attached.. must have excel 2013.