1.Create a flowchart and write a pseudocode to display the square of first 10 natural numbers.
(Duration: 40 Minutes)
Ans https://drive.google.com/open?id=0B08RKBSts8D8SnlnVmlBdE41a2c
2.Jimmy has created a pivot table and has shown it to the theater owner. However, the owner is not able to understand this data. Therefore, to make this data understandable, Jimmy decides to create a chart to represent the required information graphically. The theater owner wants to view the graph for each category separately. Instead of creating a graph for each category manually, Jimmy decides to create a pivot chart. Help Jimmy to accomplish the required task.
Prerequisite: To perform this exercise, you need to use the Media.xlsx file. For this, you need to click the Media.zip link and save file as Media.zip. Further, unzip it and use the Media.xlsx file to complete your exercise. (Duration: 40 Minutes)
Ans https://drive.google.com/open?id=0B08RKBSts8D8Nm1keXhCdktqX1U
3.Jimmy's instructor has asked him to create a Category wise summary report. This report should contain the total ticket cost incurred according to the Show Type filed values. All the information should be visible clearly. For this, Jimmy wants to use a pivot table. Help Jimmy to accomplish the required task.
Prerequisite: To perform this exercise, you need to use the Media.xlsx file. For this, you need to click the Media.zip link and save file as Media.zip. Further, unzip it and use the Media.xlsx file to complete your exercise. (Duration: 40 Minutes)
Ans https://drive.google.com/open?id=0B08RKBSts8D8Z3JtaHZjb1pxenM
Ans https://drive.google.com/open?id=0B08RKBSts8D8SnlnVmlBdE41a2c
2.Jimmy has created a pivot table and has shown it to the theater owner. However, the owner is not able to understand this data. Therefore, to make this data understandable, Jimmy decides to create a chart to represent the required information graphically. The theater owner wants to view the graph for each category separately. Instead of creating a graph for each category manually, Jimmy decides to create a pivot chart. Help Jimmy to accomplish the required task.
Prerequisite: To perform this exercise, you need to use the Media.xlsx file. For this, you need to click the Media.zip link and save file as Media.zip. Further, unzip it and use the Media.xlsx file to complete your exercise. (Duration: 40 Minutes)
Ans https://drive.google.com/open?id=0B08RKBSts8D8Nm1keXhCdktqX1U
3.Jimmy's instructor has asked him to create a Category wise summary report. This report should contain the total ticket cost incurred according to the Show Type filed values. All the information should be visible clearly. For this, Jimmy wants to use a pivot table. Help Jimmy to accomplish the required task.
Prerequisite: To perform this exercise, you need to use the Media.xlsx file. For this, you need to click the Media.zip link and save file as Media.zip. Further, unzip it and use the Media.xlsx file to complete your exercise. (Duration: 40 Minutes)
Ans https://drive.google.com/open?id=0B08RKBSts8D8Z3JtaHZjb1pxenM
No comments:
Post a Comment