Excel problems

hello i need help  im doing homework open need an exper in excel

i will attach 2 files excel you need to fighur out the answers

another file = power point which it shows how the answers should be look like

the excel file should like look the powerpoint but no copy and paste , it need real answers