Description
- Explain what principle you believe is the MOST essential in developing an input design, and justify your choice.
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Web design can be deceptively difficult, as it involves achieving a design that is both usable and pleasing, delivers information and builds brand, is technically sound and visually coherent.
Completion Status:
100%
Review
Review
Anonymous
I was having a hard time with this subject, and this was a great help.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
4 pages
User Access Policy
Information is an important asset of all organizations and hence the need for security. Information should be protected no ...
User Access Policy
Information is an important asset of all organizations and hence the need for security. Information should be protected not only from unauthorized ...
Assignment 3: Incident Response (IR) Strategic Decisions
Assignment 3: Incident Response (IR) Strategic DecisionsDue Week 6 and worth 75 pointsSuppose that you have been alerted o ...
Assignment 3: Incident Response (IR) Strategic Decisions
Assignment 3: Incident Response (IR) Strategic DecisionsDue Week 6 and worth 75 pointsSuppose that you have been alerted of a potential incident involving a suspected worm spreading via buffer overflow techniques, compromising Microsoft IIS Web servers. As the IR Team leader, it is your responsibility to determine the next steps.Write a two to three (2-3) page paper in which you:Explain in detail the initial steps that would need to be made by you and the IR team in order to respond to this potential incident.Construct a process-flow diagram that illustrates the process of determining the incident containment strategy that would be used in this scenario, and identify which containment strategy would be appropriate in this case, through the use of graphical tools in Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.Construct a process flow diagram to illustrate the process(es) for determining if / when notification of the incident should be relayed to upper management, and explain how those communications should be structured and relayed through the use of graphical tools in Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.Detail the incident recovery processes for the resolution of this incident.Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources. Your assignment must follow these formatting requirements:Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.The specific course learning outcomes associated with this assignment are:Summarize the various types of disasters, response and recovery methods.Develop techniques for different disaster scenarios. Use technology and information resources to research issues in disaster recovery.Write clearly and concisely about disaster recovery topics using proper writing mechanics and technical style conventions.
IT 212 DCG Advertising Company Expansion Discussion
CompetencyIn this project, you will demonstrate your mastery of the following competencies:Explain the functions between h ...
IT 212 DCG Advertising Company Expansion Discussion
CompetencyIn this project, you will demonstrate your mastery of the following competencies:Explain the functions between hardware and software in a networkDesign a simple networkDesign and implement a secure interconnected network in support of an organizationScenarioThroughout this course, you have been writing various reports as parts of Milestones One and Two for an advertising firm that is opening a new office in Fayetteville, NC.This mid-size advertising firm already has offices in Albany, NY, and Springfield, MA. The Albany headquarters is home to the executive team and 150 employees. The headquarters also stores the corporate data and is the corporate internet backbone. It hosts the IT department that centrally manages all LAN services, including the wireless LAN. The IT department also manages the wide area network (WAN) that connects the two offices via site-to-site virtual private network (VPN) tunnels. The Springfield office hosts about 50 employees. Approximately 50% of these employees are mobile, defined as traveling more than 80% of the time.To hire and retain the best talent, the firm allows employees to work from home. This removes the constraint that employees have to live within commuting distance from the firm’s offices. Remote and mobile employees are provided access to the corporate network via a VPN client. The VPN client requires employees to have access to reliable internet services to allow for effective collaboration across teams and for access to media content. The company provides all employees with a laptop with full disk encryption, data loss prevention (DLP), and antivirus software. The IT department manages all corporate laptops and has the ability to access all systems for support. This means that all laptops are centrally managed by the one IT department.Due to an increase in opportunities for expansion to new markets, the firm has embarked on an initiative to hire and train new college graduates for the company’s Future Vision program. Future Vision focuses on expansion beyond the regional northeast footprint. The initiative is to hire graduates into the marketing, finance, and IT departments. You were hired as part of the Future Vision program and have been working at this for a while now. You have spent a considerable portion of your avaliability troubleshooting and analyzing the organization’s computer network to keep it running smoothly. Your direct supervisor and lead network administrator have been very impressed with your skills and fast learning abilities.To determine whether you are ready to take on more responsibility, you have been asked for your input regarding the new Fayetteville, NC, office setup project. Your task is to conduct research on this area and deliver a report to the team with key considerations and recommendations for the setup of the network infrastructure. The Fayetteville office will be home to 50 employees, including the new executive vice president of sales and marketing. All the possible sites have offices located in an office building with access to fiber, cable, and T1 internet service providers. In addition to the standard network, the site must support live video teleconferencing calls with employees based at the other sites. It must also reliably send print jobs to billboard printers located in the company headquarters in Albany.DirectionsThe primary goal of the project is to consolidate your findings from Milestones One and Two and compose a succinct and complete solution that you will present to the firm’s executive leadership team about the type of network they should design and implement at the new location.It is recommended that you incorporate the feedback you received from your instructor on Milestones One and Two. You can use this feedback to succinctly refine your recommendations into a polished report.Specifically, the following areas must be addressed in the report for the project:I. Key ConsiderationsExplain your key considerations for the project.Explain the OSI stack in relation to a modern communications network and how it influenced your network design.Describe the important IP range considerations for a company of your size.Summarize, in your own language, the strategic goals of the company, and detail how the network solution you are presenting aligns with these goals.Remember that these key considerations were addressed in Milestone One:Communications media and mode of data transport for the new networkCommon network hardware components for this new locationIn addition, you can make relevant changes to your report based on your instructor’s feedback from Milestone One.II. LAN TopologyIn Milestone One, you described the LAN topology possibilities and the strengths and weaknesses.Provide your final revised solution for optimal support that may include any feedback from the instructor from previous milestones.III. Internet Service ProviderIn Milestone Two, you described the possible ISP solutions available to meet the needs of the company in its new location. The section was based on your research into actual providers at the Fayetteville, NC, location.This section should include an explanation as to how the chosen internet provider meets the business goals and objectives of the firm.Provide your solution, along with any feedback from the instructor.IV. Hardware and Software, Printer, and Bandwidth: In this section, you will include these additional parts from Milestone Two in your report. You can use your diagram from Milestone Two as a starting point for these three items.Explain your proposed hardware and software solutions to meet the needs of the new office location.Describe your printer configuration solutions to meet the distance printing needs of the new office location.This could include considerations for tracking devices, automating driver distribution, and controlling access.Explain your bandwidth and device solutions to meet the teleconferencing needs of the new office location.V. Potential Errors: In this section, you will discuss common network errors and how your proposed solution will minimize and address these issues.Based on your previous report, anticipate common network errors that the new location may encounter.Describe effective troubleshooting approaches to the errors you identified, such as problem isolation, trace routing, and pinging.Explain how these approaches would ensure the resolution of the errors. Be sure your response is specific to the business location.VI. Additional Considerations: In this section, you will make recommendations for industry standard documentation for ongoing network support.Identify options for network monitoring that includes maintenance for network hardware and software (for example, port scanning, interface monitoring, packet flow monitoring, etc.).Identify patch management options that will help acquire, test, and install multiple patches on existing applications.Describe how you will control inventory, including how to discover and track assets on your network.As you develop your work, continue to look back on and consider each of these key elements. Remember, writing is a process that unfolds over time, and it typically requires reconsideration and revision of key elements.What to SubmitTo complete this project, you must submit the following:Your report must be 3 to 5 pages in length. Use double-spacing, 12-point Times New Roman font, one-inch margins, and APA formatting.
SU Agile Release Planning Essay
AGILE RELEASE PLANNING
With the Agile project framework in place for your home improvement store’s e-commerce website (f ...
SU Agile Release Planning Essay
AGILE RELEASE PLANNING
With the Agile project framework in place for your home improvement store’s e-commerce website (from Week 6), you must now consider long-term and short-term planning for your project. In addition, the company has realized the importance of mobile devices, such as smart phones and tablets, and decided to extend the e-commerce effort to include these devices. Note: You may create and/or assume all necessary assumptions needed for the completion of this assignment.
Write a 5–6 page paper in which you define the release plan of your project. In your paper, you must:
Draw a diagram to highlight the product road map and product life cycle through the use of graphical tools in Visio or an open source alternative (such as Dia). Note: The graphically depicted solution is not included in the required page length.
Provide at least three iterations and no more than ten tasks related to development on mobile devices through the use of MS Project. Note: Submit a screenshot or image file that shows your work. The graphically depicted solution is not included in the required page length.
Speculate on the associated risks regarding the development on mobile devices and provide strategies to mitigate those risks.
Provide at least two examples of maintenance stories based on the context of the project.
Provide at least two examples of performance cards based on the context of the project.
Use at least three quality resources in this assignment. Note: Wikipedia and similar websites do not qualify as quality resources.
NYU Hothouse Purchase Worksheet Database and Advanced Excel Concepts Excel Task
Excel_7E_Loan_OptionsundefinedundefinedProject Description:undefinedIn this project, you will use a PMT function to calcul ...
NYU Hothouse Purchase Worksheet Database and Advanced Excel Concepts Excel Task
Excel_7E_Loan_OptionsundefinedundefinedProject Description:undefinedIn this project, you will use a PMT function to calculate a value and then use it in a two-variable data table. You will create named ranges and use them in formulas.undefinedSteps to Perform:undefined Step Instructions Points Possible 1 Open the file Excel_7E_Loan_Options.xlsx download with this project. 0 2 Display the Hothouse Purchase worksheet. In cell B5, insert the PMT function using the data from the range B2:B4—be sure to divide the interest rate by 12 multiply the years by 12 and display the payment as a positive number. 10 3 Click cell B5, and then use Goal Seek to change the amount of the loan so that the payment goal is 4200 Then, in cell A7, type Option #1 Reduce the Loan Use the Format Painter to apply the cell style from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 425000 to restore the original loan amount. If necessary, press ESC to cancel the moving border. 10 4 Click cell B5, and then use Goal Seek to change the period of the loan (of the original data) so that the payment is 4200 Then, in cell A13, type Option #2 Increase Years Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in cell B15 with two decimal places, and then in cell B3, type 10 to restore the original value. If necessary, press ESC to cancel the moving border. Click cell A1, and then Save your workbook. 10 5 Display the Payment Table worksheet, in the range A2:B4, enter the following row titles and data. (The Currency [0] cell style is already applied to cell B2.) Amount of Loan425,000 Period (months)120 Interest rate (per year)5.25% 8 6 In cell C8, type 60—the number of months in a 5-year loan. In D8, type 120—the number of months in a 10-year loan. Fill the series through cell H8. Apply Bold and Center to the range C8:H8. 8 7 Beginning in cell B9, enter varying interest rates in decrements of 0.5% beginning with 7.0% and ending with 3.5% If necessary, format all the interest rates with two decimal places, and then apply Bold and Center to the range B9:B16. 10 8 In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number. 10 9 Create a Data table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate. Copy the format from cell B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is closest to $4,200 per month. Click cell A1. 10 10 Display the Advertising Costs by Quarter sheet. Name the following ranges: B6:E9 Newspaper_Costs B10:E14 Digital_Costs B15:E16 Magazine_Costs B17:E17 Billboard_Costs Insert a new row 15. In cell A15, type Designer Podcasts In cell B15, type 1250 In cell C15, type 1525 In cell D15, type 1266 In cell E15, type 1604. 9 11 Display the Name Manager, click Digital_Costs, and then in the Refers to box, edit as necessary so that the end of the range is cell E15. Select the Billboard_Costs and then Edit the name to Signage_Costs Click cell A1, and then Save your workbook. 4 12 Display the Annual Advertising Costs sheet. In cell B5, type =sum(N and sum the values using the appropriate range name in the displayed list of functions. Repeat for the other named ranges. From the Formulas tab, in the Function Library group, use AutoSum to sum all the costs. Click cell A1, and then click Save. 6 13 At the bottom of the workbook window, right-click any sheet tab name, and then click Select All Sheets. With the four worksheets grouped, from the Page Layout tab, display the Page Setup dialog box, and then insert a Custom Footer in the left section that includes the file name. Click the Margins tab, and then center the worksheets Horizontally on the page. Click the Payment Table worksheet, and then set the Orientation of this sheet to Landscape. 4 14 Display Backstage view, click Show All Properties. On the list of Properties, in the Tags box, type payment table, advertising costs In the Subject box, type your course name and section number. On the left, click Save. 1 15 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Hothouse Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save and close the file, and then submit for grading. 0 undefined Total Points 100
Similar Content
social capitol
respond to statement below in 4 to 5 sentences about social capitolThe biggest or major resource to any project is human r...
Cumberland University Data Science and Big Data Analytics Discussion
This week's discussion centers around the concept of Blockchain. There is still much confusion regarding what Blockchain ...
Westcliff University TerraUSD and Security Breaches Questions
1)Research two recent security breaches published in the media that occurred through a network security flaw. Provide cita...
Please answer this discussion question on Inferential Stats in Decision Making with 2 replies to my peers as well
I WILL REQUIRE 2 PEER POSTS REPLIES ONCE YOU ANSWER BELOW TWO QUESTIONSWhat are the advantages and disadvantages of non-pr...
Assignment
Hello-looking for someone who can work on below task:https://assets.publishing.service.gov.uk/governmen...Above is an arti...
Pentagon Area Java Programming Exercises
...
Week 6 Assignment
In a situation where one needs to perform cluster analysis, it is very important that one does not only consider the non-z...
Functions
Difference between inline and regular functions and which is faster Inline functions are applied with classes, where the c...
Authentication Types.final
Authentication is employed while verifying a login to ensure the individual accessing the safeguarded information has auth...
Related Tags
Book Guides
Orphan Train
by Christina Baker Kline
Dracula
by Bram Stoker
Where'd You Go Bernadette
by Maria Semple
Unf*ck Yourself
by Gary John Bishop
The Subtle Art of Not Giving a F*ck
by Mark Manson
Fear - Trump in the White House
by Bob Woodward
The Sun Is Also a Star
by Nicola Yoon
The Catcher in the Rye
by J. D. Salinger
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
4 pages
User Access Policy
Information is an important asset of all organizations and hence the need for security. Information should be protected no ...
User Access Policy
Information is an important asset of all organizations and hence the need for security. Information should be protected not only from unauthorized ...
Assignment 3: Incident Response (IR) Strategic Decisions
Assignment 3: Incident Response (IR) Strategic DecisionsDue Week 6 and worth 75 pointsSuppose that you have been alerted o ...
Assignment 3: Incident Response (IR) Strategic Decisions
Assignment 3: Incident Response (IR) Strategic DecisionsDue Week 6 and worth 75 pointsSuppose that you have been alerted of a potential incident involving a suspected worm spreading via buffer overflow techniques, compromising Microsoft IIS Web servers. As the IR Team leader, it is your responsibility to determine the next steps.Write a two to three (2-3) page paper in which you:Explain in detail the initial steps that would need to be made by you and the IR team in order to respond to this potential incident.Construct a process-flow diagram that illustrates the process of determining the incident containment strategy that would be used in this scenario, and identify which containment strategy would be appropriate in this case, through the use of graphical tools in Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.Construct a process flow diagram to illustrate the process(es) for determining if / when notification of the incident should be relayed to upper management, and explain how those communications should be structured and relayed through the use of graphical tools in Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.Detail the incident recovery processes for the resolution of this incident.Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources. Your assignment must follow these formatting requirements:Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.The specific course learning outcomes associated with this assignment are:Summarize the various types of disasters, response and recovery methods.Develop techniques for different disaster scenarios. Use technology and information resources to research issues in disaster recovery.Write clearly and concisely about disaster recovery topics using proper writing mechanics and technical style conventions.
IT 212 DCG Advertising Company Expansion Discussion
CompetencyIn this project, you will demonstrate your mastery of the following competencies:Explain the functions between h ...
IT 212 DCG Advertising Company Expansion Discussion
CompetencyIn this project, you will demonstrate your mastery of the following competencies:Explain the functions between hardware and software in a networkDesign a simple networkDesign and implement a secure interconnected network in support of an organizationScenarioThroughout this course, you have been writing various reports as parts of Milestones One and Two for an advertising firm that is opening a new office in Fayetteville, NC.This mid-size advertising firm already has offices in Albany, NY, and Springfield, MA. The Albany headquarters is home to the executive team and 150 employees. The headquarters also stores the corporate data and is the corporate internet backbone. It hosts the IT department that centrally manages all LAN services, including the wireless LAN. The IT department also manages the wide area network (WAN) that connects the two offices via site-to-site virtual private network (VPN) tunnels. The Springfield office hosts about 50 employees. Approximately 50% of these employees are mobile, defined as traveling more than 80% of the time.To hire and retain the best talent, the firm allows employees to work from home. This removes the constraint that employees have to live within commuting distance from the firm’s offices. Remote and mobile employees are provided access to the corporate network via a VPN client. The VPN client requires employees to have access to reliable internet services to allow for effective collaboration across teams and for access to media content. The company provides all employees with a laptop with full disk encryption, data loss prevention (DLP), and antivirus software. The IT department manages all corporate laptops and has the ability to access all systems for support. This means that all laptops are centrally managed by the one IT department.Due to an increase in opportunities for expansion to new markets, the firm has embarked on an initiative to hire and train new college graduates for the company’s Future Vision program. Future Vision focuses on expansion beyond the regional northeast footprint. The initiative is to hire graduates into the marketing, finance, and IT departments. You were hired as part of the Future Vision program and have been working at this for a while now. You have spent a considerable portion of your avaliability troubleshooting and analyzing the organization’s computer network to keep it running smoothly. Your direct supervisor and lead network administrator have been very impressed with your skills and fast learning abilities.To determine whether you are ready to take on more responsibility, you have been asked for your input regarding the new Fayetteville, NC, office setup project. Your task is to conduct research on this area and deliver a report to the team with key considerations and recommendations for the setup of the network infrastructure. The Fayetteville office will be home to 50 employees, including the new executive vice president of sales and marketing. All the possible sites have offices located in an office building with access to fiber, cable, and T1 internet service providers. In addition to the standard network, the site must support live video teleconferencing calls with employees based at the other sites. It must also reliably send print jobs to billboard printers located in the company headquarters in Albany.DirectionsThe primary goal of the project is to consolidate your findings from Milestones One and Two and compose a succinct and complete solution that you will present to the firm’s executive leadership team about the type of network they should design and implement at the new location.It is recommended that you incorporate the feedback you received from your instructor on Milestones One and Two. You can use this feedback to succinctly refine your recommendations into a polished report.Specifically, the following areas must be addressed in the report for the project:I. Key ConsiderationsExplain your key considerations for the project.Explain the OSI stack in relation to a modern communications network and how it influenced your network design.Describe the important IP range considerations for a company of your size.Summarize, in your own language, the strategic goals of the company, and detail how the network solution you are presenting aligns with these goals.Remember that these key considerations were addressed in Milestone One:Communications media and mode of data transport for the new networkCommon network hardware components for this new locationIn addition, you can make relevant changes to your report based on your instructor’s feedback from Milestone One.II. LAN TopologyIn Milestone One, you described the LAN topology possibilities and the strengths and weaknesses.Provide your final revised solution for optimal support that may include any feedback from the instructor from previous milestones.III. Internet Service ProviderIn Milestone Two, you described the possible ISP solutions available to meet the needs of the company in its new location. The section was based on your research into actual providers at the Fayetteville, NC, location.This section should include an explanation as to how the chosen internet provider meets the business goals and objectives of the firm.Provide your solution, along with any feedback from the instructor.IV. Hardware and Software, Printer, and Bandwidth: In this section, you will include these additional parts from Milestone Two in your report. You can use your diagram from Milestone Two as a starting point for these three items.Explain your proposed hardware and software solutions to meet the needs of the new office location.Describe your printer configuration solutions to meet the distance printing needs of the new office location.This could include considerations for tracking devices, automating driver distribution, and controlling access.Explain your bandwidth and device solutions to meet the teleconferencing needs of the new office location.V. Potential Errors: In this section, you will discuss common network errors and how your proposed solution will minimize and address these issues.Based on your previous report, anticipate common network errors that the new location may encounter.Describe effective troubleshooting approaches to the errors you identified, such as problem isolation, trace routing, and pinging.Explain how these approaches would ensure the resolution of the errors. Be sure your response is specific to the business location.VI. Additional Considerations: In this section, you will make recommendations for industry standard documentation for ongoing network support.Identify options for network monitoring that includes maintenance for network hardware and software (for example, port scanning, interface monitoring, packet flow monitoring, etc.).Identify patch management options that will help acquire, test, and install multiple patches on existing applications.Describe how you will control inventory, including how to discover and track assets on your network.As you develop your work, continue to look back on and consider each of these key elements. Remember, writing is a process that unfolds over time, and it typically requires reconsideration and revision of key elements.What to SubmitTo complete this project, you must submit the following:Your report must be 3 to 5 pages in length. Use double-spacing, 12-point Times New Roman font, one-inch margins, and APA formatting.
SU Agile Release Planning Essay
AGILE RELEASE PLANNING
With the Agile project framework in place for your home improvement store’s e-commerce website (f ...
SU Agile Release Planning Essay
AGILE RELEASE PLANNING
With the Agile project framework in place for your home improvement store’s e-commerce website (from Week 6), you must now consider long-term and short-term planning for your project. In addition, the company has realized the importance of mobile devices, such as smart phones and tablets, and decided to extend the e-commerce effort to include these devices. Note: You may create and/or assume all necessary assumptions needed for the completion of this assignment.
Write a 5–6 page paper in which you define the release plan of your project. In your paper, you must:
Draw a diagram to highlight the product road map and product life cycle through the use of graphical tools in Visio or an open source alternative (such as Dia). Note: The graphically depicted solution is not included in the required page length.
Provide at least three iterations and no more than ten tasks related to development on mobile devices through the use of MS Project. Note: Submit a screenshot or image file that shows your work. The graphically depicted solution is not included in the required page length.
Speculate on the associated risks regarding the development on mobile devices and provide strategies to mitigate those risks.
Provide at least two examples of maintenance stories based on the context of the project.
Provide at least two examples of performance cards based on the context of the project.
Use at least three quality resources in this assignment. Note: Wikipedia and similar websites do not qualify as quality resources.
NYU Hothouse Purchase Worksheet Database and Advanced Excel Concepts Excel Task
Excel_7E_Loan_OptionsundefinedundefinedProject Description:undefinedIn this project, you will use a PMT function to calcul ...
NYU Hothouse Purchase Worksheet Database and Advanced Excel Concepts Excel Task
Excel_7E_Loan_OptionsundefinedundefinedProject Description:undefinedIn this project, you will use a PMT function to calculate a value and then use it in a two-variable data table. You will create named ranges and use them in formulas.undefinedSteps to Perform:undefined Step Instructions Points Possible 1 Open the file Excel_7E_Loan_Options.xlsx download with this project. 0 2 Display the Hothouse Purchase worksheet. In cell B5, insert the PMT function using the data from the range B2:B4—be sure to divide the interest rate by 12 multiply the years by 12 and display the payment as a positive number. 10 3 Click cell B5, and then use Goal Seek to change the amount of the loan so that the payment goal is 4200 Then, in cell A7, type Option #1 Reduce the Loan Use the Format Painter to apply the cell style from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 425000 to restore the original loan amount. If necessary, press ESC to cancel the moving border. 10 4 Click cell B5, and then use Goal Seek to change the period of the loan (of the original data) so that the payment is 4200 Then, in cell A13, type Option #2 Increase Years Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in cell B15 with two decimal places, and then in cell B3, type 10 to restore the original value. If necessary, press ESC to cancel the moving border. Click cell A1, and then Save your workbook. 10 5 Display the Payment Table worksheet, in the range A2:B4, enter the following row titles and data. (The Currency [0] cell style is already applied to cell B2.) Amount of Loan425,000 Period (months)120 Interest rate (per year)5.25% 8 6 In cell C8, type 60—the number of months in a 5-year loan. In D8, type 120—the number of months in a 10-year loan. Fill the series through cell H8. Apply Bold and Center to the range C8:H8. 8 7 Beginning in cell B9, enter varying interest rates in decrements of 0.5% beginning with 7.0% and ending with 3.5% If necessary, format all the interest rates with two decimal places, and then apply Bold and Center to the range B9:B16. 10 8 In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number. 10 9 Create a Data table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate. Copy the format from cell B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is closest to $4,200 per month. Click cell A1. 10 10 Display the Advertising Costs by Quarter sheet. Name the following ranges: B6:E9 Newspaper_Costs B10:E14 Digital_Costs B15:E16 Magazine_Costs B17:E17 Billboard_Costs Insert a new row 15. In cell A15, type Designer Podcasts In cell B15, type 1250 In cell C15, type 1525 In cell D15, type 1266 In cell E15, type 1604. 9 11 Display the Name Manager, click Digital_Costs, and then in the Refers to box, edit as necessary so that the end of the range is cell E15. Select the Billboard_Costs and then Edit the name to Signage_Costs Click cell A1, and then Save your workbook. 4 12 Display the Annual Advertising Costs sheet. In cell B5, type =sum(N and sum the values using the appropriate range name in the displayed list of functions. Repeat for the other named ranges. From the Formulas tab, in the Function Library group, use AutoSum to sum all the costs. Click cell A1, and then click Save. 6 13 At the bottom of the workbook window, right-click any sheet tab name, and then click Select All Sheets. With the four worksheets grouped, from the Page Layout tab, display the Page Setup dialog box, and then insert a Custom Footer in the left section that includes the file name. Click the Margins tab, and then center the worksheets Horizontally on the page. Click the Payment Table worksheet, and then set the Orientation of this sheet to Landscape. 4 14 Display Backstage view, click Show All Properties. On the list of Properties, in the Tags box, type payment table, advertising costs In the Subject box, type your course name and section number. On the left, click Save. 1 15 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Hothouse Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save and close the file, and then submit for grading. 0 undefined Total Points 100
Earn money selling
your Study Documents