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