NMIMS Global Access
School for Continuing Education (NGA-SCE)
Course: Essentials of IT

Internal Assignment Applicable for December 2020 Examination

1. Describe the different types of charts available in Excel. What is the importance of
using charts in Excel? Below is the data in ice-cream survey. Use a pie-chart to plot the
percentage share of each flavor of ice-cream in the total frequency.

TABLE BELOW

Ice-cream flavor Frequency
Butterscotch 12
Chocolate 14
Strawberry 12
Vanilla 13

(10 Marks)

2. Conditional formatting is used to create rules (conditions) for when and how specific
cells are formatted. For example, make cells red, if an expiry date has passed, or color
cells green, if they match numbers in a lottery draw. Use conditional formatting on the
table mentioned below and answer the following questions Q2a-Q2e. Represent your
answer with a screen shot for each question answered.
Rep
Name Region

Met Sale Goal
? Item # Quantity
Item
Weight
Item
Manufactured on
Amit West Yes 115-74 15 8 07-05-2020
Varun East No 105-70 958 7 15-04-2020
Burzeen South Yes 117-74 22 10 14-08-2020
Binoy North Yes 121-49 69 12 30-04-2020
Prerak West Yes 121-54 3 7 10-05-2020
Keshav East No 122-71 71 10 02-05-2020
Khalid North Yes 120-49 113 8 14-08-2020
Mayur East No 122-71 532 7 14-08-2020
Shantanu North Yes 119-36 212 11 13-04-2020
Sajal West No 107-35 371 10 02-05-2020
Shailendu East Yes 104-55 147 10 13-04-2020
Aditya West Yes 113-65 79 8 10-05-2020
Mihir South Yes 104-36 48 8 14-08-2020
Utkarsh North Yes 114-68 78 12 23-04-2020
Jigar West No 120-37 54 8 17-04-2020
a) With the help of conditional formatting select those cells from the Met Sale Goal as
Yes. Add another level of formatting and format cells which belong to the region
North. Highlight them in Green.

b) Add a new rule in the conditional formatting and highlight those quantity values that
are greater than 300
c) Use the colour scale option and format the Item Weight. What does this indicate?
d) Highlight all the items manufactured in the last week.
e) Highlight today the date 14-08-2020 on which certain items are manufactured.
(10 Marks)

3.a. Below is the data on sales and advertising expenditure in millions for an organization.
Draw a plot and trend line for sales and advertising expenditure. What can you say
about the relationship between sales and advertising expenditure? (5 Marks)

3.b. 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?

Sales Advertising Expenditure
10 2
24 4
20 5
30 6
38 7
32 8
50 10
48 12
62 15

(5 Marks)