Name: Formation CAD
Rating: 4.9 (168 reviews)

Select the checkboxes of the things you master
Access
- Can you create tables?
- Do you understand the importance of the primary key?
- Do you understand the input mask?
- Do you know how to create and change relationships?
- Can you filter and sort data?
- Can you create simple queries and calculated fields?
- Can you use the query generator and create complex queries?
- Do you know how to create forms?
- Can you change a form?
- Can you create reports?
- Can you change a report?
- Êtes vous capable d'insérer des sous-formulaires et sous-états?
- Can you insert subforms and subreports?
- Can you export and import data with or without a link?
- Can you create some macros?
- Can you create a password when you open the database?
Excel
- Are you comfortable creating and editing data in Excel?
- Can you select data?
- Can you insert, delete and hide rows, columns, sheets?
- Can you search for data?
- Can you format data with font, alignment and number value?
- Can you format a table with borders and styles?
- Can you use conditional formatting?
- Can you create a simple formula and calculate a sum?
- Are you comfortable with page layout, including headers and footers?
- Can you make simple statistics?
- Do you know the formulas: FUNCTIONS: TEXT – COUNTIF – SUMIF – DATE&TIME – INT?
- Can you use VLOOKUP?
- Can you create conditional formulas (IF - AND - OR)?
- Do you understand the views?
- Can you sort and filter data?
- Can you use validations?
- Can you delete duplicates entries?
- Can you convert data?
- Do you know how to use name managers?
- Can you create sub-totals?
- Are you comfortable exporting or importing data?
- Can you insert pictures, shapes and comments?
- Can you create a chart and edit it?
- Can you work with multiple sheets and/or multiple workbooks at the same time?
- Do you understand the paste options?
- Can you create a pivot table and edit it?
- Do you know how to protect cells, a sheet or a workbook?
- Do you know how to group data and why?
- Do you know how to create links between sheets or workbooks?
- Are you able to paste link with Word or PowerPoint?
- Can you protect data, sheet or workbook and more?
- Do you know how to open with password or read-only?
- Are you able to analyze a scenario or how to use goal seek?
- Can you create conditional formatting with formulas?
- Are you able to create complex calculated fields and calculated item in a PivotTable?
- Can you group text in a PivotTable?
- Do you know the dynamic array formulas, SUMIFS, REPT, DATEDIF
Outlook
- Can you efficiently categorize Outlook items?
- Are you comfortable sending emails?
- Do you understand the difference between replying to a message or transferring it?
- Can you differentiate between To, Cc and Bcc, Request a Delivery Receipt?
- Do you know how to insert one or more attachments(s)?
- Can you save your attachments?
- Can you create one or more signatures?
- Do you have trouble with views?
- Can you create message templates?
- Can you use and manage the search and sorting function?
- Can you manage spam, create a rule if necessary?
- Can you create folders and file your emails in them?
- Can you file your emails in folders when your emails arrive?
- Do you know how to categorize your messages, contacts or appointments by color categories?
- Can you export or import contacts, messages, calendar, notes?
- Can you use conditional formatting?
- Can you create an appointment and set up a periodic event?
- Can you create a meeting, accept or refuse an invitation?
- Can you track the invitations?
- Can you manage multiple calendars in an overview?
- Can you share your calendar?
- Are you comfortable adding a contact from a message?
- Can you sort your contacts and create a distribution list?
- Can you create a task, assign it by email as needed to follow up?
- Can you manage your journal and notes?
- Are you comfortable with printing of emails, calendars, contacts and notes?
PowerPoint
- Can you create a PowerPoint presentation?
- Can you edit slides?
- Do you understand the different views?
- Do you know all the printing formats?
- Did you know that there are several ways to save a presentation?
- Can you insert tables, charts, images and shapes?
- Do you know SmartArt?
- Are you comfortable with all changes to images, shapes and SmartArt?
- Do you know how to insert headers and footers?
- Do you know how to mask slides and documents, and especially why use it?
- Can you use themes, edit them, save them?
- Do you know how to create notes (comments)?
- Can you create links between your slides and with different files?
- Do you know how to insert linked tables or charts?
- Can you insert a video, sound and image?
- Can you create animations, transitions?
- Can you use duration for animations, transitions?
- Do you know how to view your PowerPoint presentation on the screen?
Teams
- Do you use Teams on a regular basis?
- Can you schedule simple meetings (without Forms)?
- Do you know how to schedule meetings (with Forms)?
- Can you collaborate in a team?
- Are you able to share documents in Teams?
- Do you know the Wiki tab?
- Are you able to create (or administer) self-service teams?
- Do you know of cross-functional applications that can be connected to teams to manage your notes, tasks, etc.?
- Do you understand the SharePoint library and its synchronization?
Word
- Are you comfortable with styles and paragraphs formatting?
- Can you use bullets and numbering?
- Can you create borders and backgrounds?
- Do you know the different views?
- Do you know how to find and replace?
- Do you know how to create tables?
- Would you be comfortable editing your tables?
- Are you comfortable quickly formatting a document using fast styles?
- Can you insert images, shapes and edit them?
- Do you know Quick Parts (automatic inserts) and are you comfortable save them in the galleries?
- Can you improve the presentation of a document with page borders?
- Do you know how to insert watermarks and single-page headers and footers?
- Do you understand section breaks to create complex page headers and footers?
- Can you create tabs?
- Would you be able to use complex mailings?
- Can you create envelopes and labels?
- Can you create a data entry form with new controls?
- Can you create a data form with the old controls?
- Do you know how to protect a document?
- Can you save documents as templates?
- Can you insert objects, such as charts, PDF document with or without link?
- Do you know how to use screenshots?
- Do you know how to create or change styles?
- Can you create and modify a table of contents?
- Can you manage columns in a document?
- Can you create a Bibliography to avoid plagiarism?
- Can you insert footnotes or endnotes?
- Can you create a table of figures?
- Do you know how to index a document?
- Can you efficiently use links, bookmarks and cross-references?
- Can you share a file and track changes?

Save and continue later

Microsoft Office Assessment – Get the right training for you

Microsoft Office English

I'd like to assess:

Select the checkboxes of the things you master

Receive my assessment

Microsoft Office English

I'd like to assess:

Select the checkboxes of the things you master

Receive my assessment

Login