MODULE 4

• POWERPOINT PRESENTATION; Used to create and deliver presentation, Visually engaging and interactive, Developed by Microsoft, translate complex ideas, facts, or figures into easily digestible visuals, Text, image, audio, video, animations
• FUNCTIONS (Two types: SIMPLE -has one operation COMPLEX -has one or more operation) Predefined formula in excel that performs calculation
• SUM -Add all the value cells
• AVERAGE -Average of value cells
• COUNT –Counts numerical data in cells
• MAX -Highest value in argument
• MIN -Lowest value in argument
• Types of Sorting: Sort Sheet -Sort data by one column; Sort Range -Sorts data in range of cells
• COLUMN -Uses vertical bars for comparing
• LINE -Connected by lines ideal for trends
• PIE Depicts value of percentage to compare proportions
• BAR -Uses horizontal bars
• AREA -Like line chart but lines below are shaded
• SURFACE- Allows to display 3D landscape for large data sets