Question
'a. Using the properties window in the VB editor assign the code name wsEx2 to the sheet with tab name Sheet1. 'b. Using VBA code
'a. Using the properties window in the VB editor assign the code name wsEx2 to the sheet with tab name Sheet1. 'b. Using VBA code and the code name for worksheet Sheet1, make this worksheet the active sheet. 'c. Declare a range variable and assign to this variable the range from A2 to A10 in the worksheet Sheet1. 'd. Write VBA code to create a range name and call it Scores. 'This range name should refer to the range B6 to B14 in the worksheet labeled Sheet2 'e. Write VBA code that uses an Excel worksheet function that calculates the weighted average score (i.e., ' the dot product of the range defined in part c. and the range in part d. and place the calculated value in cell A12 of the Sheet1 worksheet. 'f. Using VBA code change the background color of cell A12 to green. 'g. Using VBA code change the font type in cell A12 to italic and bold. 'h. Using VBA code change the format property of cell A12 so that it is displayed as a number with exactly three digits to the right of the decimal point and at least three digits to the left of the decimal point.
Home se Draw Page Layout Formulas Data Share 12 List Bo Check Box O Optior Spinne Aa Label Macros wa] Group Box Visual BasicRecord MacroAdd-ins Excel Combo Box Scroll Bar- Add-ins D5 Weights 22.28% 13.48% 4.28% 7.20% 21.98% 8.03% 3.44% 15.49% 3.81% 3 4 51 6 7 9 10 12 Sheet1 Sheet2 tr HomeInsert Draw Page Layout Formulas Data Aa Label Macros Group Box Combo Box /1 Check Bo Scroll Bar Add-ins Excel Visual Basic o Record Macro Add-ins C3 Scores 80 51 46 64 48 78 10 12 13 14 15 16 17 18 19 20 21 67 23 24 25 Sheet Sheet2Step 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