Our Services

Get 15% Discount on your First Order

Excel

January 17, 2024

Follow steps

SmartPhone Upgrade

You have just graduated from college and before beginning your first professional job, you would like to purchase a new smartphone. You have the option to purchase the new phone in one payment or make monthly payments by taking advantage of a 36-month flex payment plan. The payment plan charges an APR of 1.75% for the service. Prior to making your payment decision, you would like to make a worksheet to calculate the monthly payment for Consumer Reports’ top three smartphones for young professionals.

1. Start a new Excel workbook, save it as
SmartPhone_LastFirst, and then rename Sheet1 to
FlexPay.

2. Type
Flex Pay Calculator in cell A1. Apply
bold, 20 pt font size.
Blue, Accent 1, font color.

3. Type
Inputs in cell A2. Apply
Thick Outside Borders to the
range A2:C2.

4. Type
APR and
# of payments in the
range A3:A4, and adjust the column width as needed.

5. Type
1.75%, in
cell B3 and
36 in
cell B4. Type
Outputs in
cell A6, Select the
range A6:C6, and apply
Thick Outside Borders.

6. Type
Model in
cell A7,
Price in
cell B7, and
Payment in
cell C7. Next enter the price information listed below in the
range A8:B10. Adjust the column width as needed and apply
Currency Number Format to the
range B8:C10.

Example Table
Model	Price
iPhone	949.00
Samsung Galaxy	799.00
Google Pixel	650.00

7. Use the PMT function in
cell C8 to calculate the monthly flex payment for the first option. Be sure to use the appropriate absolute, relative, or mixed cell references. Next use the fill handle to copy the function down, completing the
range C8:C10.

8. Type
Highest payment,
Average payment, and
Lowest payment in the
range A12:A14. Resize column A as needed.

9. Use the MAX function in
cell B12 to calculate the highest flex payment, in
cell B13 use the AVERAGE function to calculate the average flex payment, and in
cell B14 use the MIN function to calculate the lowest flex payment.

10. Insert a footer with your name on the left side, the sheet name in the center, and the file name code on the right side of the worksheet.

11. Save and close the workbook.

Submit the assignment on Canvas.

Do not email the assignment to the Professor.

Rubric

Office Assignment Rubric

Office Assignment Rubric

Criteria

Ratings

Pts

This criterion is linked to a Learning OutcomeOverall Assessment

200 pts

Outstanding

Completed all requirements outlined in the step by step assignment details.

150 pts

Good

Completed most of the requirements outlined in the step by step assignment details.

0 pts

No Marks

Failed to complete all requirements outlined in the step by step assignment details.

200 pts

Total Points: 200

>Literature homework help, excel

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Title slide. Problem description 1-2 slides. Your survey/references for the project proposal. Organization chart. Proposed tasks and

Title slide. Problem description 1-2 slides. Your survey/references for the project proposal. Organization chart. Proposed tasks and guidelines. Gantt chart. PERT Chart or Pivot Chart Return on investment. Summary. Sample Template attached must be filled out

Several companies are discussed in Ch. 11 on their use of data to better secure their operations. Pick one of these companies and provide a brief summary

Several companies are discussed in Ch. 11 on their use of data to better secure their operations. Pick one of these companies and provide a brief summary of the company’s actions and their expected outcomes.

see attached Reproduced with permission of the copyright owner. Further reproduction prohibited without permission. Reproduced with permission

see attached Reproduced with permission of the copyright owner. Further reproduction prohibited without permission. Reproduced with permission of the copyright owner. Further reproduction prohibited without permission. Reproduced with permission of the copyright owner. Further reproduction prohibited without permission. Reproduced with permission of the copyright owner. Further reproduction prohibited without permission.

see attachments- Here is the article for week 6 – the class is COMM 240 Intercultural Communication Wk 6 Assignment

see attachments- Here is the article for week 6 – the class is COMM 240 Intercultural Communication Wk 6 Assignment Instructions Select a scholarly article on intercultural communication using the course library. Please make sure you are choosing a peer-reviewed article from an academic journal. If you have questions on

Nursing research Evidence-Based Practice Process Paper – Grading Criteria 1 Criterion

Nursing research Evidence-Based Practice Process Paper – Grading Criteria 1 Criterion Points Earned Introduction: 10 1. Clearly explains the situation or concern.* 0 2. Identifies the clinical setting.* 0 3. Identifies the population of interest.* 0 4. Answers background questions. 0 5. Compares clinical setting performance to local, state, or

Discussion 5: Elaborate on Your Impressions of La Tomatina Festival Must post first. Subscribe Discussion Board Guidelines

