Answered step by step
Verified Expert Solution
Link Copied!

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 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.
image text in transcribed

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

Navigating The Supply Chain Maze A Comprehensive Guide To Optimize Operations And Drive Success

Authors: Michael E Kirshteyn Ph D

1st Edition

B0CPQ2RBYC, 979-8870727585

More Books

Students also viewed these Databases questions

Question

5. Identify and describe nine social and cultural identities.

Answered: 1 week ago

Question

2. Define identity.

Answered: 1 week ago

Question

4. Describe phases of majority identity development.

Answered: 1 week ago