1 / 34

2008 November CAT Practical examination Perez Version 9

Learn effective file management strategies including date modification, word processing, proofreading, Excel functions, and mail merge integration for improved productivity and organization.

trangl
Download Presentation

2008 November CAT Practical examination Perez Version 9

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 2008 November CAT Practical examinationPerezVersion 9

  2. File management Perez

  3. 1.12 Date modified FIRST Perez

  4. Word Perez

  5. 2.4 cm3 Superscript Perez

  6. 2.5 Tabs Leading Decimal (Money) Left Perez

  7. 2.9 Accent Insert, Symbol, Normal text Perez

  8. 2.12 Proof reading Transpose Delete Perez

  9. 3.2.2 Outline numbering Level 1 Level 2 Perez

  10. 3.4.2 Split table Click where you want the split

  11. 3.4.4 Inside lines Click the Inside lines

  12. 3.5.2 Sort Cost in rand Select table Descending No header row Perez

  13. Excel Perez

  14. 4.3 Date format Custom format as Month and then Day Type it in yourself Mmm-dd

  15. 4.4 Round and Average Round to 0 decimals Average Perez

  16. 4.6 Nested IF Perez

  17. 5.1.2 Left, Right, Concatenate Left Right Concatenate Perez

  18. 5.1.3 If Perez

  19. 5.1.4 Minutes used in January by Golden clients =SUMIF(K5:K11,"Golden client",D5:D11) Perez 19

  20. Access Perez

  21. 6.2.3 Total number of clients Sorting and Grouping Yes In Group Footer add Formula

  22. 6.3.5 *@* Rule Message Perez

  23. Integration Perez

  24. 7.1.1 Insert chart, then two columns 2 columns Line Select JUST the required text and graph Perez

  25. 7.1.3 Insert linked data Edit Paste Special Microsoft Office Excel

  26. 7.2 Import spreadsheet into database -1/2 File, Get External Data Excel

  27. 7.2 Import spreadsheet into database – 2/2 First Row Contains Column Headings

  28. 7.3 Mailmerge 1/7 Link to data source Open data source on Mail merge toolbar Select data source Mdb

  29. 7.3 Mailmerge 2/7 Link to correct table in data source Select correct table in the database Perez

  30. 7.3 Mailmerge 3/7 Have to select those with correct age

  31. 7.3 Mailmerge 4/7 Get correct age group Advanced Get the correct age

  32. 7.3 Mailmerge 5/7 Sort according to Surname Just click on Surname

  33. 7.3 Mailmerge 6/7 Insert Merge Fields

  34. 7.3 Mailmerge 7/7 Merge to New Document Perez

More Related