Answered step by step
Verified Expert Solution
Link Copied!

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 $1000
and customers who pay their bill after the due date pays an extra $750.
f. In an appropriate area of the worksheet, count the number of post-paid customers.
g. In a new location on the same worksheet extract all the phones manufactured by
Samsung that costs over $85,000.00.
Task 2
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
5% 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these General Management questions