CLASS-10 NIOS DATA ENTRY OPERATION Lesson 8 FORMULAS, FUNCTIONS AND CHARTS

 

Lesson 8

Formulas, Functions and Charts

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

8.7 TERMINAL QUESTIONS

1. What is the importance of charts and graphics in providing information?

Ans: The most valuable tools for charts and graphs, especially charts, are Data and pattern growth that are expressed in different ways. A map is a graphical representation of data in which symbols such as bars in a bar chart, lines in a line chart, or slices in a pie chart represent the details.

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

Ans: The different components of charts are shown below:

1) Bar Charts

2) Area Charts

3) XY (Scatter) Charts

4) Column Charts

5) Lines Charts

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

Ans:

      Go to the Microsoft Office Excel 2007 start-up and scan and open the application.

      In the cells that should be turned into the shape of a map, type your input.

      Pick the set of cells that comprise the data to be charted.

      Click the Map Wizard button on the regular toolbar to construct the chart.

      The Chart Wizard begins by asking what kind of chart to make.

      Pick the form and sub-type of the chart that works best for your results, and then click Next.

      Observe if the map shows the data accurately. If not, use the choice buttons and list boxes to change the chart data at this point. If OK appears on the map, press the Next button.

      Click the Legend tab and clear the checkbox for "Show Legend"

      Click the Data Labels tab, and then click Category Name and Label Value.

      Clear the Display Leader Lines alternative by using a Pie Map, since the pie parts are few and the labels should be clear without leader lines.

      To proceed, press the 'Next' button.

      Click Finish

4. Briefly explain the following:

a. Bar charts,

b. Pie charts,

Ans: a)

Bar charts are a type of graph used for the presentation and analysis of quantities, frequencies or other measures (e.g., mean) for various discrete data categories.

b)

A pie chart is a type of graph reflecting the details in a circle graph. The pie slices represent the relative size of the results. It is a type of data pictorial representation. A pie chart includes a list of variables and graphical variables that are categorical. The word "pie" here illustrates the entire, and the "slices" reflect the bits of the whole.

5. List any four features of Chart Formatting toolbar.

Ans: The four feature of Chart Formatting toolbar is shown below:

      Chart Objects

      Format

      Chart Style

      Data Table

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

Ans:

      Pick the embedded graph or graph sheet that you want to copy to a Word document in Excel.

      Pick the Home tab and then press the Copy button in the Clipboard group.

      Click where you want the copied map to be pasted into the Word text.

      Pick the Home tab and then press Paste from the Clipboard group.

7. List any five categories of AutoShapes in Excel.

Ans: The list of five categories of AutoShapes in Excel is shown below

      Lines

      Connectors

      Basic Shapes

      Block Arrows

      Flow Chart

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

Ans: The list of five categories of AutoShapes in Excel is shown below

      Lines

      Connectors

      3)Basic Shapes

      4)Block Arrows

      5)Flow Chart

 

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

Ans:

      Open the Word document where you want the clip art to be added.

      Click the [Insert] tab > Click [Clip Art] from the 'Illustrations' group. To the right of the paper, a clip art pane will open.

      On the bottom of the pane, click 'Organize clips'.

      Double-click 'Office Sets' on the left-hand menu.

      Double-click any group in which you are involved.

      Place your cursor where you want to insert the clip art in your paper and press the picture from the clip art pane to insert the clip art.

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

Ans:

      Open Excel with Microsoft.

      Open an existing document or launch a new document.

      To pick it, press any cell.

      Click the Insert button at the top of the application page (Excel 2010 shown below).

      Pick an image form you are interested in on the Insert tab: Image, Clip Art, Screenshot, or Picture Album.

      Find and pick the picture you want to embed from your computer, and then press the Insert button.

      You can transfer the image anywhere on the spreadsheet until the image is added. You can also rotate the image by moving the mouse pointer to the image corner and pressing and dragging it to the appropriate height.

11. What is the main differences between (a) a column chart and (b) a bar chart.

Ans:

Feature	Column Chart	Bar Chart
Orientation of bars	Vertical	Horizontal
Display of categories	Y-axis	X-axis
Suitability for long labels	Less suitable	More suitable
Suitability for showing change over time	More suitable	Less suitable

12. Write a note on SmartArt.

Ans: SmartArt is a graphics tool that can be used to create a variety of charts, diagrams, and illustrations. It is included in Microsoft Office applications such as Word, PowerPoint, and Excel. SmartArt graphics are made up of shapes that can be connected to each other to create a variety of layouts. The shapes can be filled with colors and textures, and they can also have borders and shadows. SmartArt graphics can be resized and rotated, and they can also be grouped and ungrouped. To create a SmartArt graphic, you first choose a layout from the SmartArt gallery. The gallery contains a variety of layouts for different purposes, such as process diagrams, organization charts, and cycle diagrams. Once you have chosen a layout, you can add text to the shapes in the graphic. You can also format the shapes by changing their colors, textures, and borders.