Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need to know the steps for the following questions: 1. In cell M15, create a dsum formula to determine the total sales for PENS

image text in transcribed

I need to know the steps for the following questions:

1. In cell M15, create a dsum formula to determine the total sales for PENS for the east Region. Use the criteria range starting in cell W1.

2. 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

Inset Dw Page Layout Formulas Data Review View Hep Tel mewhet File Calbr Dh Copy Calculation Form at Panter B 1 u % , |-8-2 | Conditional Format as check Cell Linked Cell Note Formatting Table East SouthWhitman Sofvino Nested Rep IF Unit Cost Total Cost Total ? ? Sheetsheet2Sheet3 - O Type here to search 99 09 29 39 49 59 $ 79 89 eek 99-99-99 00 99 99-99-99-99 29 99 99 9-99 3 3 3 20-3 00 95-9 en al al -al-al aa -ra-ra-ra -ra 1 2 om 12 13 14 15 16 17 18 19 21 22 23 24 25 20 27-28 29 31 32 34 35 36 37 38 39 40 41 42 43 4 5 78 Inset Dw Page Layout Formulas Data Review View Hep Tel mewhet File Calbr Dh Copy Calculation Form at Panter B 1 u % , |-8-2 | Conditional Format as check Cell Linked Cell Note Formatting Table East SouthWhitman Sofvino Nested Rep IF Unit Cost Total Cost Total ? ? Sheetsheet2Sheet3 - O Type here to search 99 09 29 39 49 59 $ 79 89 eek 99-99-99 00 99 99-99-99-99 29 99 99 9-99 3 3 3 20-3 00 95-9 en al al -al-al aa -ra-ra-ra -ra 1 2 om 12 13 14 15 16 17 18 19 21 22 23 24 25 20 27-28 29 31 32 34 35 36 37 38 39 40 41 42 43 4 5 78

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions