Posts

EXERCISE 8: PAYROLL

Image
Link of the Documents: https://docs.google.com/spreadsheets/d/1xp5Xs2obNbr_ShX44WlvayYeszgh4A7L/edit?usp=sharing&ouid=116894995659397083205&rtpof=true&sd=true  1. Payroll 2. Payroll - Show Formula

EXERCISE 7: Chart, Sorting, Filter, Subtotals

Image
 Link of the Documents https://docs.google.com/spreadsheets/d/1_nngtGri3NAuml5myG1fH7Cb0bqOhF_l/edit?usp=sharing&ouid=116894995659397083205&rtpof=true&sd=true 1. Sort the Data by ID  2. Sort the Data by Name 3. Sort the Data by Loan Amount  4. Filter by Item Type - Sporting Goods  5. Create and Customize a Book Sales Chart 6. Subtotals by Item. Sum Loan Amount (Show Formulas)

EXERCISE 6 : BUDGET AND SUPPLY & CUSTOMER INVOICE

Image
Link of the Document https://docs.google.com/spreadsheets/d/1P2H1lSS7RRT_7tCYg3gY06rKl9rdHpYk/edit?usp=sharing&ouid=116894995659397083205&rtpof=true&sd=true 1. Budget and Supply  2.Budget and Supply - Show Formulas 3. Customer Invoice 4. Customer Invoice - Show Formulas
Image
 Activity 5 https://docs.google.com/document/d/1xlWl3VH1iI2G3ObF_DwXlW9UBY8Exlvo/edit?usp=sharing&ouid=116894995659397083205&rtpof=true&sd=true
Image
 Step 1: Cover page Step 2: Find and Replace Step 3: Header,  Footer and Page Number Step 4: Create Styles Step 5: Table of Contents Step 6: Insert Caption to Images Step 7: Insert table of Figures Step 8:  Insert Footnotes Step 9: Insert Citation Step 10: Bibliography Link of the Document https://drive.google.com/file/d/1nkrMQ1ODhxQYzeUslmOR_SlYbqGzAB0k/view?usp=sharing

EXERCISE 3_SMART GRAPHICS

Image
 

EXERCISE_2 MAIL MERGE

Image
Link of the Document: https://docs.google.com/document/d/1i-5Mjp26tfCC5hYngl7mf8FfkebrPajp/edit?usp=sharing&ouid=116894995659397083205&rtpof=true&sd=true   STEP 1: Creating Mail Merge STEP 2: Letter, Header, and Logo STEP 3: Data Source and Mailing List STEP 4: Inserting Merge Field STEP 5: Preview Result STEP 6: Editing and Existing List   STEP 7: Finish and Merge