Referencing & Names [10 Points] The table below shows values for two different physical quantities: Mass and Acceleration: Quantity Quantity Quantity 3 (Quantity 1'Quantity 2VQuantity3 15 40 75 85 10 20 40 75 59090 90 90 Type in the data as is in a worksheet, and name worksheet "Sheet1". worksheet Sheet1" as scope of these variables. Evaluate the values for the last column using R1CI relative notation. 3p. Define the names of three columns: "Quantity 1", "Quantity 2", and "Quantity 3". Set IV Recording Macros & Functions/Formulas [20 Points Record macros that does the functions provided below (each macro should be assigned a Form button) Randomly generate a number according to Uniform distribution between 0 and 1 and save it to celr A Randomly generate a number according to Uniform distribution between 0and 20and save it to Randomly generate a number according to Standard normal distribution 1 and save it to cell Randomly generate a number according to normal distribution with mear 10 and standard Evaluate the Sine and Cosine of a given angle provided in cell "AS", and saving it to cells "B5 4L deviation 3.1 and save it to cell "A4 and "B6", respectively. lb 1 Page 4 of 5 Referencing & Names [10 Points] The table below shows values for two different physical quantities: Mass and Acceleration: Quantity Quantity Quantity 3 (Quantity 1'Quantity 2VQuantity3 15 40 75 85 10 20 40 75 59090 90 90 Type in the data as is in a worksheet, and name worksheet "Sheet1". worksheet Sheet1" as scope of these variables. Evaluate the values for the last column using R1CI relative notation. 3p. Define the names of three columns: "Quantity 1", "Quantity 2", and "Quantity 3". Set IV Recording Macros & Functions/Formulas [20 Points Record macros that does the functions provided below (each macro should be assigned a Form button) Randomly generate a number according to Uniform distribution between 0 and 1 and save it to celr A Randomly generate a number according to Uniform distribution between 0and 20and save it to Randomly generate a number according to Standard normal distribution 1 and save it to cell Randomly generate a number according to normal distribution with mear 10 and standard Evaluate the Sine and Cosine of a given angle provided in cell "AS", and saving it to cells "B5 4L deviation 3.1 and save it to cell "A4 and "B6", respectively. lb 1 Page 4 of 5