AprilMay 2023 NM unique assignments Explain the differenc

Nmims 2023 Customized Assignments Contact
[email protected]
www.mbacasestudyanswers.co
m
ARAVIND 09901366442 09902787224

Essentials of IT

1. 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 (10 Marks)

TABLE BELOW
Flavours 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-Pista 64 63 69 24
Blackcurrent 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
Chickoo 87 64 63 75

2. 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 colour 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
Vedant Patel East No 105-70 958 7 15-04-2020
Smithin Rastogi South Yes 117-74 22 10 14-08-2020
Jagprit Nair North Yes 121-49 69 12 30-04-2020
Prerak 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

3. Answer the questions that follow:
a. 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)
b. Write a note on Database Languages that are used to perform different types of operations on an existing database (5 Marks)

Nmims 2023 Customized Assignments Contact
[email protected]
www.mbacasestudyanswers.co
m
ARAVIND 09901366442 09902787224