Essentials of IT - NMIMS University MBA Solved Assignments Latest

 

Dear students, get fully solved assignments by professionals

Do send your query at :

help.mbaassignments@gmail.com

or call us at :08263069601

Essentials of IT

April 2023 Examination

 

 

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

 

Ans 1.

Introduction

A pivot table can be called a stats tool that briefs, summarizes, and reorganizes picked rows and columns in a database or spreadsheet to acquire a preferred report. The tool does not alter the database or spreadsheet itself; it just transforms or pivots the information to see it from different perspectives.

Pivot tables work with large quantities of data that would be costly in terms of time to compute by hand. A few information handling works a pivot table can do is recognizing sums, averages,

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

 

 

Ans 2.

Introduction

First  Name	Last  Name	Full name	Region	Met  Sale	Item #	Quantity	Item	Item  Manufacture
							Weigh	d on
				Goal			t
Anurag	Shah	Anurag Shah	West	Yes	115	15	8	07-05-2020
					-74
Vedant	Patel	Vedant Patel	East	No	105	958	7	15-04-2020
					-70

 

 

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)

Ans 3a. 

Introduction

Data	Information
Data is superficial and unorganized truths.	Information consists of arranged, processed data provided in a purposeful context.
Data is a private component consisting of basic materials that do not have any meaning.	Information is a group of data that is collected and brings a rational meaning
	Information calls for data

 

 

b. Write a note on Database Languages that are used to perform different types of operations on an exisiting database  (5 Marks)

Ans 3b.

Introduction

Database languages, additionally data question languages, clarify an explanation of programming languages that programmers use to gain access to and define databases, which are collections of data that customers can access online. These languages enable users to fulfill jobs such as specifying, managing access to data, upgrading

 

 

            Dear students, get fully solved assignments by professionals

Do send your query at :

help.mbaassignments@gmail.com

or call us at :08263069601