Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the workbook HW 1 . xlsx . Write some positive numbers in cells A 1 :A 2 0 of the worksheet Data. Assign the

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Summarize the naturenurture debate in psychology.

Answered: 1 week ago

Question

hangisi daha yksek ayrma enerjisine sahiptir F2 veya F2+?

Answered: 1 week ago

Question

Demonstrate three aspects of assessing group performance?

Answered: 1 week ago