Project Description:
In the side by side(p) get the hang Excel assessment, you will complete 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 parking structures.
Instructions:
For the purpose of leveling the project you are required to perform the following tasks:
blackguard| Instructions| Points Possible|
1| Start Excel. Open the downloaded rouse named 2H_Venue_Revenue.| 1|
2| In electric cell A1, type roaring Grove Venue Revenue Projection and thence connect and halfway the text across A1:F1. Change the Font to Cambria, limiting the Font Size to 16, and then apply a call for Color of Olive 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 year by 1 in each cell so that the entire range displays the values 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 width of column A to 200 pixels and the widths of columns B:F to 100 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 Industry Museum 310524Golden Gardens 185927Golden Grove Amphitheatre 143589| 14|
5| In cell C6, enter the formula =B6*(100%+$C$4) to purpose the projected 2009 increase 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 rich essay, order it on our website: Orderessay
If you want to get a full essay, wisit our page: write my essay .
No comments:
Post a Comment