Order from us for quality, customized work in due time of your choice.
Use the Data in the attached PDF file, the data is also available for you to vie
Use the Data in the attached PDF file, the data is also available for you to view at the bottom of this page, as well. This data is the daily average passengers that ride Bart from Richmond to Downtown San Francisco (Table 1) and from El Cerrito Del Norte to Downtown SF (Table 2). This data is as of August 2020.
Your completed assignment should have one excel ″workbook ″ with two sheets (Sheet1 should have Table 1) and (Sheet 2 should have Table 2). Assignment is worth 20 pts, 10 pts per table.
Perform the same tasks below on both sheets. In essence work on sheet 1, and once you are finish, complete sheet 2
Each worksheet should have the following:
On Cell B4, type ″BART Average Ridership for the Month of August 2020″ –1pt
Starting on Cell B6 , type ″Destination″, on Cell C6 type ″Richmond Boarding Station″ (these will be the Column Titles) –1pt
Underline and Bold the Column Titles –1pt
Leave a row between the titles and the data –1pt
Type the data as listed in the attached PDF, which is also listed at the bottom of the page
On Column D, Cell D6 type ″Ticket Price″ –1pts
Starting on Cell D8 to Cell D11 type $5.55 (Make sure that it is formatted in dollar signs, where you show the cents) –1pt
On Column E , Cell E6 Type ″Average Revenue per Day″ –1pt
Starting on Cell E8 to Cell E11 type a formula that multiplies the contents by row of (Columns C and Column D) –1pt
Add a sum on Cell E12, which would sum Cell E8 through Cell E11 –1pt
Double underline this Cell (E12) and Bold & Call this sum ″Total Average Revenue per Day″ –1pts
THIS IS THE DATA TO USE
Average Daily Passengers
Table 1
Destination Richmond
Embarcadero 2,534
Montgomery Street 2,506
Powell Street 2,907
Civic Center 2,007
Table 2
Destination El Cerrito Del Norte
Embarcadero 3,214
Montgomery Street 3,404
Powell Street 3,575
Civic Center 2,893
Important Info
The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.
Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)
Order from us for quality, customized work in due time of your choice.