You must manually create a data table as shown in Table 2 into worksheet "Prob2". You should format the cells manually (i.e., not via code) in Excel. The upper left corner of Table 2 (i.e., the label "Container Type") should be entered in cell B2. Note that the worksheet “Prob2” does not display gridlines.
Table 2. Data for Problem 2.
SOLUTION REQUIREMENTS
Write a sub procedure named Sort_by_Embodied that will:
Use the End property of the Range object to copy and paste the data in Table 2 one row at a time. The upper left corner of the copied data (i.e., the label "Container Type") should be pasted in cell B10.
Sort the data in the copy of Table 2 numerically in ascending order based on the values shown in the column labeled “Embodied Energy” (use the Sort method of the Range object).
Use the Rows property of the Range object to give every other row in the sorted copy of Table 2 its own background color. You are at liberty to pick the color.
Ensure that no revolving border remains after executing any copy-pasting operations.
Ensure that no flickering occurs when you run your sub procedure.
End the sub procedure by selecting cell A1.
Assign the sub procedure Sort_by_Embodied to a rectangular shape button. The caption of the rectangular shape button should read “Sort by Embodied Energy”. The rectangular shape button should be visually appealing and its upper left corner should be aligned with the upper left corner of cell H2.
Write a sub procedure named Clear_Table that will clear the range B10:F15.
Assign the sub procedure Clear_Table to a rectangular shape button. The caption of the rectangular shape button should read “Clear”. The rectangular shape button should be visually appealing and its upper left corner should be aligned with the upper left corner of cell K5.
You must manually create a data table as shown in Table 2 into worksheet "Prob2". You...
You are the systems manager for Blue City Movies Rentals and you have been asked to create a report on historical sales data. To complete your task you will combine and edit data from multiple sources using Excel’s Power add-ins, XML, and text functions.Instructions:For the purpose of grading the project you are required to perform the following tasks:StepInstructionsPoints Possible1Open e10c2MovieRentals.xlsx and save the workbook with the name e10c2MovieRentals_LastFirst.02Import the movie data from the delimited file e10c2Movies.txt and rename the new worksheet Inventory.Hint: On the Data tab,...
spreadsheet and data base managment File Edit Insert Table Format Arrange View Share Window Help Target's Monthly Stock Prices T - Chart Text Shape Media 125 zoom Insert Table Questions Data Finish the following technical steps in the EXCEL workboek and upload your file for grading 1. Add a new worksheet in your EXCEL workbook, rename this worksheet as Documentation and then input your full name in the Al cell, and input the test date in the A2 cell (10...
2. The following data show the number of cars that arrived at a Tim-Hortons drive-through between 10:00 AM and 11:00 AM each Monday for the past 50 weeks: 1 6 5 4 2 7 5 3 4 5 3 6 6 9 6 8 4 3 3 1 2 3 3 5 7 3 4 4 2 1 8 3 3 3 5 2 8 2 5 3 6 1 1 5 8 3 2 2 5 4 (a) Construct...
2 Use Excel to find the following confidence intervals 110points total The feollowing data show the namber of paid vacation days for a random sample of 20 employees from PSU A1 a) Find the 95% confidence interval fr the average number of vacation days. (2 points for output. I point fr ower limit, I point for upper limit Copy the data below your name in cell A3 in Excel. Select the tab labeled Duta, then select Data Analysis If your...
2. Let's now use Excel to simulate rolling two 6-sided dice and finding the minimum of both dice. • Create a new Excel sheet in your document. Click on cell Al, then click on the function icon f. and select Math&Trig, then select RANDBETWEEN. In the dialog box, enter 1 for bottom and enter 6 for top. • After getting the random number in the first cell, click and hold down the mouse button to drag the lower right corner...
Question 9 and 10 a. 9. Switch to the Discounted Price worksheet. Because Anita wants this PivotTable to focus on customers, reorder the fields in the Rows area so the PivotTable displays data first by Customer and then by Order Number. 10. Anita is interested in the performance of the Midwest region. Filter the PivotTable to display orders from the Midwest in June and August, which were the most popular months for spice pack orders, as follows: Use the Region...
EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.6 Project Description:You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your new position, you have decided to compile a report that details all aspects of the business, including: employee tax withholding, facility management, sales data, and product inventory. To complete the task, you will duplicate existing formatting, utilize various conditional logic functions, complete an amortization table with financial functions, visualize data with PivotTables, and lastly...
microbiology help TOT Zoo Add Page Insert Table Chart Text Shape Media Comment These questions will serve in lieu of a lab report for Exercise 15, 16, and 17 You will find the answer to these questions in the background, procedure, results and interpretation sections of manual Exercise 15, 16, and 17, videos, Actions of Selective and Differential Media Chart, and the Principle/Theory article in homework section.) General Questions 1. What is the purpose (function) of selective media? (How does...