Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help! With the upper northwest corner starting in cell L20, create a 1 variable data table that will give the TOTAL COST and TOTAL

image text in transcribed

Please help!

With the upper northwest corner starting in cell L20, create a 1 variable data table that will give the TOTAL COST and TOTAL SALE of the binders found in cell H11 and I11. The unit cost has been varied from $1.99 to $3.09 by every $0.10.

***I need to make it to where the total cost reflects the changes in the price per unit in column L**

Copy . B 1 u . Ai . !?'A . _ ? ?? ?Merge & Center s-% , '28 28 : Conditional Format as Format Painter Check Cell . Explanatory. Followed Hy... Hyperlink Formatting Table Clipboard Font Number L20 East SouthWhitman West Pencil Binder Pen Set Kivell Sorvino 10 Order Date Region Nested Rep IF Repte 11 7/12/15 Eost 12 7/29/15 East 138/15/15 East Units Unit Cost Total Cost Total Sale Black Black Binder 29 199 57.71 624711 81 1999 1619.19 1752.77 35 4.99 174.65 189.059 250 270.625 16 15.99 255.84 276947 28 8.99 251 72 272.487 64 8.99 575.36 622.627 15 19.99 299 85 324 588 96 4.99 47904 518561 67 129 B6.43 93.5605 4 1599 118326 1280.88 46 8 99 41354 447.657 00 1305 1412.66 4 4.99 19 96 21,6067 19.99 139 93 151 474 50 499 2495 270 084 66 1 99 131.34 142 176 96 4.99 479.04 518 561 53 129 68.37 74 0105 Black Binder Black Pencil Sorvino Desk Pencil: Binder698.1539 Pen Set East Pen Sale 3547.764 893.0625 9/1/15 Central sorvino 2 125.00 15 9/18/15 East 16 10/5/15 Central Sorvino Sorvino Binder 17 10/22/15 East 18 11/8/15 East 19 11/25/15 Central Sorvino Sorvino Pen Set 2012/12/15 Central SorvinoSorvi 2112/29/15 East 221/15/16 Central Sorvino Pen Set Pen Set 91 99 52.09 2/1/16 Central Sorvino Sorvino Binder 242/18/16 East 52.29 3/7/16 West Kivell Binder 49 263/24/16 Central Sorvino Sorvino Pen Set 274/10/16 Central Sorvino Sorvino 28 4/27/16 East Penc $2.59 2.79 52 89 52.99 $3.09 52.79 52.89 52 99 09 29S/14/16 Central SorvinoSorvino Pencil 05/31/16 Central SorvinoSorvino Binder 808.99 7192 778 534 625 676 563 62 499 309.38 334 904 55 1249 686.95 743 623 42 23.95 1005.9 1088.89 825 893 063 1.29 9.03 9.77498 76 199 151 24 163 717 57 1999 1139 43 123343 14 1.29 18 06 19.55 114.99 64 89 59 4184 94 1999 1879 06 2034 08 6/17/16 Central Sorvino Sorvino Desk 5 125.00 Pen Set 337/21/16 Central SorvinoSorvino Pen Set 34 35 8/24/16 West Kivell 36 9/10/16 Central Sorvino Sarvino Pencil 37 9/27/16 West Kive 38 10/14/16 WestKivell 39 10/31/16 Central Sorvino Sorvino Pencil 40 11/17/16 Central SorvinoSorvino Binder 4112/4/16 Central Sorvino 42 12/21/16 Central Sorvino Sorvino Binder 8/7/16 Central Sorvino Sorvino Pen Set 3275 00 Sorvino Binder 284.99 139.72 151 247 SheetSheet2 sheet3 Ready Scroil Lock O Type here to search

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Internal Auditing CIA Part 1 2021

Authors: Muhammad Zain

1st Edition

B09B36MRH2, 979-8542949130

More Books

Students also viewed these Accounting questions