Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started