quick excel test

profilesirleo
ExcelTest.xlsx
Home>Business & Finance homework help>Accounting homework help>quick excel test

Data

Asset Acquisition Date Category Value Description Disposal Date Location Branch
10044 12/1/19 Rental - Specialty 22,243.99 2006 Used WILSON FLATBED   Fontana
10081 9/15/18 Rental - Specialty 25,124.36 2000 Used LOWBOY   Grants Pass
10094 10/15/18 Rental - Drop Deck 23,332.67 2003 Used DROP DECK   Fontana
10099 8/15/18 Rental - Flatbed 35,415.17 2018 Used Flatbed 5/31/20 Fontana
10102 12/15/18 Rental - Flatbed 31,662.42 2007 Used FONTAINE FLATBED 5/31/19 Fontana
10115 8/1/19 Rental - Specialty 45,785.88 2019 New TIMPTE GRAIN TRAILER   Salt Lake City
10221 9/15/18 Rental - Specialty 26,419.72 2013 Used Bottom Dump 5/31/20 Dallas
10303 7/15/18 Rental - Specialty 52,902.52 2019 New LOWBOY   Houston
10304 8/15/18 Rental - Specialty 62,737.30 2019 New Lowboy 11/30/18 Houston
10350 10/15/18 Rental - Drop Deck 37,687.91 2018 New DROP DECK   Dallas
10352 9/15/18 Rental - Drop Deck 38,783.74 2018 New DROP DECK 2/29/20 Dallas
10359 8/1/20 Rental - Flatbed 40,714.29 2019 New Wilson Flatbed   Salt Lake City
10374 8/15/18 Rental - Drop Deck 34,161.57 2016 Used Drop Deck   Salt Lake City
10407 9/15/18 Rental - Specialty 74,653.63 2018 New SLIDE AXLE   Houston
10419 8/1/19 Rental - Drop Deck 37,109.96 2017 Used WILSON DROP DECK 4/30/20 Phoenix
10437 8/15/18 Rental - Drop Deck 37,362.49 2018 New Drop Deck   Houston
10438 8/15/18 Rental - Drop Deck 37,360.92 2018 New Drop Deck   Houston
10439 8/15/18 Rental - Drop Deck 37,605.97 2018 New Drop Deck 4/30/20 Houston
10451 7/15/18 Rental - Flatbed 40,475.28 2019 New EXTENDABLE FLATBED   Houston
10452 8/15/18 Rental - Flatbed 41,681.38 2019 New Extendable Flatbed   Fontana
10454 8/15/18 Rental - Specialty 94,639.34 2019 New Extendable Lowboy   Houston
10463 8/15/18 Rental - Specialty 46,185.64 2019 New Hopper/Grain Trailer 9/30/19 Dallas
10467 8/15/18 Rental - Specialty 53,876.99 2019 New Lowboy   Houston
10530 8/15/18 Rental - Flatbed 42,829.93 2019 New Flatbed   Phoenix
10546 3/1/19 Rental - Flatbed 48,635.60 2019 New FONTAINE HEAVY HAUL Extendable Flatbed   Houston
10549 9/15/18 Rental - Specialty 72,048.80 2019 New LOWBOY   Dallas
10576 9/15/18 Rental - Flatbed 30,676.12 2019 New FLATBED   Salt Lake City
10579 10/15/18 Rental - Flatbed 30,041.52 2019 New FLATBED   Houston
10602 11/1/19 Rental - Specialty 44,183.44 2019 New TIMPTE GRAIN TRAILER   Dallas
10611 1/1/20 Rental - Specialty 94,400.69 2019 New TRAIL KING LOWBOY   Fontana
10621 9/15/18 Rental - Flatbed 50,502.03 2019 New FLATBED 9/30/18 Phoenix
10626 9/15/18 Rental - Flatbed 23,696.34 2003 Used Flatbed 10/31/18 Fontana
10667 9/15/18 Rental - Flatbed 22,785.60 2002 Used Flatbed 10/31/18 Fontana
10671 9/15/18 Rental - Flatbed 32,874.88 2019 New FLATBED 9/30/19 Salt Lake City
10672 9/15/18 Rental - Flatbed 33,104.53 2019 New FLATBED 9/30/19 Salt Lake City
10675 8/15/18 Rental - Flatbed 36,595.96 2019 New Flatbed   Houston
10677 8/15/18 Rental - Flatbed 36,190.71 2019 New Flatbed   Houston
10683 11/15/18 Rental - Specialty 124,591.32 2019 New TRAIL KING Extendable Lowboy 11/30/19 Houston
10699 8/15/18 Rental - Flatbed 25,894.58 2003 Used Flatbed 12/31/19 Fontana
10700 11/1/19 Rental - Specialty 44,183.44 2019 New TIMPTE GRAIN TRAILER   Dallas
10711 11/15/18 Rental - Drop Deck 34,881.65 2015 Used DOONAN DROP DECK 3/31/19 Salt Lake City
10728 8/15/18 Rental - Drop Deck 39,837.03 2019 New Drop Deck   Houston
10729 8/15/18 Rental - Drop Deck 42,242.88 2019 New Drop Deck 12/31/19 Houston
10730 8/15/18 Rental - Drop Deck 39,836.16 2019 New Drop Deck   Houston
10732 8/15/18 Rental - Drop Deck 39,880.41 2019 New Drop Deck   Houston
10734 8/15/18 Rental - Drop Deck 45,305.04 2019 New Drop Deck 2/28/19 Houston
10744 9/15/18 Rental - Drop Deck 24,363.15 2004 Used DROP DECK 2/28/19 Dallas
10788 10/15/18 Rental - Flatbed 30,066.34 2019 New FLATBED   Houston
10800 10/15/18 Rental - Flatbed 29,848.73 2019 New FLATBED   Houston
10802 9/15/18 Rental - Drop Deck 47,373.00 2019 New DOUBLE DROP   Grants Pass
10813 10/15/18 Rental - Flatbed 29,747.05 2019 New FLATBED   Houston
10825 10/15/18 Rental - Flatbed 29,883.57 2019 New FLATBED   Houston
10826 10/15/18 Rental - Flatbed 29,747.94 2019 New FLATBED   Houston
10848 10/15/18 Rental - Flatbed 29,779.66 2019 New FLATBED   Houston
10849 10/15/18 Rental - Flatbed 29,747.05 2019 New FLATBED   Houston
10852 8/1/19 Rental - Specialty 30,304.37 2011 Used TIMPTE GRAIN TRAILER   Dallas
10866 9/15/18 Rental - Flatbed 36,530.54 2019 New FLATBED 11/30/18 Dallas
10883 12/15/18 Rental - Flatbed 34,002.36 2019 New TRANSCRAFT FLATBED 5/31/20 Dallas
10886 9/15/18 Rental - Flatbed 28,518.83 2009 Used FLATBED 12/31/18 Salt Lake City
10999 10/15/18 Rental - Drop Deck 40,823.17 2016 Used DROP DECK 11/30/18 Fontana
11047 1/15/19 Rental - Specialty 84,816.25 2019 New TRAIL KING LOWBOY   Dallas
11059 1/15/19 Rental - Specialty 22,922.80 2019 New FONTAINE flip axle   Houston
11077 9/15/18 Rental - Flatbed 50,870.73 2019 New FLATBED 11/30/18 Phoenix
11150 10/15/18 Rental - Flatbed 22,049.69 2000 Used EXTENDABLE FLATBED 10/31/19 Fontana
11153 8/1/19 Rental - Specialty 84,822.36 2019 New TRAIL KING LOWBOY   Dallas
11164 10/15/18 Rental - Flatbed 30,672.82 2014 Used FLATBED 1/31/19 Salt Lake City
11165 1/15/19 Rental - Flatbed 25,930.92 2009 Used FONTAINE FLATBED 12/31/19 Fontana
11166 11/15/18 Rental - Flatbed 25,521.54 2009 Used FONTAINE FLATBED 2/28/19 Salt Lake City
11169 10/15/18 Rental - Drop Deck 66,734.60 2019 New Extendable Double Drop   Houston
11181 1/15/19 Rental - Flatbed 30,892.68 2019 New TRANSCRAFT FLATBED   Fontana
11189 10/15/18 Rental - Drop Deck 33,705.38 2015 Used DROP DECK 10/31/19 Fontana
11237 1/15/19 Rental - Flatbed 33,787.24 2019 New TRANSCRAFT FLATBED 4/30/20 Dallas
11239 1/15/19 Rental - Flatbed 36,189.98 2019 New WILSON FLATBED   Fontana
11240 1/15/19 Rental - Flatbed 36,346.96 2019 New WILSON FLATBED   Fontana
11241 1/15/19 Rental - Flatbed 36,794.30 2019 New WILSON FLATBED   Fontana
11258 11/15/18 Rental - Specialty 26,116.93 2008 Used TIMPTE GRAIN TRAILER   Houston
11270 12/15/18 Rental - Drop Deck 41,556.81 2019 New FONTAINE DROP DECK 7/31/20 Houston
11306 12/15/18 Rental - Drop Deck 41,943.85 2019 New FONTAINE DROP DECK   Salt Lake City
11317 12/15/18 Rental - Flatbed 36,587.48 2019 New FONTAINE FLATBED 4/30/20 Houston
11322 12/15/18 Rental - Flatbed 22,359.80 2000 Used RAVENS FLATBED   Fontana
11333 3/1/19 Rental - Flatbed 34,346.08 2019 New TRANSCRAFT Flatbed 8/31/19 Dallas
11374 3/1/19 Rental - Flatbed 32,850.54 2019 New TRANSCRAFT Flatbed   Dallas
11446 7/1/19 Rental - Specialty 36,264.89 2009 Used TIMPTE GRAIN TRAILER   Dallas
11504 1/15/19 Rental - Flatbed 41,701.67 2019 New BENSON FLATBED   Dallas
11519 1/15/19 Rental - Flatbed 37,256.28 2019 New FONTAINE FLATBED   Houston
11521 1/15/19 Rental - Flatbed 39,485.04 2019 New FONTAINE FLATBED   Fontana
11531 12/15/18 Rental - Specialty 40,091.80 2007 Used Wilson Flatbed with Rolling Tarp 2/28/19 Grants Pass
11535 11/15/18 Rental - Drop Deck 36,886.70 2019 New FONTAINE DROP DECK   Houston
11536 11/15/18 Rental - Drop Deck 36,886.70 2019 New FONTAINE DROP DECK   Houston
11537 11/15/18 Rental - Drop Deck 40,025.06 2019 New FONTAINE DROP DECK 8/31/19 Houston
11549 2/1/19 Rental - Drop Deck 69,621.11 2019 New FONTAINE HEAVY HAUL Extendable Double Drop   Grants Pass
11565 12/15/18 Rental - Flatbed 36,404.61 2019 New WILSON FLATBED   Fontana
11576 12/1/19 Rental - Flatbed 38,896.46 2019 New FONTAINE FLATBED   Dallas
11587 8/1/19 Rental - Drop Deck 50,484.06 2019 New FONTAINE DROP DECK   Fontana
11612 3/1/19 Rental - Specialty 36,830.02 2010 Used HEIL Tank Trailer   Albuquerque
11632 6/1/19 Rental - Flatbed 31,396.73 2019 New TRANSCRAFT FLATBED   Houston
11715 5/1/19 Rental - Drop Deck 38,197.64 2019 New FONTAINE DROP DECK   Dallas
11826 6/1/19 Rental - Specialty 61,036.12 2019 New SDI SIDE DUMP   Salt Lake City
12039 12/21/18 Rental - Specialty 25,968.10 2013 MANAC REEFER 3/31/19 Detroit
12040 12/21/18 Rental - Flatbed 32,089.53 2013 MANAC FLATBED 2/29/20 Detroit
12598 3/1/19 Rental - Flatbed 23,913.43 2005 Used EAST Flatbed   Grants Pass
12600 3/1/19 Rental - Flatbed 27,958.44 2012 Used REITNOUER Flatbed   Grants Pass
12601 4/1/19 Rental - Drop Deck 43,054.56 2019 New FONTAINE DROP DECK   Salt Lake City
12602 3/1/19 Rental - Drop Deck 42,616.36 2019 New FONTAINE Drop Deck   Salt Lake City
12607 6/1/19 Rental - Flatbed 37,664.00 2019 New FONTAINE FLATBED 5/31/20 Grants Pass
12730 4/1/19 Rental - Drop Deck 38,350.17 2019 New WADE DROP DECK   Houston
12911 12/1/19 Rental - Flatbed 61,881.02 2020 New FONTAINE FLATBED   Houston
13078 4/1/19 Rental - Flatbed 25,040.84 2011 Used GREAT DANE FLATBED   Fontana
13079 4/1/19 Rental - Flatbed 24,775.65 2011 Used GREAT DANE FLATBED   Fontana
13084 7/1/19 Rental - Flatbed 37,083.85 2020 New TRANSCRAFT FLATBED   Houston
13126 5/1/19 Rental - Flatbed 37,235.10 2020 New TRANSCRAFT FLATBED   Houston
13153 5/1/19 Rental - Flatbed 37,074.94 2020 New TRANSCRAFT FLATBED   Houston
13201 5/1/19 Rental - Flatbed 34,524.04 2020 New TRANSCRAFT FLATBED   Houston
13204 7/1/19 Rental - Specialty 24,288.18 2019 New TRAIL KING MISCELLANEOUS EQUIPMENT 3/31/20 Houston
13266 4/1/19 Rental - Flatbed 24,993.16 2011 Used GREAT DANE FLATBED   Fontana
13338 4/1/19 Rental - Specialty 48,265.74 2012 Used Freightliner Truck   Fontana
13339 4/1/19 Rental - Specialty 30,718.04 2006 Used Mofet Forklift   Fontana
13340 4/1/19 Rental - Specialty 30,718.04 2006 Used Mofet Forklift   Fontana
13341 4/1/19 Rental - Specialty 29,920.51 2004 Used Mofet Forklift   Fontana
13363 4/1/19 Rental - Flatbed 25,224.67 2011 Used GREAT DANE FLATBED   Fontana
13398 6/1/19 Rental - Flatbed 26,378.26 2012 Used GREAT DANE FLATBED   Phoenix
13443 9/1/19 Rental - Flatbed 42,881.24 2020 New Transcraft Flatbed   Houston
13446 7/1/19 Rental - Flatbed 34,873.50 2020 New TRANSCRAFT FLATBED   Houston
13503 7/1/19 Rental - Flatbed 36,389.28 2020 New TRANSCRAFT FLATBED   Houston
13510 1/1/20 Rental - Drop Deck 32,178.60 2008 Used CHAPARRAL DROP DECK   Fontana
13520 7/1/19 Rental - Flatbed 34,872.52 2020 New TRANSCRAFT FLATBED   Houston
13529 7/1/19 Rental - Flatbed 37,232.26 2020 New TRANSCRAFT FLATBED   Houston
13530 7/1/19 Rental - Flatbed 36,940.33 2020 New TRANSCRAFT FLATBED   Houston
13535 7/1/19 Rental - Flatbed 36,388.30 2020 New TRANSCRAFT FLATBED   Houston
13572 12/1/19 Rental - Flatbed 39,273.50 2020 New FONTAINE FLATBED   Houston
13633 11/1/19 Rental - Flatbed 47,993.98 2020 New FONTAINE FLATBED   Dallas
13658 12/1/19 Rental - Specialty 86,454.39 2019 New TRAIL KING LOWBOY   Houston
13689 9/1/19 Rental - Drop Deck 52,666.38 2020 New Fontaine Drop Deck 4/30/20 Phoenix
13692 6/1/19 Rental - Specialty 73,168.36 2020 New FONTAINE HEAVY HAUL EXTENDABLE LOWBOY   Houston
13707 12/1/19 Rental - Specialty 86,917.97 2019 New TRAIL KING LOWBOY   Houston
13708 12/1/19 Rental - Specialty 86,454.39 2019 New TRAIL KING LOWBOY   Houston
13712 9/1/19 Rental - Drop Deck 51,168.43 2020 New Fontaine Drop Deck   Phoenix
13724 12/1/19 Rental - Specialty 93,400.26 2020 New TRAIL KING LOWBOY   Houston
13725 12/1/19 Rental - Specialty 93,400.26 2020 New TRAIL KING LOWBOY   Houston
13747 7/1/20 Rental - Flatbed 28,301.12 2007 Used Reitnouer Flatbed   Salt Lake City
13758 10/1/19 Rental - Flatbed 56,091.89 2020 New WILSON FLATBED   Fontana
13781 9/1/19 Rental - Drop Deck 40,847.38 2020 New Transcraft Drop Deck   Dallas
13794 4/1/20 Rental - Drop Deck 76,620.00 2020 New KALYN SIEBERT EXTENDABLE DROP DECK   Fontana
13874 12/1/19 Rental - Specialty 87,276.37 2020 New KALYN SIEBERT SLIDE AXLE   Dallas
13911 9/1/19 Rental - Drop Deck 47,706.61 2018 Used Wilson Drop Deck   Fontana
13915 12/1/19 Rental - Flatbed 35,986.52 2020 New TRANSCRAFT FLATBED   Houston
13921 6/1/20 Rental - Specialty 133,156.21 2020 New Trail King Extendable Lowboy   Houston
13932 10/1/19 Rental - Specialty 56,591.53 2020 New KALYN SIEBERT LOWBOY   Fontana
13934 12/1/19 Rental - Flatbed 38,598.14 2020 New TRANSCRAFT FLATBED   Houston
13964 9/1/19 Rental - Specialty 64,514.47 2013 Used Trail King Lowboy   Dallas
13965 12/1/19 Rental - Specialty 66,673.98 2013 Used TRAIL KING LOWBOY   Houston
13966 10/1/19 Rental - Flatbed 39,401.44 2020 New FONTAINE FLATBED   Dallas
13968 12/1/19 Rental - Flatbed 39,960.27 2020 New FONTAINE FLATBED   Houston
13973 2/1/20 Rental - Specialty 114,468.87 2019 New Capacity Yard Dog 2/29/20 Phoenix
13980 9/1/19 Rental - Drop Deck 39,497.36 2020 New Fontaine Drop Deck   Houston
13981 9/1/19 Rental - Drop Deck 39,497.36 2020 New Fontaine Drop Deck   Houston
13982 9/1/19 Rental - Drop Deck 39,561.23 2020 New Fontaine Drop Deck   Houston
14011 6/1/20 Rental - Specialty 109,270.15 2020 New Trail King Extendable Double Drop Deck   Grants Pass
14012 12/1/19 Rental - Specialty 93,400.26 2020 New TRAIL KING LOWBOY   Houston
14022 8/1/19 Rental - Specialty 24,787.93 2020 New TRAIL KING MISCELLANEOUS EQUIPMENT   Dallas
14025 10/1/19 Rental - Flatbed 31,244.29 2018 Used GREAT DANE FLATBED   Dallas
14028 10/1/19 Rental - Flatbed 31,244.29 2018 Used GREAT DANE FLATBED   Dallas
14036 9/1/19 Rental - Flatbed 36,590.83 2018 Used Great Dane Flatbed 4/30/20 Fontana
14037 12/1/19 Rental - Flatbed 36,004.21 2020 New TRANSCRAFT FLATBED   Houston
14047 10/1/19 Rental - Drop Deck 40,298.18 2016 Used GREAT DANE DROP DECK   Phoenix
14125 9/1/19 Rental - Drop Deck 35,766.27 2016 Used Fontaine Drop Deck   Dallas
14147 10/1/19 Rental - Drop Deck 28,733.38 2013 Used FONTAINE DROP DECK 2/29/20 Dallas
14148 2/1/20 Rental - Drop Deck 29,996.34 2013 Used TRANSCRAFT DROP DECK   Houston
14308 10/1/19 Rental - Specialty 24,012.11 2020 New TRAIL KING Flip Axle   Dallas
14332 10/1/19 Rental - Drop Deck 41,671.85 2020 New TRANSCRAFT DROP DECK 6/30/20 Houston
14404 1/1/20 Rental - Drop Deck 42,252.44 2020 New TRANSCRAFT DROP DECK   Houston
14548 4/1/20 Rental - Specialty 42,748.87 2020 New MANAC BOTTOM DUMP   Houston
14580 12/1/19 Rental - Drop Deck 57,964.28 2020 New KALYN SIEBERT Double Drop Deck   Fontana
14593 12/1/19 Rental - Flatbed 55,992.61 2020 New MANAC EXTENDABLE FLATBED   Houston
14597 12/1/19 Rental - Drop Deck 96,322.54 2020 New FONTAINE EXTENDABLE DBLE DROP DECK   Fontana
14601 6/1/20 Rental - Flatbed 28,106.91 2014 Used Wilson Flatbed   Phoenix
14605 1/1/20 Rental - Drop Deck 79,657.20 2021 New FONTAINE EXTENDABLE DBLE DROP DECK   Fontana
14606 6/1/20 Rental - Specialty 82,370.47 2021 New Fontaine Extendable Double Drop Deck   Fontana
14646 12/1/19 Rental - Drop Deck 68,187.70 2016 Used FONTAINE EXTENDABLE DBLE DROP DECK   Fontana
14707 4/1/20 Rental - Specialty 25,532.55 2020 New TRAIL KING MISCELLANEOUS EQUIPMENT 5/31/20 Dallas
14735 4/1/20 Rental - Specialty 39,374.65 2021 New MANAC BOTTOM DUMP   Houston
14763 8/1/20 Rental - Flatbed 28,416.82 2013 Used Utility Flatbed   Fontana
14792 5/1/20 Rental - Flatbed 24,112.08 2013 Used Utility Flatbed 7/31/20 Phoenix
14804 2/1/20 Rental - Flatbed 54,512.43 2020 New FONTAINE EXTENDABLE FLATBED   Fontana
14813 5/1/20 Rental - Specialty 34,107.24 2009 Used TIMPTE HOPPER/GRAIN TRAILER   Dallas
14830 6/1/20 Rental - Flatbed 37,237.44 2018 Used Fontaine Flatbed   Phoenix
15004 8/1/20 Rental - Drop Deck 31,431.98 2012 Used Manac Drop Deck   Phoenix
15190 6/1/20 Rental - Specialty 32,578.12 2021 New Fontaine Flip Axle   Fontana
15191 6/1/20 Rental - Specialty 32,552.82 2021 New Fontaine Flip Axle   Fontana

Task 1

Asset Category Value Description Location Branch
10094
10303
10352 1. Vlookup category, value, description and location using the asset number against the Data tab 2. Once you have all the data in. Add a subtotal at to sum the value of column C 3. Bold font the total amount and add font lines on line 41 4. Apply a filter to the headers 5. Apply freeze pane against the headers
10407
10438
10452
10549
10621
10671
10700
10732
10800
10883
11059
11150
11270
11322
11446
11715
12598
12602
13339
13398
13503
13520
13658
13725
13781
13911
13921
13934
14012
14036
14332
14580
14597
14605
14735
14804

Task 2

1. Pivot the data from Task 1 tab in tabular format into this sheet 2. In your pivot, grab location and value 3. Sort pivot by value from highest to lowest