Proof of Liking, Commenting and Subscribing in MMA

Graphic Design

Proof of liking, commenting and subscribing in Living in IT Era

Functions - Sum, Average, IF, VLOOKUP

Sorting Data, Filtering Data, Subtotal and Groupings.

Sort ID, highlight everything that you will sort. Go to data and then sort. There's a option, sort assembly and sort disassembly. Sort ID from cell values ascending (smallest to largest) ( highest to lowest).

Next, sorting according to customer name. 

Sort by loan amount. 

Creating subtotals by item type sum by loan amount. 
click data, go to subtotal (outline group) 
sum loan amount per item type, summary below data. 
Sort by item type again (A to Z)
Next subtotal, include subtitle from the sum to loan amount. Replace current subtotal any put a summary below data. 

 

Pivot Table and Pivot Chart

Chart

We just need data for the chart. Go to insert, click charts then choose your desired type of chart. You can modify the chart area and put title and on the chart area there's different layout, layout with table values with chart and you can change the color. You can switch between row and column. You can move into a new worksheet and edit your chart according to your want. 
 

Parts of Ms Word

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 more frequent used toolbars for easy access.
 

Compute Sales Invoice and Inventory and Supplies

 

Activity 4: Text Decoration

 

Microsoft Word

Link: https://youtu.be/6yfJ1olR9zg
 

MS Word Manual

MS Word Manual

STEP by STEP PROCEDURES

1.) Design your cover page

2.) Insert Citation 

3.) Put Header and Footer 

4.) Put table of contents.