locale Revenue Project Description: In the face by side(p) get the hang Excel assessment, you will collar 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 necessary to perform the following tasks: blackguard| Instructions| Points Possible| 1| Start Excel. Open the downloaded rouse named 2H_Venue_Revenue.| 1| 2| In electric carrel A1, type roaring Grove Venue Revenue Projection and thence connect and halfway the textual matter across A1:F1. Change the Font to Cambria, limiting the Font coat to 16, and then apply a call for Color of olive Green, Accent 3 (seventh column, first row).In prison cell A3, type Year. In cell B3, enter the yr 2008, and then from B3:F3 increment the twelvemonth by 1 in each cell so that the entire con catenation displays the value 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 one hundred 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 manufactu! ring Museum 310524Golden Gardens 185927Golden Grove Amphitheatre 143589| 14| 5| In cell C6, enter the formula =B6*(100%+$C$4) to purpose the projected 2009 affix 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 cent similar formulas for the years 2011 and 2012 using...If you want to get a generative essay, order it on our website: OrderCustomPaper.com
If you want to get a full essay, visit our page: write my paper