Ans. 7(d)

Microsoft Word offers a number of ways to make a table. The best way depends on how you like to work, and on how simple or complex the table needs to be.

1. Click where you want to create a table.
2. Click Insert Table on the Standard

Drag to select the number of rows and columns you want.

You can also do any of the following:

Use the Insert Table command

Use this procedure to make choices about the table dimensions and format before the table is inserted into a document.

1. Click where you want to create a table.
2. On the Table menu, point to Insert, and then click
3. Under Table size, select the number of columns and rows.
4. Under AutoFit behavior, Choose options to adjust table size.
5. To use a built-in table format, click Auto Format.

Select the options you want.

Draw a more complex table

You can draw a complex table-for example, one that contains cells of different heights or a varying number of columns per row.

1. Click where you want to create the table.
2. On the Table menu, click Draw Table.

The Tables and Borders toolbar appears, and the pointer changes to a pencil. To define the outer table boundaries, draw a rectangle. Then draw the column and row lines inside the rectangle.

1. To erase a line or block of lines, click Eraser on the Tables and Borders toolbar, and then click the line you want to erase.
2. When you finish creating the table, click a cell and start typing or insert a graphic.

• Split cell is used to divide a single cell into two or more cells.

Split a cell into multiple cells in a table

1. Click in a cell, or select multiple cells that you want to split. On the Table menu, click Split Cells
2. Select the Number of columns or rows you want to split the selected cells into.

• Merge cell is used to combine two or more cells into one single cell

Merge cells into one cell in a table

You can combine two or more cells in the same row or column into a single cell. For example, you can merge serval cells horizontally to create a table heading that spans several columns.

1. Select the cells you want to merge.
2. On the Table menu, click Merge Cells

Ans. 8(a)

The three reference operators are the range operator, the union operator and the intersection operator. They’re represented respectively by the characters colon (range), comma (union) and space (intersection). All three are infix operators.

The range operator (colon), which is an infix operator, is used to join two cell references to make a range reference. The resulting range is the rectangle formed by the first operand and the second operand. A1 :D5 defines the range from A1 to D5. The range reference A1 : A1 isn’t illegal – but it’s degenerate. It’s exactly the same as A1. The expression C:C is the (relative) reference to column C.

There are two other reference operators. They’re also used to combine references in ways that produce new references.

The first is the intersection operator (space), which is an infix operator. When it’s inserted between two references, it returns the intersection of those two references. The references can be single cells, ranges, or complex combinations of references constructed with any of the reference operators. They can also be the results of any macro or worksheet function that returns a reference, such as offset or index. The intersection of two ranges is the set of cells that lie in both ranges. It can be either a single cell or a (possibly discontiguous) collection of cells. If two references don’t intersect at all, Excel returns a #NULL! Error value. In Figure 1, the cell C4 is the intersection of B2:C4 and C4:D7 The last reference operator is union, represented by a comma. Like intersection and range, it too is an infix operator and returns a reference, Just as intersection creates and returns the intersection of two references,union creates and returns the union of two references. The union of two references is the collection or cells that lie in either one (or both) of the references. For example, (B:C4,C4:D7) is a reference to all the cells in either of the two rectangular ranges shaded in Figure.

The intersection and union of two ranges. Because the union operator is represented by a comma, which is also used to separate arguments of functions, you usually have to surroound the expression with parentheses to prevent ambiguous interpretation of the expression by Excel. But you can use as many commas as you like within one set of parentheses.

Ans. 8(b)

Rename a sheet

To rename the active sheet, on the Format menu, point to Sheet and then click Rename.

Type the new name over the current name. OR

Right click on the sheet tab and click rename. Type the new name over the current name OR \Double click on the sheet tab, Type the new name over the current name.

Using defined names to represent cells, constants, or formulas A defined name in a formula can make it easier to understand the purpose of the formula. For example. The formula =SUM (FirstQuarterSales) might be easier to identify than =SUM(C20:C30)

Names are available  to any sheet. for example. If the name Projected Sates refers to the range A20:A30 on the name Projected Sale on any other sheet in the same workbook to refer to range A20:A30 on the first worksheet. \Names can also be used to represent formulas or values that do not change (constans). For example, you can use the name Sales Tax to represent the sales tax amount (such as 6.2 percent) applied to sales transactions.

You can also link to a defined name in another workbook, or define a name that refers to cells in another workbook For example, the formula =SUM(Sales.xls! Projected Sales) refers to the named range Projected Sales in the workbook named Sales..

To insert a label follow these steps:

Click on Insert – Name – Label

• Add the range for the label

Ans. 8(d)

1. On the Tools menu, point to Macro, and then click Record New Macro.
2. In the Macro Name box, enter a name for the macro.

Notes

• The First character of the macro Name must be a letter. Other characters can be letters, numbers, or underscore characters. Spaces are not allowed in a macro name: an underscore character works well as a word separator.
• Do not use a macro name that is also a cell referece or you can get a error message that the macro name is not valid.

3. If you want to run the macro by pressing a keyboard shortcut key, enter a letter in the Shortcut key You can use CTRL + letter (for lowercase letters) or CTRL + SHIFT + letter (for uppercase letters), where letter is any letter key on the keyboard. The shortcut key letter you use cannot be a number or special character such as @ or # Note the shortcut key will override any equivalent default Microsoft Excel shortcut keys while the workbook that contains the macro is open.
4. In the store macro in box, click the location where you want to store the macro. If you want a macro to be available whenever you use Excel, select personal Macro Workbook.
5. If you want to include a description of the macro, type it in the Description
6. Click
7. If you want the macro to run relative to the position of the active cell, record it using relative cell references. On the Stop Recording toolbar, click Relative Reference so that it is selected. Excel will continue to record macros with relative references until you quit Excel or until you click. Relative Reference again, so that it is not selected.
8. Carry out the actions you want to record.
9. On the stop Recording toolbar, click stop Recording

Ans. 9(a)

Slide transition is used to provide special effects to the presentation when a slide is changed. These effects can be created to appear at Some popular slide transition effects are checkrbox etc.

Repeat the following process for each slide you want to add a different transition

1. On the Slides tab in normal view, select the slides you want to add a transition to.
2. On the Slide show menu, click Slide Transition.
3. In the list, click the transition effect you want.

Animation is the process of giving animation effects to the objects present on a slide. The objects appears to fly. Move, rotate etc. These effects can be created to appear at different speeds, automatically or on mouse click.

Custom animation: You can animate (animate: To add a special visual or sound effect to text or an object. For example, you can have your text bulet points fly in from the left, one word at a time, or hear the sound of applause when a picture is uncovered.) text, graphics, diagrams, charts, and other objects on your slides so that you can focus on important points, control the flow of information, and add interest to your presentation.

To simplify designing with animations, apply a preset animation scheme (animation scheme: Adds preset visual effects to text on slides. Ranging from subtle to exciting, each scheme usually includes an effect for the slide title and an effect that is applied to bullets or paragraphs on a slide.) to items on all slides, selected slides. Or some items on the slide master (slide master: The slide that stores information about the desing template applied, including font styles, placeholder sizes and postitions, backgournd design. And color schemes.). Or, you can control how and when you want an item to appear on a slide during your presentation – to flyl in form the left when you click the mouse, for example using the Custom Animation task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small siae allow you to use these commands while still working on your files.).

Custom animations can be applied to items on a slide, in a placeholder (placeholders: Boxes with dotted or hatch-marked borders that are part of most slide layouts. These boxes hold title and body text or objects such as charts, tables and pictures.), or to paragraph (which includes single bullets or list items). For instance, you can apply the fly-in animation to all items on a slide on you can apply the fly-in animation to all items on a slide on you can apply it to a single paragraph in a bulleted list, Use entrance, emphasis, or exit potions, in addition to preset or custom motion paths (motion path: The path that a specified object or text will follow as part of an animation seuence for a slide.). Also, you can apply more than one animation to an item: so, you can make that bullet item fly in and then fly out,

Most animation options include associated effects to choose form. These might include optiosn for playing a sound with the animation, and text animations usually let you apply the effect by letter, word, or paragraph (such as having a title fly iin a time instead of all at once).

You can preview the animation of your text and objects for one slide or for the whole presentation.

Ans. 9(b)

EMBEDDED CHARTS: Embedded charts are inserted in the same worksheet in which the tabular data on which the charts is based upon is present. You can place the chart anywhere on the sheet by dragging with moue. You can also change the size that is height and length of the chart that appears on the worksheet.

CHART SHEET: The chart appears in a separate sheet which is called chart sheet. A separate tab is placed along with the tabs of worksheets. The chart sheet consists of only chart whose data may be present on any of the worksheets of the workbook.

LEGENDS: When you create a chart, the legend (legend: A box that identifies the patterns of 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 location in an existing chart.

Show or hide a legend

Click the chart sheet or the embedded chart to which you want to add a legend..

On the Chart menu, click Chart Options.

On the Legend tab, select or clear the Show legend check box to show or hide the legend.

Under Placement, click the option that you want.

Note When you click one of the Placement options, the legend moves, and the plot area (plot area: In a 2-D chart, the area bounded by the axes, including all data series. In a 3-D chart, the area bounded by the axes, 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.

 See Also :

DOEACC NIELIT O Level M1 R4 Previous Year Solved Question Answer Sample Model Paper

Like Our Facebook Page for More CCC Study Material and Notes