Exercise 9: Pivot Table and Pivot Chart

 DATA


REGION AND ORDER AMOUNT


SALESPERSON AND ORDER AMOUNT

SALESPERSON, MONTH AND ORDER AMOUNT




PIVOT CHART (JANUARY - MARCH)



PIVOT CHART (APRIL - JULY)




Comments

Post a Comment

Popular posts from this blog

Exercise 1: Parts of MS Word (I.T ERA)

Image
  Parts of MS Word Title Bar - It contains the name of application and filename. Menu Bar - It contains the menus to activate the ribbon, group and tabs of commands.  Ribbon - Contains the basic group of related commands. Ruler - This serves as a guide for pagination and margins.  Scroll Bar - This is use to navigate the document. Status Bar - It displays more information about the document such as number of words or characters, lines etc.  Document Window - The text area where you can edit text and insert other elements such as images, drawings, smart art graphics etc. Navigation pane - The window where you can find and replace parts of document. Viewing options - It is use to change viewing mode of documents such as page layout, reading view or full screen, or web layout. Zoom Slide or Zoom Control - It is use to change the viewing size, you can enlarge or minimize by pressing the scroll or + or - button. Display Options - This lets you display or hide the ribbon, ...
Read more

Exercise 11: Intro to MMA (Interactive Multimedia Web page)

Image
How to Design Text in Microsoft PowerPoint About WordArt: WordArt is a feature of PowerPoint that allows you to add effects to text within a text box. The sorts of effects you can add to shapes and text boxes are much the same as those you can add to shapes and text boxes (shadow, bevel, etc.). You may also transform the text in WordArt to make it seem wavy, slanted, or inflated. To apply a WordArt style to text: A WordArt Style will automatically apply several effects to your text at once. You can then refine the look of your text by adding or modifying text effects. 1. Select a text box, or select some text inside of the text box. 2. In the WordArt Styles group on the Format tab, select the More drop-down arrow.  3. WordArt Styles will show as a drop-down menu. Choose a style that you'd want to apply. 4. The specified style will be used to display the text. You may adjust the font or color of the font from the Home tab if you want to. To add or modify text effects: 1. Choose a te...
Read more