Question: Exerdse 3 [ 2 5 Points ] Consider the workbook HW 1 . xlsx . Write some positive numbers in cells A 1 :A 2

Exerdse 3[25 Points]
Consider the workbook HW1.xlsx. Write some positive numbers in cells A1:A20 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 A1:A20 of the worksheet Data and write the results in cells B1, B2 and B3 of the worksheet Results
Write the labels Sum, Mean, Standard Deviation in the cells A1, A2 and A3, respectively of the worksheet Results
Computes the square root of the value in cell A1 of the worksheet Data and writes the result in cell B1
Computes the natural log of the value in cell A1 of the worksheet Data and writes the result in cell C1 Displays in a message box the name and the path of the active workbook in two different lines.
 Exerdse 3[25 Points] Consider the workbook HW1.xlsx. Write some positive numbers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!