Class-X-Solved Exercise:
Unit-8 Spreadsheet (Intermediate)
Session-8 Create, Modify and Format Charts
Session-9 Sort and Filter Data
Session-10 Calculate and Link Data Across Worksheets
I. Objective Type Questions:
1. Fill in the blanks:
a. _____ are visual representations of worksheet data.
Answer: Charts
b. The charts that are included in the worksheet are called as _____ charts.
Answer: Embedded
c. A ______ chart shows trends and variations in data over time.
Answer: Line
d. A ______ chart displays the contribution of each value to the total.
Answer: Pie
e. A _____ chart emphasizes the comparison between items at a fixed period of time.
Answer: Bar
f. ______ are useful to show the data values for a line, column or pie in a chart.
Answer: Data series
g. With the help of ______ command button you can sort worksheet data in a particular order.
Answer: Sort & filter
h. The _________ tools is useful to filter data from a column that matches a particular criteria.
Answer: Filter
i. _______ allows to use data from another worksheet.
Answer: Link
2. Write T for true and F for false against the statement.
a. Filter helps to extract particular data using some conditions.
Answer: T
b. The custom option allows to perform more complex filtering.
Answer: T
c. Charts cannot be formatted using colours, alignment, fonts, and other formatting attributes.
Answer: F
d. Pie charts contain more than one data series.
Answer: F
e. The options to improve the design of a chart are present under the insert tab.
Answer: F
f. While selecting the worksheet data to create a chart, the data labels like name of the subjects etc. must not be included.
Answer: T
g. F11 function key automatically creates a chart of the selected worksheet data.
Answer: T
h. Worksheets in different folders cannot be linked.
Answer: F
i. A formula cannot have a linked worksheet cell location.
Answer: F
j. There should not be any blank row within datasheet to be sorted.
Answer: T
II. Multiple choice questions. Tick the correct answer.
1. Which tab contains options to insert a chart on a worksheet?
a. home b. insert c. file d. data
Answer: Insert
2. A Pie chart is created
a. using only one data series b. using two data series c. using any number of data series d. all of these
Answer: Using only one data series
3. Which chart displays a series of points that are connected over time?
a. column chart b. pie chart c. line chart d. bar chart
Answer: Line chart
4. What is the keyboard shortcut(button or buttons to be pressed) for creating a chart from the selected cells?
a. F3 b. F5 c. F7 d. f11
Answer: F11
5. Which statement is not true for sorting operation?
a. There should not be any blank row within datasheet to be sorted.
b. Sorting can only be done on one column
c. Sorting can be done in ascending as well as descending order.
d. Headings should not be part of datasheet.
Answer: Heading should not be part of datasheet
6. Which statement is not true for linking worksheet.
a. Source and destination sheet location must not be changed.
b. Formulas can use linking.
c. Worksheet should not be in different folders.
d. Linked formulas are protected by default.
Answer: Source and destination sheet location must not be changed.
III. Short Answer Questions.
1. Anil wants to show a trend or relationship over time in a graphical way, which type of chart he should create?
Answer: Line chart
2. Malti is a teacher. She has just finished typing her class list in excel. Now she wants to arrange the list of names in alphabetical order but not able to find the sorting command. Suggest the command to sort data to her.
Answer: Sort & Filter
3. Write shortcuts for performing the following task:
a. To Create a chart of the selected worksheet.
Answer: F11
4. Differentiate between
a. Column chart and Bar chart b. Pie chart and Doughnut chart
Answer:
a. Column chart: A column chart uses vertical bars or columns to display values over different categories. They are excellent tools for showing variations in value over time.
Bar chart: A Bar chart is similar to a column chart except these use horizontal instead of vertical bars.
b. Pie chart: A Pie chart display the contribution of each value to the total Pie charts contain just one chart data series.
Doughnut chart: A doughnut chart is similar to a pie chart except for its ability to display more than one data series.
5. What is a chart?
Answer: Charts are useful to display data values visually. One of the most important features of MS excel is a chart. Charts are visual representations of worksheet data.
6. Name any 5 types of charts that are created in Excel.
Answer: Types of charts:
1. Column chart
2. Line chart
3. Pie chart
4. Bar chart
5. Area chart
7. How will you create a chart?
Answer:
1. Enter the graph data.
2. Select the graph data
3. Select a chart type
4. Select a chart layout from the design tab
5. Add the title of the chart
6. Add titles for the horizontal and vertical axis
7. Add data labels
8. Format the chart
8. When do we prefer to create a Pie chart?
Answer: Pie chart: A Pie chart display the contribution of each value to the total Pie charts contain just one chart data series.
They are a very effective way to display information when you want to represent different parts of the whole, or the percentages of a total.
9. What are the two ways of sorting charts of a worksheet?
Answer: There are two ways of sorting charts: Ascending and descending order
10. What is the use of Legends in a chart?
Answer: A Legend identifies a data series. It describes a data series represented in a particular color on the chart.
11. What is sorting?
Answer: Sorting is a feature in excel 2007 that helps you arrange the selected data either in an ascending or descending order.
12. What is filter?
Answer: Filter is a feature used for extracting particular data using some conditions.
13. Compare a line graph and a bar graph.
Answer: Line graph: Line graphs illustrate the relationship between two major variables.
Bar graph: Bar graphs are used to highlight separate quantities. They are useful for comparing quantities within or among categories.
14. For what purpose XY(scatter) charts are useful?
Answer: The XY charts are useful for showing a correlation among the data points that may not be easy to see from data alone. An XY chart uses numeric values along both axes instead of values along the vertical axis and categories along the horizontal axis.
Some other links:
No comments:
Post a Comment