Prepare a xls file

Below is attatched the homework description it is pretty simple only long need to use 3 functions from each seminar.
Sem 2.xlsx (topic "Math")
Sem 3.xlsx (topic "Charts")
Sem 4.xlsx (topic "Basic Lookups")
Sem 5.xlsx (topics "Advanced lookups and Advanced filtering and copy-pasting")
Sem 6.xlsx (topic "Finance")
Sem 7.xlsx (topics "What-if analysis and consolidation")
Sem 8.xlsx (topics "Date&Time, CHOOSE, OFFSET")
Big_HW_RS2021_solved_full.xlsx
Module 4:
Sem 9.xlsx (topic "Basic pivot tables")
Sem 10.xlsx (topic "Multiple pivot tables")
Sem 10 EXTRA.xlsx (topic "Pivot table summary")
Sem 11 (1).xlsx(topic "Pivot wizard and Power query")
Sem 11 (2).xlsx(topic "Getpivotdata")
Sem 11 (3).xlsx(topics "Formula Dependence" , "Information Functions" and "Forecasting")
Sem 12.xlsx (topic "Basic macro and VBA