Empowerment Technology

LESSON 5 AND 6 ADVANCED SPREADSHEET AND PRESENTATION SKILLS MICROSOFT EXCEL FORMULAS AND FUNCTIONS Three types of information can be typed into a spreadsheet cell 1. LABELS  Text entries Identify values in columns and rows Left-aligned Type an apostrophe (‘) before a number to treat the number like a label. EX. ‘2007 ‘402-6900 2. VALUES Numbers To be used in calculations Right-aligned #### Size the cell larger #### appears if the number is too larger for the size of the cell 3. FORMULAS Used to perform calculations Begin with = sign Type the cell address that contain the values you want to calculate. ARITHMETIC OPERATOR DEFINITION EXAMPLE OF USAGE MEANING   +                                -                 *                                /   ^ Addition Subtract Multiplication Division Exponentiation =B3+C3 =F12-22 =A3*B3 =C3/C6

LESSON 4 TEXT AND IMAGE WRAPPING WORD PROCESSING ·                 Helps people to create attractive &  effective business documents ·           Provides an easy way to edit and enter text ü    Checks spelling and grammar ü    Can add graphics with ease ·           Also known as a document preparation system ·           A program where you can type and print documents ·           Replaced old typewriters APPLICATION AREAS OF WORD PROCESS    BUSINESS-  Legal copies, letterheads, letters, memos circulars etc. EDUCATION-  to develop word processing skills from the very beginning HOME-  Dealing w/ assignments being completed at home or occasionally recreational ·       ADVANTAGES 1.        Faster                                    2.        Can edit documents 3.        Change font style, size, colour 4.        Change layout                           5.        Print many copies 6.        Less noise 7.        Add pi