NIOS Class 12 Data Entry Operations Chapter 8 Formulas, Functions And Charts

NIOS Class 12 Data Entry Operations Chapter 8 Formulas, Functions And Charts Solutions to each chapter is provided in the list so that you can easily browse throughout different chapters NIOS Class 12 Data Entry Operations Chapter 8 Formulas, Functions And Charts and select need one. NIOS Class 12 Data Entry Operations Chapter 8 Formulas, Functions And Charts Question Answers Download PDF. NIOS Study Material of Class 12 Data Entry Operations Notes Paper 336.

NIOS Class 12 Data Entry Operations 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 12 Data Entry Operations Chapter 8 Formulas, Functions And Charts, NIOS Senior Secondary Course Data Entry Operations Solutions for All Chapter, You can practice these here.

Formulas, Functions And Charts

Chapter: 8

DATA ENTRY OPERATIONS

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 auto shape 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: Charts allow we to present data entered into the worksheet in a visual format using a variety of graph types. Before we can make a chart, we must first enter data into a worksheet. This section explains how we can create simple charts from the data. Formatted charts come in various types for diverse goals, ranging from columns to pics, from lines to surfaces etc.

Graphics: 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 Smart Art Graphic is available in MS Excel 2007. We can copy and paste SmartArt graphics as images into other programs such as Word and Power Point.

2. Briefly explain any five different components of a chart?

Ans. Five different components of a chart are given below:

(i) Chart Title: A title given to the whole chart.

(ii) X-Axis Title: A title given to the X-Axis data range.

(iii) Y-Axis Title: A title given to the Y-axis data range.

(iv) X-Axis Category: These are the categories of the data which have been plotted. These are taken from the first column or first row of our data range.

(v) Y-Axis Value: This is the data range marked to plot the data series.

3. Explain the process of creating a chart using Chart Wizard dialog box.

Ans. Chart Wizard: The Chart wizard guides we through the process of doing a mail merge. This involves creating and editing main document; creating a new data file opening an existing data file and merging the data fields with main document. To use mail Merge Wizard. Select Mailings→Start Mail Merge Subtask from the main tab bar. Then select Step by step Mail Merge Wizard Option on the subtask bar.

The Mail Merge Wizard menu will appear on the screen. This will help we to create mail merge documents in customised step manner. The Wizard has six steps to create a mail merge document.

4. Briefly explain the following:

(a) Bar charts.

Ans. 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.

(b) Pic charts.

Ans. 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 pic chart only one data series is used. Small number of data points add more to the effectiveness of pic charts.

5. List any four features of Chart Formatting toolbar.

Ans. (i) Format button.

(ii) Legend toggle.

(iii) Chart type.

(iv) Data table vies.

6. How do you copy a chart to Word created in Excel 2007?

Ans. Copying the Chart to Microsoft Word:

A finished chart can be copied into a Microsoft Word document or power point slide. Select the chart and click Copy. Open the destination document in Word or a slide in power point and click paste.

7. List any five categories of Autos hapes in Excel.

Ans. (i) Connectors: Lines can be used to connect flow chart elements.

(ii) 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.

(iii) 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 flow chart using lines, flow chart elements and connectors.

(iv) Stars and Banners: Click the button to select stars, bursts, banners and scrolls.

(v) Call Outs: Select from the speech and though bubbles and line call outs. Enter the call out text in the text box that is made.

8. You are asked to prepare a flow chart. What kind of Autos hapes you would like to use?

Ans. 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 flow chart using lines, flow chart elements and connectors.

9. Explain the steps in adding a Clip Art to your worksheet?

Ans. Adding Clip Art: Clip is a single media file, including sound, animation, art or movie.

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.

10. How do you add a photo or graphic to your worksheet from existing file?

Ans. Inserting and Editing a Picture from a File: Follow these steps to add a picture, photo or graphic from an existing file:

(i) Click on Insert Tab.

(ii) From Illustrations Group, Click picture.

(iii) Now select a picture from the location of the picture (where you have stored the picture) and enter or click on insert button.

(iv) The picture is added on the excel sheet. Click on the picture to activate Format tab as shown below along with its ribbon showing groups like Adjust, Picture Styles, Arrange and Size. Use any of the groups to make necessary changes in the picture appearance.

11. What is the main differences between:

(a) a column chart.

Ans. Column Chart: This type of chart is used to compare values across categories. They give very effective results to analyze the data of the same category on a defined scale.

(b) a bar chart.

Ans. 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.,

12. Write a note on Smart Art.

Ans. 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 Smart Art Graphic is available in MS Excel 2007. We can copy and paste SmartArt graphics as images into other graphics as images into other programs such as Word and PowerPoint.

OTHER IMPORTANT QUESTIONS AND ANSWERS