The Red Bluff Golf Course & Pro Shop generates revenue through its golfers, golfer services, and pro shop sales. Aleeta Herriott, the pro shop manager, receives revenue data on a monthly basis. She would like to have some reports developed that will help to track sales and to analyze her profit margins. She has a workbook started with some sample data and wants you to continue developing some reports. These reports will help Aleeta make educated decisions about the business, such as which items to place on sale or discontinue.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
2 On the DataInputs worksheet, in cell I48, paste the current named ranges. On the Transactions worksheet, in cell Q9, enter an IF function that will test if the value in cell D9 is equal to Ccard. If the value is true, the result will be Charge. If the value is false, the result will be blank. Copy the formula down to cell Q30.