Microsoft Office Tutorials and References
In Depth Information
Creating shapes and mathematical equations
In this exercise, you’ll create a circle and a rectangle, change the shapes’ formatting,
reorder the shapes, align the shapes, add text to the circle, and then add an equation
to the rectangle.
SET UP You need the Shapes workbook located in the Chapter09 practice file folder
to complete this exercise. Open the workbook, and then follow the steps.
1
On the Insert tab, in the Illustrations group, click the Shapes button, and then click
the oval. The pointer changes to a thin black crosshair.
2
Starting near cell C3 , hold down the Shift key and drag the pointer to approximately
cell E9 . Excel draws a circle.
3
On the Format tool tab, in the Shapes Styles group’s gallery, click the second style.
Excel formats the shape with white text and a black background.
4
On the Insert tab, in the Illustrations group, click the Shapes button, and then click
the rectangle shape. The pointer changes to a thin black crosshair.
5
Starting near cell G3 , drag the pointer to cell K9 . Excel draws a rectangle.
6
On the Format tool tab, in the Shapes Styles group’s gallery, click the first style. Excel
formats the shape with black text, an orange border, and a white background.
7
Click the circle and enter 2014 Revenue Projections . Then, on the Home tab, in
the Alignment group, click the Middle Align button. Excel centers the text vertically
within the circle.
8
On the Home tab, in the Alignment group, click the Center button. Excel centers the
text horizontally within the circle.
Search JabSto ::

Custom Search