(Solved) : Chance Cell D14 Without Effecting Cells Around Everytime Change Something Cell Rest Copy W Q37272029 . . .
how do i chance cell D14 without effecting the cells aroundit? Everytime I change something in that cell the rest copywhatever I type. i want to keep the formula the same but justchange the text in D14. thanks!4. Apply a custom format to cell D14 to display the text Units Sold/Price in place of the cell value 2. Create a one-variable data table to calculate sales, expenses, and profits based on the number of wireless headphones sold as follows: a. In cell D5, enter a formula that references cell B4, which is the expected b. In cell ES, enter a formula that references cell B19, which is the expected c. In cell FS, enter a formula that references cell B20, which is the expected d. In cell G5, enter a formula that references cell B21, which is the expected e. Select the range DS:G10 and then complete the one-variable data table, Create a two-variable data table to calculate the gross profit based on the units sold for this product. total sales for this product. total expenses for this product. gross profit for this product. using cell B4 as the Column input cell for your data table. 3. number of wireless headphones sold and the price per unit: a./ For the range D14: K19, create a two-variable data table using the price per unit (cell B5) as the Row input cell. b. Use the units sold (cell B4) as the Column input cell Defined Names Formula Auditing Wireless Headphones- Profit Analysis 25,000 179.00 $ 4,475,000.00 Units Sold Total Sales Total Expenses Gross Profit 25,000 $ 4,475,000 4,010,000$465,000 15,000 $ 2,685,000 $ 2,510,000 $175,000 20,000 3,580,000 $ 3,260,000 $ 320,000 25,000 4,475,000 $ 4,010,000 $ 465,000 0,000 5,370,000 4,760,000 $ 610,000 5,000 6,265,000 5,510,000 $ 755,000 nit nses actured st per Unit ble Costs es Cost tal 25,000 50.00 $ 3,750,000.00 Wireless Headphones-Gross Profit 49.00 $ 159.00 $169.00 179.0 15,000 (275,000.00) (125,000.00) 25,000.00 175,000.0 260,000.00 $4,010,000.00 465000 Wireless Headphones – Gross Profit 159.00$ 169.00 $ 179. 15,000 (275,000.00) (125,000.00) 25,000.00 175,000. 20,000 (280,000.00) (80,000.00) 120,000.00320,000. 25,000 (285,000.00) (35,000.00) 215,000.00 465,000. 30,000 (290,000.00) 10,000.00 310,000.00610,000. 35,000 (295,000.00) 55,000.00 405,000.00 755,000. 149.00 $ 465000 Show transcribed image text 4. Apply a custom format to cell D14 to display the text Units Sold/Price in place of the cell value
2. Create a one-variable data table to calculate sales, expenses, and profits based on the number of wireless headphones sold as follows: a. In cell D5, enter a formula that references cell B4, which is the expected b. In cell ES, enter a formula that references cell B19, which is the expected c. In cell FS, enter a formula that references cell B20, which is the expected d. In cell G5, enter a formula that references cell B21, which is the expected e. Select the range DS:G10 and then complete the one-variable data table, Create a two-variable data table to calculate the gross profit based on the units sold for this product. total sales for this product. total expenses for this product. gross profit for this product. using cell B4 as the Column input cell for your data table. 3. number of wireless headphones sold and the price per unit: a./ For the range D14: K19, create a two-variable data table using the price per unit (cell B5) as the Row input cell. b. Use the units sold (cell B4) as the Column input cell
Defined Names Formula Auditing Wireless Headphones- Profit Analysis 25,000 179.00 $ 4,475,000.00 Units Sold Total Sales Total Expenses Gross Profit 25,000 $ 4,475,000 4,010,000$465,000 15,000 $ 2,685,000 $ 2,510,000 $175,000 20,000 3,580,000 $ 3,260,000 $ 320,000 25,000 4,475,000 $ 4,010,000 $ 465,000 0,000 5,370,000 4,760,000 $ 610,000 5,000 6,265,000 5,510,000 $ 755,000 nit nses actured st per Unit ble Costs es Cost tal 25,000 50.00 $ 3,750,000.00 Wireless Headphones-Gross Profit 49.00 $ 159.00 $169.00 179.0 15,000 (275,000.00) (125,000.00) 25,000.00 175,000.0 260,000.00 $4,010,000.00 465000
Wireless Headphones – Gross Profit 159.00$ 169.00 $ 179. 15,000 (275,000.00) (125,000.00) 25,000.00 175,000. 20,000 (280,000.00) (80,000.00) 120,000.00320,000. 25,000 (285,000.00) (35,000.00) 215,000.00 465,000. 30,000 (290,000.00) 10,000.00 310,000.00610,000. 35,000 (295,000.00) 55,000.00 405,000.00 755,000. 149.00 $ 465000
Expert Answer
Answer to how do i chance cell D14 without effecting the cells around it? Everytime I change something in that cell the rest copy …
OR