Download the file sales_data.xlsx and complete the following task. Open the file and save it as...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Download the file sales_data.xlsx and complete the following task. Open the file and save it as a Macro Enabled Workbook (file extension .xlsm). Name this spreadsheet with your network login followed by 104.xlsm. For example, if your network login was barn4520, then the file should be named barn4520_104.xlsm. Remember to save your work frequently in case there are problems. 1. In the given file, write a subroutine that adds a worksheet named Formula List after the original worksheet, and then goes through the original worksheet hunting for cells with formulas. Each time it finds a formula, it records information about it in a new row of the Formula List worksheet. Specifically, it records the worksheet's name in column A, the formula as a string in column B, and the formula's value in column C. Hints: o To check whether a cell contains a formula, use the range property Has Formula. o To check all the cells that are being used, use of the worksheet property UsedRange. o To write a formula into a cell as a string, put an apostrophe () in front of the string when you write it to the cell as a value. For example, to make the formula appear in a cell instead of Excel trying to execute the formula, I could type '=sum(A3:A6) into the cell. o To add a worksheet to the end of the list of worksheets you could use the following statement: Set ws New = Worksheets.Add(after: Worksheets (Worksheets.count)) O To automatically make columns fit the widest text they contain, use the Autofit property. wsNew. Range("A:C").Columns.AutoFit Note You have to use Button(s) on worksheet(s) to run the task(s) in this lab and all next labs. Marks will be deducted if you do not use Buttons A Region 1 2 3 4 Jan 5 Feb 6 Mar 7 Apr 8 May 9 Jun 10 Jul 11 Aug 12 Sep 13 Oct 14 Nov 15 Dec 16 7 Totals: 18 Average: 9 B $ $ $ $ $ D Product 1 Product 2 Product 3 Product 4 $ $ 3,845.00 $ 4,224.00 $ $ 3,487.00 $ 1,561.00 $ 2,614.00 $ 2,411.00 3,487.00 $ 2,761.00 $ 1,537.00 $ 1,600.00 3,647.00 $ 4,045.00 4,841.00 $ 1,680.00 1,165.00 $ 3,943.00 2,893.00 $ 4,869.00 1,270.00 $ 2,372.00 3,299.00 $ 1,204.00 2,127.00 $ 1,553.00 $ 2,095.00 $ 2,233.00 $ 1,911.00 $ 3,633.00 $ 1,366.00 $ 2,410.00 $ 2,167.00 $ 2,120.00 $ E $ 1,338.00 $ 2,761.00 $ 2,875.00 $ $ 4,817.00 $ 3,250.00 $ 2,802.00 $ 1,217.00 1,160.00 $ 1,559.00 $ 3,119.00 $ 2,334.00 $ 4,747.00 $ 1,497.00 $ 3,445.00 $ 4,254.00 $ 3,920.00 $ 32,462.00 $ 30,304.00 $ 33,531.00 $ 33,168.00 $ 2,705.17 $ 2,525.33 $ 2,794.25 $ 2,764.00 F G Sum $ 10,073.00 $ $ 9,385.00 $ $ 15,761.00 $ $ 10,201.00 $ $ 9,436.00 $ $ 12,083.00 $ $ 8,641.00 $ $ 8,790.00 $ $ 8,191.00 $ $ 12,029.00 $ $ 11,759.00 $ $ 13,116.00 $ H Average 2,518.25 2,346.25 3,940.25 2,550.25 2,359.00 3,020.75 2,160.25 2,197.50 2,047.75 3,007.25 2,939.75 3,279.00 $ 129,465.00 $ 10,788.75 $ 2,697.19 K Download the file sales_data.xlsx and complete the following task. Open the file and save it as a Macro Enabled Workbook (file extension .xlsm). Name this spreadsheet with your network login followed by 104.xlsm. For example, if your network login was barn4520, then the file should be named barn4520_104.xlsm. Remember to save your work frequently in case there are problems. 1. In the given file, write a subroutine that adds a worksheet named Formula List after the original worksheet, and then goes through the original worksheet hunting for cells with formulas. Each time it finds a formula, it records information about it in a new row of the Formula List worksheet. Specifically, it records the worksheet's name in column A, the formula as a string in column B, and the formula's value in column C. Hints: o To check whether a cell contains a formula, use the range property Has Formula. o To check all the cells that are being used, use of the worksheet property UsedRange. o To write a formula into a cell as a string, put an apostrophe () in front of the string when you write it to the cell as a value. For example, to make the formula appear in a cell instead of Excel trying to execute the formula, I could type '=sum(A3:A6) into the cell. o To add a worksheet to the end of the list of worksheets you could use the following statement: Set ws New = Worksheets.Add(after: Worksheets (Worksheets.count)) O To automatically make columns fit the widest text they contain, use the Autofit property. wsNew. Range("A:C").Columns.AutoFit Note You have to use Button(s) on worksheet(s) to run the task(s) in this lab and all next labs. Marks will be deducted if you do not use Buttons A Region 1 2 3 4 Jan 5 Feb 6 Mar 7 Apr 8 May 9 Jun 10 Jul 11 Aug 12 Sep 13 Oct 14 Nov 15 Dec 16 7 Totals: 18 Average: 9 B $ $ $ $ $ D Product 1 Product 2 Product 3 Product 4 $ $ 3,845.00 $ 4,224.00 $ $ 3,487.00 $ 1,561.00 $ 2,614.00 $ 2,411.00 3,487.00 $ 2,761.00 $ 1,537.00 $ 1,600.00 3,647.00 $ 4,045.00 4,841.00 $ 1,680.00 1,165.00 $ 3,943.00 2,893.00 $ 4,869.00 1,270.00 $ 2,372.00 3,299.00 $ 1,204.00 2,127.00 $ 1,553.00 $ 2,095.00 $ 2,233.00 $ 1,911.00 $ 3,633.00 $ 1,366.00 $ 2,410.00 $ 2,167.00 $ 2,120.00 $ E $ 1,338.00 $ 2,761.00 $ 2,875.00 $ $ 4,817.00 $ 3,250.00 $ 2,802.00 $ 1,217.00 1,160.00 $ 1,559.00 $ 3,119.00 $ 2,334.00 $ 4,747.00 $ 1,497.00 $ 3,445.00 $ 4,254.00 $ 3,920.00 $ 32,462.00 $ 30,304.00 $ 33,531.00 $ 33,168.00 $ 2,705.17 $ 2,525.33 $ 2,794.25 $ 2,764.00 F G Sum $ 10,073.00 $ $ 9,385.00 $ $ 15,761.00 $ $ 10,201.00 $ $ 9,436.00 $ $ 12,083.00 $ $ 8,641.00 $ $ 8,790.00 $ $ 8,191.00 $ $ 12,029.00 $ $ 11,759.00 $ $ 13,116.00 $ H Average 2,518.25 2,346.25 3,940.25 2,550.25 2,359.00 3,020.75 2,160.25 2,197.50 2,047.75 3,007.25 2,939.75 3,279.00 $ 129,465.00 $ 10,788.75 $ 2,697.19 K
Expert Answer:
Answer rating: 100% (QA)
1 To add a subroutine that adds a worksheet named Formula List after the original worksheet and reco... View the full answer
Related Book For
Integrated Accounting
ISBN: 978-1285462721
8th edition
Authors: Dale A. Klooster, Warren Allen, Glenn Owen
Posted Date:
Students also viewed these programming questions
-
Let's say we wanted to incorporate force sensor data into our experiment. We were already using the eyebolt, let's say we first calibrated the force sensor and then did the exact same experiment but...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
In what significant way do financial audits in government and not-for-profit organizations differ from those carried on in businesses? Your answer should also address the purpose of performance...
-
Two fraternities, Sig Ep and Ep Sig, plan to raise money jointly to benefit homeless people on Long Island. They will sell Yoda vs. Alien T-shirts in the student center, but are not sure how much to...
-
If most countries adhered to a system of fixed exchange rates, global inflation would be lower. Do you agree or disagree? Why?
-
Place the following numbers correctly into the Venn diagram. -4 13.863 15 871 57 -3 N N R
-
Michael Carrigg, Inc., is disk manufacturer in need of an aggregate plan for July through December. The company has gathered the following data: Costs________________ Holding cost ...........
-
In 'fair assessment' fair does not mean equal , it means EQUITABLE . In order to better understand this, please read 'Equity for English-language learners', the article is included in this Uni...
-
Large central power stations (about 1000 MW electrical) using fluidized bed combustors may be built some day These giants would be fed 240 tons of coallhr (90% C, 10 % H2,), 50% of which would burn...
-
Describe the paths of water through the hydrologic cycle. Explain the processes and the energy gains and losses involved in the changes of water between its 3 states. Operationally, we often most...
-
1. a. What is the goal of the firm and, therefore, of all managers and employees? Discuss how one measures achievement of this goal. b. How do market forces-both shareholder activism and the threat...
-
If you want to have $12,000.00 in 3 years and 6 months, how much should you deposit today in an investment fund that is earning interest at a rate of 4.58% compounded quarterly? Round to the nearest...
-
Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate departments. Three support departments support the production departments: Power, General...
-
Company SLG is an exporter of retail fashion products from the U.S. to Italy, and has an account receivable of100,000 due 180-days from now. The spot rate is $1.34/ and the 180-day forward rate is...
-
The bank that you work for was just contacted by a customer. The customer wants to short a 6-month British Pound forward contract and wants a quote of the forward price. To come up with the price,...
-
Project financing is a financing technique in which large projects, such as infrastructure projects, natural resources projects, pipelines, energy explorations projects, and so on, are financed by a...
-
Apply Jacobis method to the given system. Take the zero vector as the initial approximation and work with four-significant-digit accuracy until two successive iterates agree within 0.001 in each...
-
Write the answers to the following questions in the space provided. Note: all the following questions relate to March 814. Register Reports 1. What is the total amount of purchase orders for the...
-
1. What is the total amount of purchase orders shown on the purchases orders register for the month of March? 2. What is the total of the Invoice Amount column shown on the Purchase Invoice Register...
-
If the statement is true, write a T in the space provided. If the statement is false, write F in the space provided. Only transactions that do not involve cash may be recorded in the General Journal...
-
2. YOU BE THE JUDGE WRITING PROBLEM An off-duty, out-of-uniform police officer and his son purchased some food from a 7-Eleven store and were still in the parking lot when a carload of teenagers...
-
3. You sign a two-year lease with a landlord for an apartment. The rent will be $1,000 per month. A clause in the lease requires payment on the first of every month. The clause states that the...
-
4. Federal antitrust statutes are complex, but the basic goal is straightforward: to prevent a major industry from being so dominated by a small group of corporations that they destroy competition...
Study smarter with the SolutionInn App