Activity 7: Charts, Subtotal, Sorting, Filtering of Data

 

1. Sort by ID:

Smallest to Highest



2. Sort by Name:  

A-Z ascending



3. Sort by Loan Amount 

Z-A Highest to Lowest




4. Filter by Item Type 

Sporting Goods 




5. Create and customize a Book Sales Chart 


6. 

Subtotal  by Item 


Sum by Loan Amount 































Comments

Post a Comment

Popular posts from this blog

Activity 9-10: Video Presentation

Image
https://www.canva.com/design/DAE0KmwW-hI/7fCq_LRauy6VoBFh-GlI4w/view?utm_content=DAE0KmwW-hI&utm_campaign=designshare&utm_medium=link&utm_source=recording_view                           ps sorry for the static noise on the background of my video ma'am i dont know what is              the cause of the noise and i can't fix it neither. i think i'll buy a mic instead for future                   use next time. thank you for understanding ma'am.
Read more

MMA: Interactive Web Page

Image
  SmartArt • SmartArt allows you to communicate information with graphics instead of just using text. • There are a variety of styles to choose from, which you can use to illustrate many different types of ideas. Inserting SmartArt • To insert a SmartArt graphic:   1. Place the insertion point in the document where you want the SmartArt graphic to appear.   2. From the Insert tab, select the SmartArt command in the Illustrations group. selecting the SmartArt command on the Insert tab 3. A dialog box will appear. Select a category on the left,choose the desired SmartArt graphic, then click OK. Creating Cycle Insert – Smart Art Graphics – Cycle-Text Cycle Creating Hieararchy Insert – Smart Art Graphics – Hierarchy – Organization Chart Creating Infographics Insert – Smart Art  Graphics – Process   – Basic Process Quiz Click the link to go directly to the quiz:      https://quizizz.com/admin/quiz/61f6afc30b9f11001d93c15c    
Read more