Copy__Paste_Empty

xlsx

School

Temple University *

*We aren’t endorsed by this school

Course

3101

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

20

Uploaded by ChancellorFlag13368

Report
Key Terms: Paste - Place the contents of the copied cells into the selected ce Windows Shortcut Keys: Copy Cells = CTRL C Paste = CTRL V Paste Special = CTRL ALT V Cut = CTRL X Mac Shortcut Keys: Copy Cells = Command C Paste = Command V Paste Special = CTRL Command V Cut = Command X Additional Resources: Copy Paste Special Format Painter Summary : Copy and paste will take the contents of a cell or cell r and even transpose data sets. Using the Cut function will take the copy the formatting of a cell and apply the same format to other Copy - Duplicate the contents of a cell or cell range into another c Paste Special - Opening up the paste dialogue box, there are opti Cut - Take the contents of a cell or cell range and place them into Format Painter - Copy the formatting of a cell to another cell or c Link 1 Link 1 Link 1
Copy & Paste ell or cell range. You can also use the "Enter" key to paste cells. range and duplicate it into another cell or cell range. You can copy and paste over values or formulas e contents within a cell or cell range and place it into another cell/cell range. Format Painter will r cell/cell ranges. cell. tions to paste the contents of the cell as values or formulas. You can also transpose a set of cells. o a different cell/cell range. cell range. Double clicking the Format Painter command will keep the format painter command on.
95600
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Date Customer Contact Item # Price Quantity Total 1/1/2021 H&M James 38432 $ 8.99 200 $ 1,798.00 1/1/2021 Patagonia Lacey 58880 $ 6.99 29 $ 202.71 1/3/2021 Abercrombie Cynthia 70606 $ 4.99 31 $ 154.69 1/4/2021 Patagonia Lacey 49863 $ 7.99 94 $ 751.06 1/4/2021 H&M James 65508 $ 4.99 74 $ 369.26 1/7/2021 H&M John 64137 $ 3.99 50 $ 199.50 1/7/2021 Guess Phil 71540 $ 5.99 43 $ 257.57 1/10/2021 American Eagle Karen 33499 $ 5.99 84 $ 503.16 1/10/2021 American Eagle Karen 94669 $ 4.99 99 $ 494.01 1/11/2021 H&M James 21861 $ 7.99 82 $ 655.18 1/12/2021 Guess Phil 55232 $ 9.99 77 $ 769.23 1/15/2021 Patagonia Lacey 61897 $ 9.99 34 $ 339.66 1/16/2021 Guess Phil 76168 $ 7.99 57 $ 455.43 1/16/2021 American Eagle Karen 21557 $ 6.99 70 $ 489.30 1/20/2021 H&M John 85361 $ 8.99 31 $ 278.69 1/23/2021 Patagonia Lacey 26131 $ 8.99 24 $ 215.76 1/24/2021 American Eagle Karen 28475 $ 4.99 70 $ 349.30 1/25/2021 Guess Phil 27680 $ 4.99 92 $ 459.08 1/25/2021 Abercrombie Cynthia 89021 $ 4.99 54 $ 269.46 1/28/2021 Abercrombie Cynthia 72910 $ 3.99 78 $ 311.22 1/30/2021 American Eagle Karen 93909 $ 5.99 50 $ 299.50 1/24/2021 American Eagle Karen 28475 $ 4.99 70 $ 349.30
Instructions: There was a transaction missing in the table provided to the left. Copy the transaction located in row 25 and paste it in row 18.
95600
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Rank Company Revenues ($M) Revenue Percent Change Profits ($M) Rank Profit 1 Walmart $ 523,964 2% $ 14,881 13 2 Amazon $ 280,522 21% $ 11,588 19 3 Exxon Mobil $ 264,938 -9% $ 14,340 14 4 Apple $ 260,174 -2% $ 55,256 2 5 CVS Health $ 256,776 32% $ 6,634 25 6 Berkshire Hathaway $ 254,616 3% $ 81,417 1 7 UnitedHealth Group $ 242,155 7% $ 13,839 17 8 McKesson $ 214,319 3% $ 34 48 9 AT&T $ 181,193 6% $ 13,903 16 10 AmerisourceBergen $ 179,589 7% $ 855 45 11 Alphabet $ 161,857 18% $ 34,343 5 12 Ford Motor $ 155,900 -3% $ 47 47 13 Cigna $ 153,566 216% $ 5,104 29 14 Costco Wholesale $ 152,703 8% $ 3,659 36 15 Chevron $ 146,516 -12% $ 2,924 39 16 Cardinal Health $ 145,534 6% $ 1,363 43 17 JPMorgan Chase $ 142,422 8% $ 36,431 4 18 General Motors $ 137,237 -7% $ 6,732 24 19 Walgreens Boots Alliance $ 136,866 4% $ 3,982 34 20 Verizon Communications $ 131,868 1% $ 19,265 10 21 Microsoft $ 125,843 14% $ 39,240 3 22 Marathon Petroleum $ 124,813 29% $ 2,637 40 23 Kroger $ 122,286 1% $ 1,659 42 24 Fannie Mae $ 120,304 0% $ 14,160 15 25 Bank of America $ 113,589 3% $ 27,430 6 26 Home Depot $ 110,225 2% $ 11,242 20 27 Phillips 66 $ 109,559 -4% $ 3,076 38 28 Comcast $ 108,942 15% $ 13,057 18 29 Anthem $ 104,213 13% $ 4,807 30 30 Wells Fargo $ 103,915 3% $ 19,549 8 31 Citigroup $ 103,449 7% $ 19,401 9 32 Valero Energy $ 102,729 -8% $ 2,422 41 33 General Electric $ 95,214 -21% $ (4,979) 50 34 Dell Technologies $ 92,154 2% $ 4,616 31 35 Johnson & Johnson $ 82,059 1% $ 15,119 12 36 State Farm Insurance $ 79,395 -3% $ 5,593 27 37 Target $ 78,112 4% $ 3,281 37 38 IBM $ 77,147 -3% $ 9,431 22 39 Raytheon Technologies $ 77,046 16% $ 5,537 28 40 Boeing $ 76,559 -24% $ (636) 49 41 Freddie Mac $ 75,125 2% $ 7,214 23 42 Centene $ 74,639 24% $ 1,321 44 43 UPS $ 74,094 3% $ 4,440 32 44 Lowe's $ 72,148 1% $ 4,281 33 45 Intel $ 71,965 2% $ 21,048 7 46 Facebook $ 70,697 27% $ 18,485 11
47 FedEx $ 69,693 7% $ 540 46 48 MetLife $ 69,620 3% $ 5,899 26 49 Walt Disney $ 69,570 17% $ 11,054 21 50 Procter & Gamble $ 67,684 1% $ 3,897 35
Profits Percent Change Assets ($M) Market Value Employees Rank Profit 123% $ 236,495 $ 321,803.30 2,200,000 13 15% $ 225,248 $ 970,680.10 798,000 19 -31% $ 362,597 $ 160,696.30 74,900 14 -7% $ 338,516 $ 1,112,640.80 137,000 2 0% $ 222,449 $ 77,375.80 290,000 25 1925% $ 817,729 $ 442,897.10 391,500 1 16% $ 173,889 $ 236,555.20 325,000 17 -49% $ 59,672 $ 21,845.00 70,000 48 -28% $ 551,669 $ 209,387.50 247,800 16 -48% $ 39,172 $ 18,221.40 21,500 45 12% $ 275,909 $ 798,905.30 118,899 5 -99% $ 258,537 $ 19,150.60 190,000 47 94% $ 155,774 $ 65,896.70 73,700 29 17% $ 45,400 $ 125,907.70 201,500 36 -80% $ 237,428 $ 136,175.90 48,200 39 432% $ 40,963 $ 13,988.10 49,500 43 12% $ 2,687,379 $ 276,750.10 256,981 4 -16% $ 228,037 $ 29,694.70 164,000 24 -21% $ 67,598 $ 40,528.20 287,000 34 24% $ 291,727 $ 222,220.00 135,000 10 137% $ 286,556 $ 1,199,549.70 144,000 3 -5% $ 98,556 $ 15,353.00 60,910 40 -47% $ 45,256 $ 24,113.70 435,000 42 -11% $ 3,503,319 $ 1,841.40 7,500 15 -3% $ 2,434,079 $ 185,226.90 208,131 6 1% $ 51,236 $ 200,665.00 415,700 20 -45% $ 58,720 $ 23,490.00 14,500 38 11% $ 263,414 $ 156,533.30 190,000 18 28% $ 77,453 $ 57,245.20 70,600 30 -13% $ 1,927,555 $ 117,365.70 259,800 8 8% $ 1,951,158 $ 88,376.50 200,000 9 -22% $ 53,864 $ 18,531.60 10,222 41 - $ 266,048 $ 69,406.10 205,000 50 - $ 118,861 $ 29,246.20 165,000 31 -1% $ 157,728 $ 345,704.90 132,200 12 -36% $ 294,823 - 57,672 27 12% $ 42,779 $ 46,574.40 368,000 37 8% $ 152,186 $ 98,551.10 383,800 22 5% $ 139,716 $ 81,705.30 243,200 28 -106% $ 133,625 $ 84,148.60 161,100 49 -22% $ 2,203,623 $ 908.70 6,892 23 47% $ 40,994 $ 34,862.40 56,600 44 -7% $ 57,857 $ 80,196.10 377,640 32 85% $ 39,471 $ 64,963.30 260,000 33 - $ 136,524 $ 231,661.90 110,800 7 -16% $ 133,376 $ 475,455.20 44,942 11
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
-88% $ 54,403 $ 31,679.10 389,500 46 15% $ 740,463 $ 27,996.90 49,000 26 -12% $ 193,984 $ 174,405.40 223,000 21 -60% $ 115,095 $ 271,639.80 97,000 35
Instructions: The table to the left contains a list of Fortune 500 companies. Copy column M (Rank Profit) into column F. Paste the rank profit column as Values. Note: Do not copy the formula into column F.
95600
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Winery 1789 Wines 2Hawk Winery A Blooming HillA to Z Win Street N/A 2335 North Phoen 5195 SW Herge 30835 N. City/State McMinnville, OR Medford, OR Cornelius, OR Newberg, Phone 503-435-7882 541-779-9463 503-992-1196 503-554-1 Winery Street City/State Phone 1789 Wines N/A McMinnville, OR 503-435-7882 2Hawk Winery 2335 North Phoenix Rd. Medford, OR 541-779-9463 A Blooming Hill Vineyard 5195 SW Hergert Rd. Cornelius, OR 503-992-1196 A to Z Wineworks 30835 N. Hwy 99W Newberg, OR 503-554-1918 Abacela Vineyards 12500 Lookingglass Road Roseburg, OR 541-679-6642 Abbey Creek Winery 31441 NW Commercial St. North Plains, OR 503.389.0619 Abiqua Wind Vineyard 19822 McKillop Lp Rd NE Scotts Mills, OR 503-874-9818 ADEA Wine Company 26421 NW Highway 47 Gaston, OR 503-662-4509 Adelsheim Vineyard 16800 NE Calkins Lane Newberg, OR 503-538-3652 Agate Ridge Vineyard 1098 Nick Young Rd. Eagle Point, OR 541-830-3050 Airlie Winery 15305 Dunn Forest Road Monmouth, OR 503-838-6013 Alexana Vineyard & Winery 116 West Main St. Carlton, OR 503-852-3013 AlexEli Vineyard 35803 S. Highway 213 Molalla, OR 503.829.6677 Alloro Vineyard 22075 SW Lebeau Road Sherwood, OR 503-813-0063 Amalie Robert Estate 13531 Bursell Road Dallas, OR 503-831-4703 Amity Vineyards 18150 Amity Vineyards Road Amity, OR 503-835-2362 Anam Cara Cellars 306 North Main St. Newberg, OR 503-537-9150 Anderson Family Vineyard 20120 NE Herring Lane Newberg, OR 503-554-5541 Andrew Rich Wines 801 N. Scott St. Carlton, OR Angel Vine 130 W. Monroe St. Carlton, OR 503-969-7209 Anindor Vineyards 1171 Vintage Drive Elkton, OR 541-584-2637 Ankeny Vineyard 2565 Riverside Dr. S. Salem, OR 503-378-1498 Anne Amie Vineyards 6580 NE Mineral Springs Road Carlton, OR 503-864-2991 Anthony Dell Cellers 250 NE 3rd Street McMinnville, OR 971-218-7040 Antica Terra Winery Amity, OR 503-452-5369 Apolloni Vineyards 14135 NW Timmerman Rd. Forest Grove, OR 503-330-5946 Applegate Red Winery 222 Missouri Flat Rd. Grants Pass, OR Aramenta Cellars 17979 N.E. Lewis Rogers Lane Newberg, OR 503-538-7230 Arborbrook Vineyards 17770 NE Calkins Lane Newberg, OR Arcane Cellars 22350 Magness Rd. NW Salem, OR 503-868-7076 Archery Summit Winery 18599 N.E. Archery Summit Rd Dayton, OR 503-864-4300 Ardiri 35040 SW Unger Road Cornelius, OR 503-628-6060 Argyle Winery 691 Hwy. 99W Dundee, OR 503-538-8520 Armonea 6855 NE Breyman Orchards Rd. Dayton, OR 503-864-3446 Artisanal Wine Cellars 14000 NE Quarry Rd. Newberg, OR 503-554-6766 Ashland Vineyards & Winery 2775 East Main Street Ashland, OR 541-488-0088 Atticus Wine 20501 Russell Creek Rd. Yamhill, OR 503-662-3485 August Cellars 14000 NE Quarry Rd Newberg, OR 503.554.6766 Aurora Colony Vineyards 21338 Oak Lane NE Aurora, OR 503.678.3390 Ayoub Vineyard 9650 NE Keyes Lane Dundee, OR 503-805-2154 503-284-6622 6457 SE Amity Road, 541-846-9422 503-538-0959
Ayres Vineyard 17971 NE Lewis Rogers Ln Newberg, OR Baptista Maresh Vineyards N/A N/A 503-620-3337 Barbara Thomas Wines N/A N/A 503-662-4585 Barking Frog Winery 14000 N. E. Quarry Road Newberg, OR 503-702-5029 Barrel Fence Cellars 8880 Worden Hill Rd. Dundee, OR 503-538-7177 Battle Creek Winery 1242 SE Maple Street Dundee, OR 503-507-8414 Beaux Freres 15155 NE North Valley Road Newberg, OR 503-537-1137 Beckenridge Vineyard 300 Reugen Boise Rd Dallas, OR 503-831-3652 Becker Vineyard 360 Klahowya Lane Roseburg, OR 541-677-0288 503-538-7450
Abacela ViAbbey CreeAbiqua WinADEA WineAdelsheim Agate RidgAirlie WineAlexana ViAlexEli Vin Alloro Vine 12500 Look31441 NW 19822 McK 26421 NW 16800 NE C1098 Nick 15305 Dun 116 West M 35803 S. H22075 SW Roseburg, North PlainScotts Mill Gaston, ORNewberg, Eagle PointMonmouthCarlton, O Molalla, O Sherwood, 541-679-6 503.389.0 503-874-9 503-662-4 503-538-3 541-830-3 503-838-6 503-852-3 503.829.6 503-813-0 Instructions: A raw data table is provided above. You would like to transpose the data so that the information can be read from the top down instead of left to right. Copy and paste the cell range B1:AX4, transposing the information into the grayed cells A8:D56. Make sure the data being pasted lines up with the column headers provided.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Amalie RobAmity VineAnam Cara Anderson FAndrew RicAngel VineAnindor ViAnkeny VinAnne Amie Anthony D 13531 Burs18150 Ami 306 North 20120 NE H801 N. Scot130 W. Mo 1171 Vinta2565 River 6580 NE M 250 NE 3rd Dallas, OR Amity, OR Newberg, Newberg, Carlton, O Carlton, O Elkton, ORSalem, OR Carlton, O McMinnvil 503-831-4 503-835-2 503-537-9 503-554-5 503-969-7 541-584-2 503-378-1 503-864-2 971-218-7 503-284-66
Antica Ter Apolloni V Applegate Aramenta CArborbrookArcane Cel Archery SuArdiri Argyle WinArmonea 14135 NW 222 Missou 17979 N.E.17770 NE C22350 Mag18599 N.E.35040 SW 691 Hwy. 6855 NE Br Amity, OR Forest GroGrants PasNewberg, Newberg, Salem, OR Dayton, ORCornelius, Dundee, ODayton, OR 503-452-5 503-330-5 503-538-7 503-868-7 503-864-4 503-628-6 503-538-8 503-864-3 6457 SE Am 541-846-94 503-538-09
Artisanal WAshland ViAtticus Wi August Cel Aurora ColAyoub VineAyres VineBaptista MBarbara T Barking Fr 14000 NE Q2775 East 20501 Russ14000 NE Q21338 Oak 9650 NE Ke17971 NE LN/A N/A 14000 N. E Newberg, Ashland, OYamhill, O Newberg, Aurora, ORDundee, ONewberg, N/A N/A Newberg, 503-554-6 541-488-0 503-662-3 503.554.6 503.678.3 503-805-2 503-620-3 503-662-4 503-702-5 503-538-74
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Barrel FencBattle Cre Beaux FrerBeckenridgBecker Vineyard 8880 Word 1242 SE M 15155 NE N300 Reuge 360 Klahowya Lane Dundee, ODundee, ONewberg, Dallas, OR Roseburg, OR 503-538-7 503-507-8 503-537-1 503-831-3 541-677-0288
95600