NIOS Class 10 Data Entry Operation Chapter 8 Formulas, Functions and Charts Solutions to each chapter is provided in the list so that you can easily browse through different chapters NIOS Class 10 Data Entry Operation Chapter 8 Formulas, Functions and Charts and select need one. NIOS Class 10 Data Entry Operation Chapter 8 Formulas, Functions and Charts Question Answers Download PDF. NIOS Study Material of Class 10 Data Entry Operation Notes Paper 229.
NIOS Class 10 Data Entry Operation Chapter 8 Formulas, Functions and Charts
Also, you can read the NIOS book online in these sections Solutions by Expert Teachers as per National Institute of Open Schooling (NIOS) Book guidelines. These solutions are part of NIOS All Subject Solutions. Here we have given NIOS Class 10 Data Entry Operation Chapter 8 Formulas, Functions and Charts, NIOS Secondary Course Data Entry Operation Solutions for All Chapters, You can practice these here.
Formulas, Functions and Charts
Chapter: 8
| INTEXT QUESTIONS |
1. Write True or False for the following statements
(a) Format picture displays all the images properties in a separate window.
Ans: True.
(b) Activate the image you wish to edit by clicking on it once with the mouse.
Ans: True.
(c) Line charts show the proportion of each component value to the total value in a data series.
Ans: False.
(d) Pie charts are useful to compare the trends over time.
Ans: False.
2. Fill in the blanks.
(a) Each autoshape can be rotated by first clicking__________ button on the drawing tool Bar.
Ans: Free rotate.
(b) More __________ effects can be changed using the picture toolbar.
Ans: Picture.
(c) ___________ displays all the image properties in a separate window.
Ans: Format picture.
(d) _____________ show the relative contributions that each data series takes up.
Ans: Area charts.
(e) You have to enter the name of the chart and titles for _____________.
Ans: X,Y axes.
| TERMINAL QUESTIONS |
1. What is the importance of charts and graphics in providing information?
Ans: Charts and graphs help to express complex data in a simple format. They can add value to your presentations and meetings, improving the clarity and effectiveness of your message. Graphs and charts are effective visual tools because they present information quickly and easily. It is not surprising then, that graphs are commonly used by print and electronic media. Sometimes, data can be better understood when presented by a graph than by a table because the graph can reveal a trend or comparison.
2. Briefly explain any five different components of a chart?
Ans: Five different components of a chart are:
(i) The title bar sits at the top of an app on the base layer. Its main purpose is to allow users to be able to identify the app via its title, move the app window, and minimise, maximise, or close the app.
(ii) Axis: The x-axis represents the horizontal dimension and typically corresponds to the independent variable or input. However, the y-axis represents the vertical dimension and usually denotes the dependent variable or output. Together, they form a Cartesian coordinate system to map and analyse data.
(iii) Data series: A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits. Charts in Office are always associated with an Excel-based worksheet, even if you created your chart in another program, such as Word.
(iv) labels and annotations: labels and annotations provides additional context and information to help viewers understand the chart more effectively .
(v) legend: A legend is a description of unusual characters, symbols, or markings on a document. The legend> tag is used in HTML to specify a caption for the fieldset> element. Each data series in a graph is identified by the legend.
3. Explain the process of creating a chart using Chart Wizard dialog box.
Ans: Chart Wizard in Excel is used to apply different charts, which can be Column, Bar, Pie, Area, Line, etc. Chart Wizard, which is now named as Chart in the new version of MS Office, is available in the insert menu tab.
(i) Column Charts: This type of chart is used to compare values across categories. They give very effective results to analyse the data of the same category on a defined scale.
(ii) Line Charts: Data represented in columns or rows in a worksheet can be plotted with the help of a line chart. Line charts can be used to display continuous data over time with respect to a common scale. Thus Line Charts are best suitable for viewing data trends at equal intervals of time. The horizontal axis is used to represent the category data and all the value data is distributed uniformly along the vertical axis.
(iii) Pie charts: In a situation where one has to show the relative proportions or contributions to a whole, a pie chart is very useful. In case of pie chart only one data series is used. Small number of data points adds more to the effectiveness of pie charts. Generally there should be maximum five or six data points or slices in a pie chart. If the points are more in number then it becomes very difficult to interpret the chart.
Also, it is very important to note that the values of to be used in the pie chart must be all positive. If there are some negative values, in that case the negative values will be automatically converted in to positive values, this will be desired.
(iv) Bar Charts: Bar charts are used to show comparisons between individual items. To make a bar chart the data should be arranged in the form of rows and columns on a worksheet.
(v) Area Charts The data which is arranged in the form of rows or columns on a worksheet can be plotted in an area chart. Area charts are used to highlight the degree of a change over time. Area charts are also used to draw attention to the total value across a trend.
4. Briefly explain the following:
(a) Bar charts:
Ans: Bar charts are used to show comparisons between individual items. To make a bar chart the data should be arranged in the form of rows and columns on a worksheet.
(b) Pie charts:
Ans: In a situation where one has to show the relative proportions or contributions to a whole, a pie chart is very useful. In case of pie chart only one data series is used. Small number of data points. adds more to the effectiveness of pie charts. Generally there should be a maximum of five or six data points or slices in a pie chart. If the points are more in number then it becomes very difficult to interpret the chart. Also, it is very important to note that the values to be used in the pie chart must be all positive. If there are some negative values, in that case the negative values will be automatically converted in to positive values, this will be desired.
5. List any four features of Chart Formatting toolbar.
Ans: Four features of Chart Formatting toolbar are:
(i) Chart Elements: This feature lets you add or remove various elements of the chart, such as axes, titles, data labels, legend, gridlines, and trendlines. It provides options for customising the appearance and visibility of these elements.
(ii) Chart Type: This feature enables you to change the type of chart you’re using, such as switching between bar, line, pie, or scatter plot charts. It allows you to experiment with different chart types to best represent your data.
(iii) Chart Layouts: This feature offers predefined layouts for arranging chart elements in different configurations. It allows you to quickly modify the arrangement and formatting of your chart without manually adjusting each element.
(iv) Chart Type: This feature allows you to quickly apply predefined styles to your chart , including different colour schemes , fonts and effects.
6. How do you copy a chart to Word created in Excel 2007?
Ans: In Microsoft Excel 2007 chart wizard is removed and also not brought back in Excel 2010 also. Instead the ribbon is provided as a new place to get your chart related needs fully filled. The buttons on the Insert tab of the ribbon are just the starting point to make a chart. After we get the ribbon it becomes very simple to start making a chart. Whenever we click on some component of a chart, we observe that the Chart Tools are displayed to the ribbon. Three additional tabs which provide a variety of chart design, layout and formatting options, will also be added. First, the Layout tab is used to add all sorts of elements related to the chart or change the way they are shown in the chart. Second, the format tab is used to apply special effects which were not available in the earlier versions of Excel, such as the bevel effect etc. It may be a little difficult to be acquainted with this new type of chart interface, but once you start working, you’ll be proud to show off your professional looking results. It is worth mentioning that you can right click on an element of the chart for quick access to specific features with respect to that particular element e.g. if you right click on any chart axis, you will get the Format Axis dialog box.
7. List any five categories of AutoShapes in Excel.
Ans: Five categories of AutoShapes in Excel are:
(i) Lines: After clicking the Lines button on the AutoShapes toolbar, draw a straight line, arrow, or double-ended arrow from the first row of options by clicking the respective button. Click in the worksheet where you would like the line to begin and click again where it should end. To draw a curved line or freeform shape, select curved lines from the menu, click in the worksheet where the line should appear, and click the mouse every time a curve should begin. End creating the graphic by clicking on the starting end or pressing the ESC key. To scribble, click the last button in the second row, click the mouse in the worksheet and hold down the left button while you draw the design. Let go of the mouse button to stop drawing.
(ii) Connectors: These lines can be used to connect flow elements.
(iii) Basic Shapes: Click the Basic Shapes button on the AutoShapes toolbar to select from many two- and three dimensional shapes, icons, braces, and brackets. Us the drag-and-drop method to draw the shape in the worksheet. When the shape has been made, it can be resized using the open box handles and other adjustments specific to each shape can be modified using the yellow diamond handles.
(iv) Block Arrows: Select Block Arrows to choose from many types of two- and three-dimensional arrows. Drag-and drop the arrow in the worksheet and use the open box and yellow diamond handles to adjust the arrowheads.
(v) Flow Chart: Choose from the flow chart menu to add flow chart elements to the worksheet and use the lines menu to draw connections between the elements. We have drawn a flowchart using lines, flow chart elements and connectors.
8. You are asked to prepare a flow chart. What kind of AutoShapes you would like to use?
Ans: Flowcharts are a great tool for breaking down difficult to understand processes into accessible concepts. Creating a successful flowchart requires you to simplify the information and present it in a clear, concise format. To create a flowchart in Excel, you’ll need to create a grid, set and connect the shapes from the Shapes menu, and add the appropriate text. Similarly, to create a flowchart in Word, you’ll need to insert a canvas, enable a grid, and create and connect shapes from the Shapes menu before adding text.
(i) Lines: After clicking the Lines button on the AutoShapes toolbar, draw a straight line, arrow, or double-ended arrow from the first row of options by clicking the respective button. Click in the worksheet where you would like the line to begin and click again where it should end. To draw a curved line or freeform shape, select curved lines from the menu, click in the worksheet where the line should appear, and click the mouse every time a curve should begin. End creating the graphic by clicking on the starting end or pressing the ESC key. To scribble, click the last button in the second row, click the mouse in the worksheet and hold down the left button while you draw the design. Let go of the mouse button to stop drawing.
(ii) Connectors: These lines can be used to connect flow elements.
(iii) Basic Shapes: Click the Basic Shapes button on the AutoShapes toolbar to select from many two- and three dimensional shapes, icons, braces, and brackets. Us the drag-and-drop method to draw the shape in the worksheet. When the shape has been made, it can be resized using the open box handles and other adjustments specific to each shape can be modified using the yellow diamond handles.
(iv) Block Arrows: Select Block Arrows to choose from many types of two- and three-dimensional arrows. Drag-and drop the arrow in the worksheet and use the open box and yellow diamond handles to adjust the arrowheads.
(v) Flow Chart: Choose from the flow chart menu to add flow chart elements to the worksheet and use the lines menu to draw connections between the elements. We have drawn a flowchart using lines, flow chart elements and connectors.
9. Explain the steps in adding a Clip Art to your worksheet?
Ans: Steps to insert a Clip Art:
(i) Click on Insert Tab.
(ii) From Illustrations Group, Click on Clip Art.
(iii) Then Select a Collection and press Go Button.
(iv) Click on a clip from the collection.
(v) Clip will be inserted in the worksheet.
10. How do you add a photo or graphic to your worksheet from existing file?
Ans: To add a photo or graphic to your worksheet from an existing file in software follow these steps:
Microsoft Excel:
(i) Open your Excel worksheet.
(ii) Click on the cell where you want to insert the image.
(iii) Navigate to the “Insert” tab on the ribbon at the top of the Excel window.
(iv) Click on the “Pictures” or “Illustrations” option, depending on your Excel version.
(v) Browse your computer to locate the image file you want to insert and select it.
(vi) Click “Insert” or “Open” to add the image to your worksheet.
You can then resize and reposition the image as needed by clicking and dragging its edges.
11. What is the main differences between
(a) a column chart. and
(b) a bar chart.
Ans: The differences between a column chart and bar chart are given below:
| Column Charts | Bar Charts |
| This type of chart is used to compare values across categories. They give very effective results to analyse the data of the same category on a defined scale. | Bar charts are used to show comparisons between individualitems. To make a bar chart the data should be arranged in theform of rows and columns on a worksheet. |
| This type of chart is used to compare values across categories. They give very effective results to analyse the data of the same category on a defined scale. | A bar chart is used when you want to show a distribution of data points or perform a comparison of metric values across different subgroups of your data. From a bar chart, we can see which groups are highest or most common, and how other groups compare against the others. |
12. Write a note on SmartArt.
Ans: On the Insert tab, in the Illustrations group, click SmartArt. In the Choose a SmartArt Graphic dialog box, click the type and layout that you want. Enter your text by doing one of the following: Click [Text] in the Text pane, and then type your text.Visual representation of information and ideas is called SmartArt graphics. They can be used to quickly, easily and effectively communicate a message. The facility to create a SmartArt Graphic is available in MS Excel 2007. You can copy and paste SmartArt graphics as images into other programs such as Word and Powerpoint. To create a SmartArt graphic, one has to choose a type for example, Process, Cycle, Hierarchy or Relationship. A type represents a category of SmartArt graphic. Each type is having several different types of layouts.
