Assignment Descriiption: In this assignment you will create a workbook for the Director of Convention, Culture, and Leisure, which shows revenue estimates for city-owned venues for conventions, cultural events, and leisure activities and their associated parking structures.
Instructions: The following are the instructions for this EXCEL assignment. Follow these instructions carefully and in the order you see them below. Double check your work before you submit anything.
In cell A1, type Golden Grove Venue Revenue Projection and then Merge and Center the text across A1:F1. Change the Font to Cambria, change the Font Size to 16, and then apply a Fill Color of Green, Accent 6 lighter 40%.
In cell A3, type Year. In cell B3, enter the year 2015, and then from B3:F3 increment the year by 1 in each cell so that the entire range displays the values 2015 to 2019.
In cell A4, type Projected Growth Rate. In the range C4:F4, type the following percentages: 3.75%, 3.00%, 4.50%, 4.25%.
Format the width of column A to 200 pixels and the widths of columns B through F to 100 pixels. In the range A6:B11, enter the following data (text values in column A and numeric values in column B:
Convention Center 4332835
Golf Course 1585242
Science and Industry Museum 310524
Golden Gardens 185927
Golden Grove Amphitheatre 143589
In cell C6, enter the formula =B6*(100%+$C$4) to calculate the projected 2016 increase over 2015. In cell D6, for the year 2017, construct a similar formula using the previous year’s revenue (C6) and the Projected Growth Rate in cell D4 (Hint: make cell D4 an absolute reference). Construct similar formulas for the years 2018 and 2019 using the previous year’s revenue and the projected growth rate for the year indicated. Copy the formulas in row 6 down through row 11.
In cell A12, type Total for All Venues and then in cells B12:F12, Auto Sum the values in columns B:F. Format the range B6:F12 using the Accounting style.
Using the data in the range A12:F12, insert a line chart using the Line with Markers chart type, and then apply Chart Style 9. Edit the data source so that the Horizontal (Category) Axis uses the years in the range B3:F3 as the labels. Position the upper-left corner of the chart inside the upper-left corner of cell A16.
Rename the worksheet (sheet tab) to Revenue. Click on cell A14 and type in your first and last name. Bold your entire name. Save the workbook as Venue Revenue. Close the workbook and then exit Excel. Submit the workbook/file via the assignment in blackboard.
Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates