Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

MGS 4020 Project 1: EXCELFor Project 1, you only need to submit Q1 – Q11.You may want to start to practice MS Access by answePart 1:1)8 ptsHow many Crowne Plaza hotels (Brand = HICP) in Raw Data?2)4 pts3)8 pts

/in /by

MGS 4020 Project 1: EXCELFor Project 1, you only need to submit Q1 – Q11.You may want to start to practice MS Access by answePart 1:1)8 ptsHow many Crowne Plaza hotels (Brand = HICP) in Raw Data?2)4 pts3)8 ptsHow many Crowne Plaza hotels (Brand = HICP) in Raw Data are locat4)8 ptsWhat is the total revenue of the Holiday Inn Express hotels (Brand = H5)8 pts6)8 ptsBy using Pivot Table, provide the total revenue by state and by brand7)12 ptsCan you please provide a method to identify the duplicate records?Hints: if, then statement8)8 ptsPlease add one additional column as Column D in this spreadsheet.Provide the formula to join the “score” and pts together.Example: YouPart 2:9)12 ptsProvide the trend between Feb 04 and Dec 04Part 3:10)12 ptsBy looking at the formula, it’s very obvious that 05388 = United States,Please add 01111 = Hong Kong and 02222 = Singapore and copy/pasPart 4:11)12 ptsBy looking at the formula in the auto payment tab, please get familiar aJohn plans to purchase a new BMW.BMW 325i$35,500.00Down Payment$5,325.00Interest Rate3.9% for 36 monthsPlease provide the total amount of interest payments by the end of 36ACCESS (For Practice Only)For Q12-17, please use the same Access Database from Project 312)Provide the total number of nights.The reservations were made betw13)Update all SHK room type to KEXS14)Count the number of records by Res Type for the rate amount greater t15)Provide cross tab query to show the total number of nights by date an

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"