Question 1 - In Dates sheet (7 points):

Question 2 - In Dates sheet (7 points):

Question 3 - In Time sheet (7 points):

Question 4 - In String sheet (9 points): In column A list of Emails. All Emails belong to the " domain. In some cases, the "@" is missing. Calculate using string functions column B the fixed Emails.

Question 5 - In Data Table sheet (8 points):

Question 6 - In Macro sheet (9 points): For the next macro "run" it manually (with pen and paper). The macro relates to Macro sheet. Write in "I2" - What the macro is performing, explain what and how? (without translation the Visual Basic). Write, starting in "I14" the first-row output only.

Use Date functions to calculate columns B to F.

In row 2 you have an example how the data should like.

Use data validation for cells K2:K400 make sure that the difference between any two consecutive cells is only one day - no more, no less.

Calculate in column E the "Ok / Error" column: if the person worked more than 24 hours or the result is negative then write "Error", otherwise write "OK".

Create a Data Table, based on the model starting in C2, with 2 dimensions. Dimension 1: Years between 5 to 15.

Dimension 2: Rate is between 4% to 8% (4%, 4.25%, 4.5%...). Create the data table for the monthly payment (Cell D5) starting in cell B8.

Question 7 - In Macro sheet (9 points): Write a macro: That will run on Q2:Q400, - name it AddYear. The Macro will add one year to every date in column Q. Create a button for this macro "Add year". Every time you run the macro the dates will be advanced, by one year.

Question 8 - In Finance sheet (9 points): You invested your money (100,000$) in the next program rate is 1% per month for 1 year = 12 periods. After 6 months (6 payments), the rate you can get today is 2% per month. If you withdraw your money before the 1 year period then you get your money back (100,000$) with no interest at all. What is your financial recommendation: keep the money in the first program or withdraw your money and switch to the 2% for 6 months ahead