Exercise 9: Pivot Table

 

Orquina Caye Renee G.

BEEd 1st Yr.


2. Data information



3. What is the amount sold by each salesperson? Select Region and Order Amount.


4. In the rows area, remove Region with Salesperson and Order Amount.


 


5. Add Region with Salesperson, Month on Column and Order Amount to Columns area.



6. Change the number format of cells to Currency. 


 

7. The result of No. 6


8. Pivot Chart with Salesperson and Order Amount.


9. Pivot Chart with Region, Salesperson and Order Amount.



10. Pivot Chart of Month, Salesperson and Order Amount.




Comments

Post a Comment

Popular posts from this blog

Excercise 2 Mail Merge (Orquina, Caye Renee G.)

Image
Alexandro Paolo Tueres President Alegria Business Associates Manila   Subject: Business Event Invitation Dear Mr. Tueres: It would be a pleasure to have you at the Anniversary Celebration of Orquina Rural Banking, Inc. The event will be held on the 10th of September 2021 at 245 DaangHari, Cavite City, at 8:00 p.m. As one of Orquina Rural Banking, Inc.’s esteemed business associates, it would be our honor to have your presence at this auspicious event. It is also a golden chance to thank you and Mr. Bien Nalog for the splendid business partnership that both companies have enjoyed over the past seven years. The event will have all the jazz with extraordinary performances by various artists, followed by an eclectic and lavish dinner. We would be grateful if you could get your families along with you, to have a gala time. I do hope that you will be able to confirm your attendance to this invitation on or before 5th September by email at reneelious2001@gmail.com or b...
Read more

Exercise 1 Parts of a Microsoft Windows (Orquina, Caye Renee G.) BEEd

Image
The Parts of MS WORD  Title Bar- contains the name of the application and filename. Menu Bar- contains the menus to activate the Ribbon, group, Tabs of commands. Ribbon-contains the basic group of related commands. Ruler-serves a guide for pagination and margins. Scroll Bar- use to navigate in the document. Status Bar- display more information about the document such as number of words or characters, lines, etc. Document Window- the text area where you can edit, text or 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- use to change viewing mode of documents such as page layout, reading view or full screen, or web layout. Zoom Slide or Zoom Control- use to change the viewing size, you can enlarge or minimize by pressing the scrool or + or - button. Display Options- lets you display or hide the ribbon, show tabs and commands. Quick Access Toolbar- lets you add ...
Read more