Description
For Nmims Assignments Contact
[email protected]
+91 95030-94040
Essentials of IT
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
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
For Nmims Assignments Contact
[email protected]
+91 95030-94040
doc_902035088.docx
For Nmims Assignments Contact
[email protected]
+91 95030-94040
Essentials of IT
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
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
For Nmims Assignments Contact
[email protected]
+91 95030-94040
doc_902035088.docx