Comparing Televisions

 

Start with a new spreadsheet in Microsoft Excel online or installed version of Microsoft Excel with no template applied. A template is not allowed for assignment.
NOTE: You will not need to use files from the textbook for the assignment
Apply your creative thinking and problem-solving skills to design and implement a solution.
Part 1:
You are shopping for a new television and want to compare the prices of three televisions. Research new televisions.
• Create a worksheet that compares the type, size, and the price for each television, as well as the costs to add an extended warranty.
• Use the concepts and techniques presented in this Excel module 1 to calculate the average price of a television and average cost of an extended warranty and to format the worksheet.
• Include a chart to compare the different television costs.
Part 2:
Based upon the data you found, how could you chart the information to show the comparisons? Which chart would be the best to use? Answer these questions in comments or submission text area when submitting..
Save the file as CS155Week4lastnamefirstname. Ensure that you use your lastname and firstname in the filename.
The following areas will be part of grading criteria:
• Descriptive title, subtitle, and headings
• Data included
• Type, size, and price of each television included
• Average function used to average price of televisions
• Average function used to average cost of extended warranty
• Total for television and extended warranty for each using sum function
• Total results formatted as currency displaying $ symbols
• Sheet formatted
• Columns adjusted so that text is not cut off, and excess space is minimized
• Chart type appropriate for data it represents
• Chart title is descriptive of contents
• Chart formatted so that data makes sense and is easy to read
• Part 2 questions answered
• Correct filename

Sample Solution

ent on how the public authority arranges its withdrawal, it will make everything from acquirement to recruiting staff tricky and will inescapable log jam the development business until it privileges itself. Acquisition pioneers expressed “Ecological strategies the UK took on as a component of the EU are in danger of being compromised, and numerous earthy people have voiced worries over the pessimistic result Brexit will have on the advancement of manageability in the inventory network. Brexit will prompt momentary financial plan cuts for some, organizations working inside the UK, this will undoubtably make associations cut their CSR financial plan regardless of whether the long haul is fundamental.

It is key that we utilize feasible administrations in the development business as of now the development business contributes unimaginably huge rates, 23% of the universes air contamination, half of environmental change, 40% defilement of drinking water, and half towards topping off landfills all over the planet. It is clear that the business as the need might arise to take care of this as it’s inevitable before it’s past the point of no return.

I felt that it was critical to not simply center my time in investigating one association as then my exposition would be inclination towards their objectives however I likewise needed to take a gander at an association that is significantly more centered around refining the unrefined substances as then I take care of all parts of the development interaction. Normally this drove me to taking a gander at organizations that produce concrete and total based items like the LafargeHolcim. LafargeHolcim have critical information on the subject of maintainable development, it could sound inconsistent as they are one of the main organizations in delivering concrete based items, yet they are moving towards a substantially more reasonable standpoint. They concur that to accomplish long haul improvement of the form climate you need to investigate refining each piece of the business and controlling it such that favors supportability. To arrive at this they have 17 manageable improvement objectives – among them is utilizing their income created from selling their items they put into developing business sectors that plan to be economical – this will assist with counterbalancing the adverse consequences brought about by delivering concrete and total based items as these are extremely destructive for the climate all alone. An illustration of an undertaking that they put resources into would be ‘Metropolitan public travel’ where LafargeHolcim was a significant partner in bringing the ultralight tramway line to Casablanca (2012). LafargeHolcim helped towards causing the city to become greener. They additionally give their own answers for add to the possibility of feasible development connected with energy and regular assets, they are offering answers for mining, settling soil and treating corrosive water. This demonstrates that they are likewise attempting to target manageability inside their own particular market. LafargeHolcim express that “Foundation is can be innately economical” this is because of the additional venture going into sustainable power and transportation in urban communities. They express that we really want to think about supportability over the life expectancy of a venture (“support to grave”), so they have carried out groups towards focusing on this subsidizing.

Driving on from this one of the central issues of this paper is to give

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.