DOEACC NIELIT O Level A1 R4 January 2010 Part Two Question Answer Sample Model Paper Solutions

Ans. 8(b)

Ans. 8(c): LEGENDS: When you create a chart, the legend (legend: A box that identifies the patterns or colors that are assigned to the data series or categories in a chart.) appears by default – unless you specify to hide it in the Chart Wizard. You can also hide the legend or change its ocation in an existing chart.

Show

1. Click the chart sheet or the embedded chart to which you want to add a legend.
2. On the Chart menu, click Chart Options.
3. On the Legend tab, select or clear the Show legend check box to show or hide the legend.
4. Under Click of the Placement options, the legend moves, and the plot area (plot area: in a 2D chart, the area bounded by the axes, the area bounded by the axes, including all data series. In a 3D chart, the area bounded by the aexs, including the data series, category names, tick-mark labels, and axis titles.) automatically adjusts to accommodate it. If you move and size the legend by using the mouse, the plot area does not automatically adjust. When you use the Placement options, the legend loses any custom sizing that you may have already applied by using the mouse. To quickly remove a legend or a legend entry from a chart, you can select it, and then press DELETE. Or you can right-click the legend or legend entry, and then click Clear.

Ans  8(c) : Creating a Range Name in Excel

Adding a range name in Excel

Creating a Range Name:

1. Select cell e.g. C4 in the spreadsheet.
2. Click on the Name Box above column A.
3. Type the word rate
4. Press the ENTER key on the keyboard

Now instead of specifying C4 in any formula,

Ans. 9(a)

Apply a custom animation

1. Select the object you want to animate.
2. On the Slide Show menu, click Custom Animation.
3. In the Custom Animation task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.), click Add Effect and do one or more of the following:\

• If you want to make the text or object enter the slide show presentation with an effect, point to Entrance and then click an effect.
• If you want to add an effect to text or an object that is on the slide, point to Emphasis and then click an effect.
• If you want to add an effect to text or an object that makes it leave the slide at some point, point to Exit and then click an effect.
• If you want to add an effect that makes an object move in a specified pattern. P0oint to Motion Paths the click an effect.

Animating Text to make it appear letter by letter Try adding the typewriter effect to text on you want to animate by clicking it.

1. In Slide View, select the text you want to animate by clicking it.
2. From the Slide Show menu, select custom Animation. The Custom Animation task pane will appear. Click the Add Effect button, Select Entrance, then select More Effects.
3. The Add Entrance Effect dialog box will appear. Scroll down the list and click Color Typewriter. Then click OK>

Ans. 9(b): Every Microsoft Word document is based on a template. A template determines the basic structure for a document and contains document settings such as Auto Text entries, fonts, key assignments, macros, menus, page layout, special formatting, and styles.

Global templates, including the Normal template, contain settings that are available  to all documents. Document templates, such as the memo faxc templates in the Templates dialog box contain settings that are available only to documents based on that template.