Answered step by step
Verified Expert Solution
Question
1 Approved Answer
e . Insert two columns called payment date and Adjusted bill to the right of the table. Customers who paid their bill on or before
e Insert two columns called "payment date" and "Adjusted bill" to the right of the table.
Customers who paid their bill on or before the due date is given a discount of $
and customers who pay their bill after the due date pays an extra $
f In an appropriate area of the worksheet, count the number of postpaid customers.
g In a new location on the same worksheet extract all the phones manufactured by
Samsung that costs over $
Task
a Post paid customers are required to pay for the cost of their phone on a monthly
basis. Each customer is given two years to pay for their phone at an interest rate of
per year. Create a reference table on a new sheet showing the conditions of the
monthly payment. Some conditions may include; interest rate, life of loan etc.
b Rename sheet as "Phone Payment".
c Insert another column called "final bill" to the right of the table in the "Bill
Calculator" sheet. Calculate the final bill by adding the adjusted bill to the monthly
payment of the phone. Ensure that the reference table in the "Phone Payment"
sheet is linked to the appropriate function used.
d Insert a column called "Final Phone Cost" to the right of "Cost of Phone". The final
phone cost is the original cost of the phone in addition to the amount of interest
paid.
c Create a pivot table to count the number of phones for each manufacturer. For
example; show how many persons own a Samsung etc...
f Sort the customers primarily by their last names in ascending order and then in
descending order by their final monthly bill.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started