need the answer only plz ...solve these excel problems
Chapter10: Financial Statements And Reports
Section: Chapter Questions
Problem 3.3C
Related questions
Question
need the answer only plz ...solve these excel problems
![Question 2: Please write the formula to calculate the total number of units sold
on 26th February - 7th March, 2020. *
g
Question 3: Write the VLOOKUP formula to find the price per unit, by referencing
the date values in column A.
Your answer
Question 4: What would be the steps in incorporating the data in the referenced
table into a PIVOT table, grouping them by months?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F16fc3339-b7f0-422f-a05c-908124002570%2Fd23db2d6-6635-4abd-84de-ee4a43a182aa%2Fsjaacg8_processed.png&w=3840&q=75)
Transcribed Image Text:Question 2: Please write the formula to calculate the total number of units sold
on 26th February - 7th March, 2020. *
g
Question 3: Write the VLOOKUP formula to find the price per unit, by referencing
the date values in column A.
Your answer
Question 4: What would be the steps in incorporating the data in the referenced
table into a PIVOT table, grouping them by months?
![A
Date
Units
Price per unit
1
2/26/20
1300
3
2/27/20
190
2/28/20
16
128
2/29/20
10
399
3/1/20
410
7
3/2/20
1
870
3/3/20
7
1990
3/4/20
15
653
10
3/5/20
600
11
3/6/20
4
808
12
3/7/20
1950
13
3/8/20
9.
833
Question 1: Please write the formula to calculate the total price of items sold on
26th February - 7th March, 2020. *
B.
2.
4,
CO
9,](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F16fc3339-b7f0-422f-a05c-908124002570%2Fd23db2d6-6635-4abd-84de-ee4a43a182aa%2Fl5huwcf_processed.png&w=3840&q=75)
Transcribed Image Text:A
Date
Units
Price per unit
1
2/26/20
1300
3
2/27/20
190
2/28/20
16
128
2/29/20
10
399
3/1/20
410
7
3/2/20
1
870
3/3/20
7
1990
3/4/20
15
653
10
3/5/20
600
11
3/6/20
4
808
12
3/7/20
1950
13
3/8/20
9.
833
Question 1: Please write the formula to calculate the total price of items sold on
26th February - 7th March, 2020. *
B.
2.
4,
CO
9,
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you