Nmims April,May 2023 Customized Assignments-Create a Pivot Table based on the information given in the worksheet which depicts the sales (in thousands) of Havdairy ice-cream flavours across cities in the month of April. Create a standalone PivotChart based on the given information. Present the total and sales across the different cities
Nmims April,May 2023 Customized Assignments-Create a Pivot Table based on the information given in the worksheet which depicts the sales (in thousands) of Havdairy ice-cream flavours across cities in the month of April. Create a standalone PivotChart based on the given information. Present the total and sales across the different cities
Nmims April,May 2023 Customized Assignments-Create a Pivot Table based on the information given in the worksheet which depicts the sales (in thousands) of Havdairy ice-cream flavours across cities in the month of April. Create a standalone PivotChart based on the given information. Present the total and sales across the different cities
Nmims April,May 2023 Customized Assignments-Create a Pivot Table based on the information given in the worksheet which depicts the sales (in thousands) of Havdairy ice-cream flavours across cities in the month of April. Create a standalone PivotChart based on the given information. Present the total and sales across the different cities
Nmims April,May 2023 Customized Assignments-Create a Pivot Table based on the information given in the worksheet which depicts the sales (in thousands) of Havdairy ice-cream flavours across cities in the month of April. Create a standalone PivotChart based on the given information. Present the total and sales across the different cities
Essentials of IT
Create a Pivot Table based on the information given in the worksheet which depicts the sales (in thousands) of Haidari ice-cream flavors across cities in the month of April. Create a standalone PivotChart based on the given information. Present the total and sales across the different cities (10 Marks)
TABLE BELOW
Flavors
City A
City B
City C
City C
Butterscotch
25
25
35
63
Vanilla
36
36
24
45
Strawberry
24
45
35
87
Chocolate
45
64
83
36
Kesar-Pisa
64
63
69
24
Blackcurrant
35
85
45
35
Choco-Almond
85
69
87
85
Tender
Coconut
69
57
35
69
Mango
57
36
52
24
Guava
63
24
45
45
Kala Jamun
45
45
64
64
Chicco
87
64
63
75
Refer to the table below to perform the tasks mentioned below: (10 Marks)
a. Use Conditional formatting to highlight the quantity which is greater than 200
b. Use the slicer tool to filter data based on the item weight
c. Use an appropriate text function to combine the first name and the last name and display the results
d. Use the color scale option and format the Item Weight. What does this indicate?
e. Use the strikethrough option ti mark out those dates that are between 07-05-2020 and 14-08-2020
f. Explain the difference between SUM (), SUMIF () and SUMIFS () with an example
REFER TO THE TABLE BELOW
First
Name
Last
Name
Region
Met Sale Goal
Item #
Quantity
Item
Weight
Item
Manufactured on
Anurag
Shah
West
Yes
115-74
15
8
07-05-2020
Vedanta
Patel
East
No
105-70
958
7
15-04-2020
Semithin
Rastogi
South
Yes
117-74
22
10
14-08-2020
Jaspreet
Nair
North
Yes
121-49
69
12
30-04-2020
Perak
Iyer
West
Yes
121-54
3
7
10-05-2020
Keshav
Hari
East
No
122-71
71
10
02-05-2020
Pavan
Sathe
North
Yes
120-49
113
8
14-08-2020
Tushar
Rego
East
No
122-71
532
7
14-08-2020
Shezil
Malhotra
North
Yes
119-36
212
11
13-04-2020
Hiren
Bhatia
West
No
107-35
371
10
02-05-2020
Shailendu
Shroff
East
Yes
104-55
147
10
13-04-2020
Pratik
Patel
West
Yes
113-65
79
8
10-05-2020
Mihir
Ashar
South
Yes
104-36
48
8
14-08-2020
Utkarsh
Chajjed
North
Yes
114-68
78
12
23-04-2020
Jigar
Nath
West
No
120-37
54
8
17-04-2020
Answer the questions that follow:
Explain the difference between data and information. Explain the need for databases. What are the advantages of using Database Management Systems (DBMS) to manage data? (5 Marks)
Write a note on Database Languages that are used to perform different types of operations on an existing database (5 Marks)
We at Case Study offer all types of online academic assistance, be it homework help, coursework help, case study help, Assignment help, Project Reports, Thesis, Research paper writing help.
And for each service, each subject and each topic, we dedicate an expert writer who has knowledge in that specific field of study. Experience impeccable academic writing service like never before.
Our experts understand that the time of the customers is very precious. The professors of universities and colleges are very rigorous about the submission deadlines of projects or assignments. Hence, the key objective of our case study help service is to deliver the assignments to the customers even before the promised submission deadlines.
We keep the quality measures for all papers which mean we will provide best essays. Our editing services are also excellent. Before submitting any essays, we will check whether the papers writer well or not. The high standards of academic writing will exceed your expectations. With our quality service, we have satisfied more number of people across the world and also work with different universities in Australia, UK, USA, Dubai, Oman, etc.