Microsoft Certified Application Specialist (MCAS)

A cell style is a defined set of formatting characteristics available in Excel, such as fonts and font sizes, number formats, cell borders, and cell shading. A cell style is used to apply several formats quickly. It also ensures that cells have consistent formatting. Several built-in cell styles are provied by Microsoft Excel that can be applied on cells. Users can also modify these styles to create custom cell styles.

An index is a list of words arranged alphabetically at the end of a book. Index helps a reader to find the information quickly and easily. The words in the index are given along with the page numbers where they occur to help the reader to quickly go to the desired word.

An index is a list of words arranged alphabetically at the end of a book. Index helps a reader to find the information quickly and easily. The words in the index are given along with the page numbers where they occur to help the reader to quickly go to the desired word.

The Microsoft Certified Application Specialist (MCAS) certification is designed to validate skills in using the 2007 Microsoft Office system and the Windows Vista operating system and meeting the demand for the most up-to-date skills on the latest Microsoft technologies. This certification can help you differentiate yourself in today’s competitive job market, broaden your employment opportunities by displaying your advanced skills, and result in higher earning potential. Candidates who successfully complete the program by passing a certification exam show that they can meet globally recognized performance standards.

To get Microsoft Certified Application Specialist (MCAS) certification, you have to pass any one of the following tests:

Color depth is a term that describes the number of bits used to represent the color of a single pixel in a bitmap image. It is also referred to as bit depth, as it is directly related to the number of bits used for each pixel.

Formatting Content

Format text and paragraphs.

• Apply styles.
• Create and modify styles.
• Format characters.
• Format paragraphs.
• Set and clear tabs.

Manipulate text

• Cut, copy, and paste text.
• Find and replace text

Control pagination

• Insert and delete page breaks.
• Create and modify sections.

Creating and Customizing Documents

Create and format documents.

• Work with templates.
• Apply Quick Styles to documents.
• Format documents by using themes.
• Customize themes.
• Format document backgrounds.
• Insert blank pages or cover pages.

Lay out documents.

• Format pages.
• Create and modify headers and footers.
• Create and modify columns.

Make documents and content easier to find.

• Create, modify, and update tables of contents.
• Create, modify, and update indexes.
• Modify document properties.
• Insert document navigation tools.

Personalize Office Word 2007.

• Customize Office Word 2007 options.

Compatibility Checker is one of the most useful features in Word 2007. Word will analyze the document and check for compatibility issues with earlier versions of Word. It’s a good idea to run Compatibility Checker before sending the document if you are not sure whether the recipient uses Office 2007.

For example, if your document contains SmartArt (which is a feature that is not supported in earlier versions of Word), when a colleague using Word 2003 opens your document, the SmartArt graphics will be converted into a single object that cannot be edited.

The MCAS certification is the globally recognized standard for validating expertise with the 2007 Microsoft Office system. Reasons for Microsoft Business Certification include career advancement, personal improvement, skills enhancement, and higher salaries.

The MCAS exams are performance-based and conducted in a “live,” or simulated environment. You have to perform a series of tasks to clearly demonstrate your skills. For example, an Office Word 2007 exam might ask a user to balance newspaper column lengths or keep text together in columns.

Drop cap is used to create a large initial capital letter to spread over multiple lines. The letter expanded in this way is said to be dropped. It adds interest to a newsletter or an article. Drop cap can be used to drop a single letter or word(s) and expand it to multiple lines in a paragraph.

An example of drop cap is shown in the image given below:

Drop caps are often seen at the beginning of novels, where the top of the first letter of the first word lines up with the top of the first sentence and drops down to the four or fifth sentence.

To protect your computer, Microsoft Outlook does not allow you to receive files of certain types (such as .exe files) as attachments, because of their potential for introducing a virus into your computer. These files are blocked by Outlook by default. If Microsoft Exchange is used in your organization, only the e-mail server administrator can unblock these file types. These file types cannot be unblocked by end users of Outlook.

The following file types are blocked by default in Outlook: