CP Lab -Experiment 6

EXPERIMENT NO 6

Aim:  Inserting shapes and images in spreadsheet

Objectives: Demonstrate working with images, shapes, mathematical equations and SmartArt.

Hardware requirements: Any CPU with Pentium Processor or similar, 256 MB RAM or more, 1 GB Hard Disk or more.

Software requirements:  Windows 64 bit / Ubuntu 14 Operating System, MS office 2013

Theory:

Adding Images: One way to add a picture to a worksheet is to display the Insert tab, and then in the Illustrations group, click Picture. Clicking Picture displays the Insert Picture dialog box, from which you can locate the picture you want to add from your hard disk. In this exercise, you’ll add an image to an existing worksheet, change its location on the worksheet, reduce the size of the image, and then set another image as a repeating background for the worksheet.

  1. On the Insert tab, in the Illustrations group, click Picture.
  2. Navigate to the desired folder, and then double-click your image file.
  3. On the Format contextual tab, in the Adjust group, click Remove Background.
  4. Drag the handles at the upper-left and bottom-right corners of the outline until the entire phone, including the cord, is within the frame.
  5. On the Background Removal tab, click Keep Changes.
  6. Move the image to the upper-left corner of the worksheet, click and hold the handle at the lower-right corner of the image, and drag it up and to the left until the image no longer obscures the Call Volume
  7. On the Page Layout tab, in the Page Setup group, click Background.
  8. Navigate to the desired folder, and then double-click the image file of your choice.
  9. Excel repeats the image to form a background pattern
  10. On the Page Layout tab, in the Page Setup group, click Delete Background.

Creating Diagrams by Using SmartArt: To create a SmartArt graphic, on the Insert tab, in the Illustrations group, click SmartArt to display the Choose A SmartArt Graphic dialog box. The following table lists the nine types of diagrams you can create by using the Choose A SmartArt Graphic dialog box. After you click the button representing the type of diagram you want to create, clicking OK adds the diagram to your worksheet.

Here, you’ll create an organization chart, fill in the shapes, delete a shape, add a shape, change the layout of the diagram without changing the information it embodies, and change the formatting of one of the diagram elements

  1. On the Insert tab, in the Illustrations group, click SmartArt.
  2. Click Hierarchy.
  3. Click the first subtype (Organization Chart), and then click OK.
  4. In the Type your text here pane, in the first text box, type CEO, and then press the Down Arrow key.
  5. In the SmartArt diagram, right-click the assistant box, located below and to the left of the CEO shape, and then click Cut.
  1. Click the leftmost shape on the second level of the organization chart, and then type COO.
  2. Click the middle shape on the second level of the organization chart, and then type CIO
  3. Click the rightmost shape on the second level of the organization chart, and then type CFO.
  4. Click the CFO shape. On the Design contextual tab, in the Create Graphic group,in the Add Shape list, click Add Shape Below.
  5. In the new shape, type Comptroller.
  6. On the Design contextual tab, in the Layouts group, click the second layout from the left on the second line of layouts.
  7. Right-click the Comptroller shape, and then click Format Shape.
  8. If necessary, click the Fill
  9. Verify that the Solid fill option is selected, click the Color button and then, in the Standard color area of the color picker, click the red square.
  10. Click Close.

Creating Shapes and Mathematical Equations:

  1. To add a shape to your worksheet, click the Insert tab and then, in the Illustrations group, click the Shapes button to display the shapes available.
  2. When you click a shape in the gallery, your mouse pointer changes from a white arrow to a thin black crosshair.
  3. To draw your shape, click anywhere in the worksheet and drag the mouse pointer until your shape is the size you want.
  4. When you release the mouse button, your shape appears and Excel displays the Drawing Tools Format contextual tab on the ribbon.
  5. You can resize a shape by clicking the shape and then dragging one of the resizing handles around the edge of the shape.
  6. Dragging a handle on a side of the shape lets you drag that side to a new position; dragging a handle on the corner of the shape lets you affect height and width simultaneously.
  7. If you hold down the Shift key while you drag a shape’s corner, Excel keeps the shape’s height and width in proportion as you drag the corner.
  8. To rotate a shape, select the shape and then drag the green circle at the top of the selection outline in a circle until the shape is in the orientation you want.
  9. Click any of the controls in the Structures group to begin creating an equation of that type. You can fill in the details of a structure by adding text normally or by adding symbols from the gallery in the Symbols group.

Conclusion: In this experiment, we have studied working with images, shapes, mathematical equations and SmartArt.

R.No Name of Student Date of Performance Date of Evaluation Grade Sign of student Sign of Faculty
             

Reference Book: Microsoft 2010- Step by step

Leave a Reply

Your email address will not be published. Required fields are marked *