acc102 homework questions to be answered and completed in excel with shown work in cell

Will upload 3 images of the 3 homework questions that need to be completed by 11PM EST tonight. 11:30 LATEST. Need this to be completed on Excel where the professor can click on the cell and the work will be shown.