statics excel homework

please only accept if you have the knowledge in excel and statics

provided below are the questions and data

some examples from the lecture are also included