Discussion 5: Elaborate on Your Impressions of La Tomatina Festival Must post first. Subscribe Discussion Board Guidelines Participate in the discussion by responding to the prompt below in an initial post, then by responding to the posts of your classmates. Your initial response post is due by Thursday at

need help with draft question. Milestone Three Guidelines and Rubric.html MUS 223 Milestone Three Guidelines and Rubric Academic Analysis In

need help with draft question. Milestone Three Guidelines and Rubric.html MUS 223 Milestone Three Guidelines and Rubric Academic Analysis In Milestone Three, you will submit your academic analysis of the composition. Your review of scholarly resources will identify the composer, the musical work, and the time period, providing an academic

view attachment CAPSTONE WEEK 4 Assignment for this week will be a response to the following question: “As an expert in my field of study, how do I

view attachment CAPSTONE WEEK 4 Assignment for this week will be a response to the following question: “As an expert in my field of study, how do I expect to apply Jesuit ideals and principles in my work and/or in other facets of my life?” Please include in your discussion

Module/Unit Five Integrative Assignment Literature Instructions – Choose one of the following assignments to show

Module/Unit Five Integrative Assignment Literature Instructions – Choose one of the following assignments to show your knowledge of Jamaica Kincaid’s Annie John and the material on Pre-writing strategies. Please read Annie John closely and pay attention to characterization, setting, how the action flows and the story line moves forward. Use the

Eric Swirsky, JD, MA Director of Graduate Studies Clinical Assistant Professor Ethical Decision-making © 2017 Eric Scott Swirsky Seven Step

Eric Swirsky, JD, MA Director of Graduate Studies Clinical Assistant Professor Ethical Decision-making © 2017 Eric Scott Swirsky Seven Step Decision-making Process 1. Identify the type of moral or ethical dilemma 2. Reflect on personal bias or assumptions 3. Gather relevant information 4. Consider stakeholder interests and values 5. Explore

A Brand Manager is a professional who is responsible for ensuring that their company’s products, services, and product lines resonate with current or potential

A Brand Manager is a professional who is responsible for ensuring that their company’s products, services, and product lines resonate with current or potential customers. In addition, they monitor marketing trends as well as keep an eye on competitive companies in the marketplace so they can stay ahead of competition. You

Excel #2

Follow steps Passenger Top 6 United States Airports by Traffic Count Total Passenger Count 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Trends ATLANTA GA (ATL) 84,846,639 89,379,287 90,039,280 88,032,086 89,238,059 92,389,023 95,513,828 94,431,224 96,178,899 101,491,106 104,171,935 CHICAGO IL (ORD) 77,028,134 76,177,855 69,353,480 64,158,343 66,733,607 66,659,709 66,629,600

Literature Dissertation Assignment

I will upload the first assignment the assignment speaks of after bid has been accepted. Assignment: Textbook Information: Roberts, C. M., & Hyatt, L. (2019). The dissertation journey: A practical guide to planning, writing, and defending your dissertation (3rded.). Corwin Publishing Co. ISBN- 9781506373331. Read Chapter 13. This week’s assignment will require

Literature Research Design Assignment

Assignment: The importance of research design can never be over-emphasized. It dictates the approach toward asking a research question, but it also is an indicator of the type of data required to answer the research question(s). 1. The assignment begins with selecting two dissertations or well-documented studies. Select one

Literature Powerpoint Assignment

Textbook Needed: Roberts, C. M., & Hyatt, L. (2019). The dissertation journey: A practical guide to planning, writing, and defending your dissertation (3rded.). Corwin Publishing Co. ISBN- 9781506373331. Read Chapter 3. This activity will allow you to research information that supports the important aspects of ethics in research. This is especially true

Discussion Questions

Provide a 150- word response to each discussion posting listed below. 1. The researcher was honest regarding her positionality as a Black woman faculty member, recognizing the potential influence of her background on the study. To maintain objectivity and reduce the impact of personal biases, the researcher implemented several strategies.

Methodology and Ethics Discussion

Textbook Reading: Roberts, C. M., & Hyatt, L. (2019). The dissertation journey: A practical guide to planning, writing, and defending your dissertation (3rded.). Corwin Publishing Co. ISBN- 9781506373331. Read Chapter 3. Discussion Question: Must be at least 300 words. After reading the suggested chapter on ethical considerations, review the dissertation example that

Literature Methodology Assignment

IMPORTANT NOTE: YOU WILL NEED TO HAVE ACCESS TO THE REQUIRED TEXTBOOK TO COMPLETE THIS ASSIGNMENT. · Textbook: Roberts, C. M., & Hyatt, L. (2019). The dissertation journey: A practical guide to planning, writing, and defending your dissertation (3rded.). Corwin Publishing Co. ISBN- 9781506373331. Read Chapter 10. Carefully read the different sections