Exercise 7 : Chart, Sorting, Filter, Subtotals


Data by ID A-Z smallest-highest


Name A-Z sort ascending



Loan Amount Z-A Sort Highest to Lowest



 Filter by item type


Create and customize a book sales chart.







Comments

Post a Comment

Popular posts from this blog

Exercise 1: Layout and Format Parts of MS Word

Image
Title bar - this displays the document name followed by a program name. Menu bar - this contains a list of options to manage and customize documents. Status bar - this displays the position of the insertion point and working mode buttons. View buttons  - these change the layout view of the document to normal, web layout, print layout, and outline view. Vertical ruler - is often used to adjust the Top and Bottom margins of a document. Vertical scroll bar - it allows you to scroll through the document top to bottom. Quick access toolbar- b y default the Quick Access Toolbar displays the Save, Undo, and Repeat buttons and is used for easy access to frequently used commands. Ribbon - an area across the top of the screen that makes almost all the capabilities of Word available in a single area. Zoom slide - magnifies or reduces the contents in the document window. View buttons - a toolbar that enables, adjusts, and displays different views of a document. Navigation pane - it  helps...
Read more

Exercise 4: Creating Table of Contents, References, Table of figures, Cover page, Header and Footer

Image
Design your header and footer Pick any cover page that you want Highlight the title and change it one by one Change the font size after converting it Create a new style you can find it in style section After finishing the style go to the reference and select the table of contents After finish the table of contents go to the reference click the picture first then click insert caption in the captions section After putting all the caption in each picture go to captions section and click insert table of figures After that insert footnote After that put the bibliography or reference
Read more