-Use a conditional format to highlight the Amount over $300 with Light Red Fill a Dark...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
-Use a conditional format to highlight the Amount over $300 with Light Red Fill a Dark Red Text. 0. Add a Total row to the table and calculate the Average for Amount field. Chan the label for the Total row from Total to Average. 11. Copy the field names in the range A6:E6 to the range A2:E2, and make sure ro has the same formatting as row 6. This establishes the criteria for advanced filter a. Use AND criteria to select Green Segment that has Amount greater than $100.1 b. Use advanced filtering to copy the filtered results to a new location within same worksheet starting-in-cell-H6. 12. On the Subtotals worksheet, convert the data to a range and then sort the rang by Segment. Create Subtotals that calculate the subtotal for each Segment under the Amount- column. < Display only the subtotal and Grand Total results. 13. On Request Form worksheet, use VLOOKUP function in the Description and Cost column to retrieve the Description and Cost from the range H8:J12. Use appropriate cell-referencing to allow your formula to be copied. 14. Calculate Total (Qty Service Cost), Subtotal, Tax Amount-and-Grand-Total. 15. Save and close your file and submit it to the Dropbox. -Use a conditional format to highlight the Amount over $300 with Light Red Fill a Dark Red Text. 0. Add a Total row to the table and calculate the Average for Amount field. Chan the label for the Total row from Total to Average. 11. Copy the field names in the range A6:E6 to the range A2:E2, and make sure ro has the same formatting as row 6. This establishes the criteria for advanced filter a. Use AND criteria to select Green Segment that has Amount greater than $100.1 b. Use advanced filtering to copy the filtered results to a new location within same worksheet starting-in-cell-H6. 12. On the Subtotals worksheet, convert the data to a range and then sort the rang by Segment. Create Subtotals that calculate the subtotal for each Segment under the Amount- column. < Display only the subtotal and Grand Total results. 13. On Request Form worksheet, use VLOOKUP function in the Description and Cost column to retrieve the Description and Cost from the range H8:J12. Use appropriate cell-referencing to allow your formula to be copied. 14. Calculate Total (Qty Service Cost), Subtotal, Tax Amount-and-Grand-Total. 15. Save and close your file and submit it to the Dropbox.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
In this project, you will update a workbook to display bank transactions as a PivotTable. You will filter the PivotTable, format the values, display the values as calculations, and create a...
-
MW Canada developed a 90-hour technical training program that was delivered over two months. Because it enabled the loom mechanics to act more independently with less downtime if the total cost was...
-
Fill in the blanks 1. sin 2u = ______ 2. cos 2u = ______ 3. sin u cos v = ______ 4. 1 --- cos 2u / 1 + cos 2u = __________ 5. sin u / 2 =____________ 6. cos u cos v = ______
-
Compute Income Measures Presented below is information related to Viel Company at December 31, 2010, the end of its first year of operations. Sales revenue...................... 310,000 Cost of goods...
-
What is a say-on-pay vote?
-
Wollongong Group Ltd, of New South Wales, Australia, acquired its factory building about 10 years ago. For several years the company has rented out a small annex attached to the rear of the building....
-
a) Explain the following accounting concepts: i. Business entity Revenue realization ii. Accruals iii. iv. V. Substance over form Conservatism vi. Going concern (6 Marks) b) Classify the following...
-
GUI Assignment You will be creating a seating arrangement application using JavaFX. The project will comprise of two sections: the interface and the Java code. The application will feature a 3x3...
-
Question 1 : from the graphs on the top Take a screenshot of the scatter plot showing Relative Compactness versus Heating Load. Look closely at the various orientation plots. Explain why orientation...
-
What are Saturn's rings does geyser activity on Enceladus contribute toward?
-
Complete the following methods with the given signatures. All user input and output must occur in your main method. For this program, you may use Scanner or JOptionPane. In your main method, display...
-
Which elements exhibit an ethereal, fantastical quality, reminiscent of the realm of dreams or the realm of imagination?
-
After-tax Salvage Value Year 5-year 1 23 20.00% 32.00% 19.20% 4 11.52% 5 11.52% 6 5.76% The Honey Bee Co. purchased some equipment three years ago at a cost of $36,500. The equipment is 5-year...
-
On March 1, 2021, Planet Co. acquired 80% of Star Corp's outstanding common shares for $3,600,000. On the date of acquisition, the book value of Star Corp's net assets was $3,850,000. Book value...
-
Note: This problem is for the 2019 tax year. Lance H. and Wanda B. Dean are married and live at 431 Yucca Drive, Santa Fe, NM 87501. Lance works for the convention bureau of the local Chamber of...
-
QUESTION 9 HC-O-C-R R-C-O-CH HC-O-P-O-CH-CH-NH3* O || O a. Phosphatidic acid, Serine O b. Lysophosphatidic acid, Serine, Free FA O c. Lysophosphatidylserine, Free FA O d. 2 Free FAs, Serine, Glycerol...
-
The Fitz Bookzzz Company currently sells its products, childrens books, through multiple distribution channels. It sells subscriptions that provide children with a box every month containing an...
-
Think of a business or an organization that would use process costing. What types of waste are likely to be generated during the manufacturing process? Are there ways to avoid this waste or minimize...
-
What are the four ethical standards in the Institute of Management Accountants Statement of Ethical Professional Practice? Describe the meaning of each of the four standards. How does each of these...
-
Why is it said that the PSNR principle has both a right and a duty side? Which one is most relevant with respect to international environmental law?
-
What, if any, is the normative content of the concept of SD?
-
Analyse the difference between the principle of prevention and precaution. Is it the same?
Study smarter with the SolutionInn App