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:
![Download the file sales_data.xlsx and complete the following task. Open the file and save it as a Macro](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/answers/2023/10/6523a7f9c8c76_5776523a7f9c348a.jpg)
![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](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/answers/2023/10/6523a7fa72560_5786523a7fa6c16b.jpg)
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...
-
Metro Services Company had the following transactions during the month of September: Sept. 2. Issued Invoice No. 201 to Triple Play Corp. for services rendered on account, $380. 3. Issued Invoice No....
-
On a violin, a correctly tuned A string has a frequency of 440 Hz. If an A string produces sound at 450 Hz under a tension of 500 N, what should the tension be to produce the correct frequency?
-
If the elimination of volatile cash flows through risk management techniques does not significantly change a firm's expected future cash flows and WACC, investors will be indifferent to holding a...
-
Millbridge Hospital buys its supplies in bulk and has recently switched vendors. The first purchase Millbridge made was for 500 boxes of gauze at $3.46 a box. The purchase had payment terms of 2/15...
-
Solve the following equations (solve for y if possible!) : (2xy3 + 1)dx + (3x2y2 -y-1)dy = 0
-
The Ploughman family owns and operates a 640-acre farm that has been in the family for several generations. The Ploughmans always have had to work hard to make a decent living from the farm and have...
-
PortaCom manufactures personal computers and related equipment. PortaCom's product design group developed a prototype for a new high-quality portable printer. The new printer features an innovative...
-
Given its Internet base, can Amazon's success be easily duplicated by copying its Web materials? If so, why has Amazon been so dominant in recent years?
-
Assume the following information, i. Mexican one-year interest rate = 15 percent ii. U.S. one-year interest rate = 11 percent iii. If interest rate parity exists, what would be the forward premium or...
-
A particle with angle q = wt and [r] = ro e^ (b t) where w, ro and b are positive constants. Solve for the value of b such that r - component of the acceleration in polar coordinates is zero, i.e. ar...
-
A-What is the support department's allocation rate if estimated activity is the allocation base? B What is the support department's allocation rate if actual activity is the allocation base? CList...
-
Questions: You are BBBY's CEO, Steven Temares. It is April 2004 and you are about to decide what to do with the company's excess cash: - Keep it? - Pay it out and issue debt? You structure your...
-
Assets 2020 2019 Cash and marketable securities $33,551 $16,706 Accounts receivable 260,345 318,978 Inventory 424,029 352,880 Other current assets 41,461 30,052 Total current assets $759,386 $718,616...
-
An 8.0 kg crate is pulled 5.0 m up a 30 incline by a rope angled 18 above the incline. The tension in the rope is 120 N, and the crates coefficient of kinetic friction on the incline is 0.25. a. How...
-
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...
-
Identify all the cyclic subgraphs of Graph \(C\). Use Graphs \(A, B\), and \(C\). Graph A Graph B Graph C
-
Identify all the cyclic subgraphs of Graph \(B\). Use Graphs \(A, B\), and \(C\). Graph A Graph B Graph C
-
Draw four spanning trees of Graph \(C\) that each have only one edge with an endpoint at vertex \(u\). Use Graphs \(A, B\), and \(C\). Graph A Graph B Graph C
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App