1. Draw a flowchart and write the pseudocode to print the product of the first 10 even numbers.
(Duration: 30 Minutes)
Ans https://drive.google.com/open?id=0B08RKBSts8D8RkQ5UGk4SzMtRjQ
2.Sam, who is the owner of a theater, has received an Excel sheet containing the profit details. However, he is not able to understand this data. Therefore, he asked Jimmy to represent this data in an understandable format. For this, Jimmy decides to represent the profit data graphically. In addition, he decides to create a column chart. To make the chart presentable, he wants to add the following features in it:
1. The chart title should be Profit of the Year: 2011.
2. The legends should be placed at the bottom of the chart.
3. The chart should be placed along with the data table.
4. The data label should be displayed in the center of each bar. 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.
Ans https://drive.google.com/open?id=0B08RKBSts8D8TlNrcVoxZzJyQWc
3.The data in the Media.xlsx file is arranged according to the movie code. In order to speed up the process, Jimmy decides to arrange the data in the ascending order according to the category and the show type. 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
Ans https://drive.google.com/open?id=0B08RKBSts8D8b1VGazl2UXE0dU0
Ans https://drive.google.com/open?id=0B08RKBSts8D8RkQ5UGk4SzMtRjQ
2.Sam, who is the owner of a theater, has received an Excel sheet containing the profit details. However, he is not able to understand this data. Therefore, he asked Jimmy to represent this data in an understandable format. For this, Jimmy decides to represent the profit data graphically. In addition, he decides to create a column chart. To make the chart presentable, he wants to add the following features in it:
1. The chart title should be Profit of the Year: 2011.
2. The legends should be placed at the bottom of the chart.
3. The chart should be placed along with the data table.
4. The data label should be displayed in the center of each bar. 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.
Ans https://drive.google.com/open?id=0B08RKBSts8D8TlNrcVoxZzJyQWc
3.The data in the Media.xlsx file is arranged according to the movie code. In order to speed up the process, Jimmy decides to arrange the data in the ascending order according to the category and the show type. 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
Ans https://drive.google.com/open?id=0B08RKBSts8D8b1VGazl2UXE0dU0
No comments:
Post a Comment