Question: Exerdse 3 [ 2 5 Points ] Consider the workbook HW 1 . xlsx . Write some positive numbers in cells A 1 :A 2
Exerdse Points
Consider the workbook HWxlsx Write some positive numbers in cells A:A of the worksheet Data. Assign the CodeName wsResults to the spreadsheet Results. Assume that none of the two worksheets is the active worksheet. Write a subroutine which:
Computes the sum, mean, and standard deviation of the numbers in the cell A:A of the worksheet Data and write the results in cells B B and B of the worksheet Results
Write the labels Sum, Mean, Standard Deviation in the cells A A and A respectively of the worksheet Results
Computes the square root of the value in cell A of the worksheet Data and writes the result in cell B
Computes the natural log of the value in cell A of the worksheet Data and writes the result in cell C Displays in a message box the name and the path of the active workbook in two different lines.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
