Create a table that shows the total of account value

Assignment Help Management Information Sys

Reference no: EM133389148

Question 1) Use data in the Bell worksheet. Bell Roger company wants to determine the hourly rates for their billable hours in 2020 and 2021 and show the total revenue, total billable hours, and average hourly rate for 2021, 2020 for employees with more than 10 years of experience.

Use the slicer to display the data. Bell wants the data in order of highest billable rate to the least. Format the table using Gold table style medium, 4.

Question 2) Use the data in the Account Manager worksheet to create a table that shows the total of account value by specialty and the overall total for all specialty. (Hint, sort and subtotal)

Question 3) Use the data in the Account Total worksheet, add a calculated column called "Discount %" in column G.

A) Use the IFs function to obtain the discount % based on the supervisor review as follows (if supervisor review is >= 8, then discount value is 5%, else, if review is >=5, the discount value is 3%, else discount value is 1%) Note score is based on accurate use of the IFS function)

B) Create a new calculated column in H as the discounted amount of account value (E). ( Hint: use formula)

C) Sort the data by discount value. Format the table using Red Table style Mediun, 2, Center and format the title "Bank Account Managers - May 2021" using font size 16, Bold (30 points)

Question 4) create an amortization Schedule for a $100,000 mortgage using these parameters (40 points)

Rate per period 3%
Number of Periods (years) 15
Payments per year 12
Mortgage Value 100000
Down payment 5%

Reference no: EM133389148

Questions Cloud

What do we lose by using mayersens temporal perspective : What do we lose by using Mayersen's "Temporal" perspective [i.e., what do we gain by taking other perspectives/framings]?

What are some of the technical challenges of deploying : Do you think the business idea for Box'd allows for a long-term business or is it a short-term vision? Assess in light of the 12 ideas highlighted

How did reign of napoleon iii of france illustrate political : How did the reign of Napoleon III of France illustrate the political and social norms of the period?

What does it mean if a supplier is iso 9001 certified : What does it mean if a supplier is ISO 9001 certified? ISO 14001 certified? Define 6 Sigma and Discuss one company who has successfully integrated 6 sigma

Create a table that shows the total of account value : Create a table that shows the total of account value by specialty and the overall total for all specialty. (Hint, sort and subtotal)

Describe anycommon threads between their stories : Identify and describe anycommon threads between their stories. Original post and at least one peer response required.

What type of contract would you use : If your group represents a buyer, consider the different suppliers - which one would you select? What type of contract would you use? If your group represents

Identify the effectiveness of the records management : identify the effectiveness of the records management and the records management classification processes within the organization through the audit process

What impact the wearable devices had made : What impact the wearable devices had made on the health and wellness of the public through monitoring health conditions - physical activity, blood glucose

User Account

All Pages