venue Revenue Project Description: In the expression by side(p) get the hang Excel assessment, you will boom a workbook for the Director of Conventions, Culture, and Leisure, which shows receipts estimates for city-owned venues for conventions, cultural events, and leisure activities and their associated park structures. Instructions: For the purpose of leveling the project you are unavoidable to perform the following tasks: blackguard| Instructions| Points Possible| 1| Start Excel. Open the downloaded rouse named 2H_Venue_Revenue.| 1| 2| In electric carrellular telephone A1, type roaring Grove Venue Revenue Projection and thence connect and halfway the textbook across A1:F1. Change the Font to Cambria, limiting the Font size of it to 16, and then apply a call for Color of chromatic Green, Accent 3 (seventh column, first row).In cell A3, type Year. In cell B3, enter the yr 2008, and then from B3:F3 increment the course of instruction by 1 in eac h cell so that the entire scope displays the determine 2008 to 2012.| 20| 3| In cell A4, type Projected harvesting vagabond. In the range C4:F4, type the following percentages: 3.75%, 3.00%, 4.50%, 4.25%.| 14| 4| Format the largeness of column A to 200 pixels and the widths of columns B:F to speed of light pixels.
In the range A6:B11, enter the following data (text values in column A and numeral values in column B:Parking 1667164Convention Center 4332835Golf Course ! 1585242Science and diligence Museum 310524Golden Gardens 185927Golden Grove Amphitheatre 143589| 14| 5| In cell C6, enter the formula =B6*(100%+$C$4) to purpose the projected 2009 addition over 2008. In cell D6, for the year 2010, construct a similar formula using the precedent years revenue (C6) and the Projected Growth Rate in cell D4 (Hint: make cell D4 an absolute reference). spend a penny similar formulas for the years 2011 and 2012 using...If you want to get a deep essay, order it on our website: OrderCustomPaper.com
If you want to get a full essay, visit our page: write my paper
No comments:
Post a Comment