1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
nataly862011 [7]
3 years ago
15

A. Using the properties window in the VBA editor assign the code name wsEx2 to the sheet with tab name Problem2.

Engineering
1 answer:
Mama L [17]3 years ago
6 0

Answer:

VBA CODE:

Sub wxEx2()

'''''' Question b''''''''

' Making the sheet active

wsEx2.Activate

'''''' Question c''''''''

' Setting range

Dim r1, Scores As Range

Set r1 = Sheets("Problem 2").Range("A2:A10")

'''''' Question d''''''''

' Set range Scores

Set Scores = Sheets("Problem 3").Range("B6:B14")

'''''' Question e''''''''

' Weighted average

Dim val As Double

Sheets("Problem 2").Range("A12").Value = Application.WorksheetFunction.SumProduct(r1, Scores) / Application.WorksheetFunction.Sum(Scores)

'''''' Question f''''''''

' Chane background color

Sheets("Problem 2").Range("A12").Interior.ColorIndex = 4

'''''' Question g''''''''

' Make italic bold

Sheets("Problem 2").Range("A12").Font.Bold = True

Sheets("Problem 2").Range("A12").Font.Italic = True

End Sub

You might be interested in
List the main activities of exploration??
Trava [24]

Answer:  Exploration includes plethora of activities and depend upon the kind  of exploration a person is doing. But most include some of the basic activities like research , investigation, planning and execution.

Suppose we want to explore new petroleum sites then we would have to start with studying the geography of that area, then according to our research we will analyse the hot spots or the sector where probability of finding of oil field is highest, post that appropriate man power is skilled professionals, tools and machinery will be brought at the site so that execution can take place.

3 0
3 years ago
The enforcement of OSHA standards is provided by federal and state
Gnoma [55]

Answer:

Explanation:

Enforcing OSHA, Occupational Safety and Health Administration, standards is not a job for electricians, lawmakers or tax collectors. The right answer is safety inspectors.

3 0
2 years ago
4. Water vapor enters a turbine operating at steady state at 1000oF, 220 lbf/in2 , with a volumetric flow rate of 25 ft3/s, and
hodyreva [135]
Yes i is the time of the day you get to frost the moon and back and then you can come over and then go to hang out with me me and then go to hang out
6 0
4 years ago
Consider a 2-shell-passes and 8-tube-passes shell-and-tube heat exchanger. What is the primary reason for using many tube passes
Maru [420]

Answer:

See explanation

Explanation:

Solution:-

- The shell and tube heat exchanger are designated by the order of tube and shell passes.

- A single tube pass: The fluid enters from inlet, exchange of heat, the fluid exits.

- A multiple tube pass: The fluid enters from inlet, exchange of heat, U bend of the fluid, exchange of heat, .... ( nth order of pass ), and then exits.

- By increasing the number of passes we have increased the "retention time" of a specific volume of tube fluid; hence, providing sufficient time for the fluid to exchange heat with the shell fluid.

- By making more U-turns we are allowing greater length for the fluid flow to develop with " constriction and turns " into turbulence. This turbulence usually at the final passes allows mixing of fluid and increases the heat transfer coefficient by:

                                U ∝ v^( 0.8 )    .... ( turbulence )

- The higher the velocity of the fluids the greater the heat transfer coefficient. The increase in the heat transfer coefficient will allow less heat energy carried by either of the fluids to be wasted ; hence, reduced losses.

Thereby, increases the thermal efficiency of the heat exchanger ( higher NTU units ).

5 0
3 years ago
Motor oil is responsible for
Lelechka [254]

Answer:

lubricating all moving parts in the engine

Explanation:

like the pistons, pushrods, and the crank

5 0
3 years ago
Other questions:
  • Write the following decorators and apply them to a single function (applying multiple decorators to a single function): 1. The f
    15·1 answer
  • What is the magnitude of the maximum stress that exists at the tip of an internal crack having a radius of curvature of 2.5×10-4
    13·1 answer
  • Two parts are to be assembled in a way that if one part fails, the entire assembly fails. Each of the parts have undergone exten
    15·1 answer
  • A single-phase inductive load draws a 10 MW at 0.6 power factor lagging. Calculate the reactive power of a capacitor to be conne
    14·1 answer
  • 6. What symptom will be exhibited on an engine equipped with a pneumatic governor system if the cooling fins
    14·1 answer
  • It is the tool used to measure the amount of electric current​
    6·2 answers
  • BIG POINTS AND WILL GIVE BRAINLIEST! Answer all 5 please or I can’t give brainliest and might report!
    10·1 answer
  • A solid cylindrical workpiece made of 304 stainless steel is 150 mm in diameter and 100 mm is high. It is reduced in height by 5
    12·1 answer
  • (35-39) A student travels on a school bus in the middle of winter from home to school. The school bus temperature is 68.0° F. Th
    13·1 answer
  • 3.8 LAB - Select lesson schedule with multiple joins
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!