Microsoft Certified Application Specialist(MCAS) credential change

According to wendyj, the Microsoft Certified Application Specialist (MCAS) will be rebranded to Microsoft Office Specialist (MOS) at June/2010.

It seems that the new brand (MCAS) like MCITP doesn't heard by many employers.
Many of the employer's still only knows about MCSE but not MCITP (We can find it out from the recruit).


Besides, there are far too more MOSs than MCASs in the world.

Anyway, there will have new logos for the MOS.
About the old MCAS certificates or cards with MCAS logo, you may use them for lighting up the BBQ stove. :)

Office 2010 Code (VBA) Compatability Inspector

To check whether existing VBA codes supported by Office 2010 or not,
instead of re-compiling the VBA codes, Microsoft now offering a new inspector for you.

Gray has written a short guide about on how to use the inspector.
If your macros are password protected, remember to unlock it before launching the inspector.

However, this tools is still in beta. I have encountered serveral false alarm about "Range" objects.

As the tools are in beta, you can send any feedback to the development team.
There is also a sweeptakes on bug reporting.

MCAS Practice Test Excel (70-602) Suggested Solutions

(Last Updated 2010-02-28)
Belows are the suggested solution of the practice test.
The steps below is not the only answer.
There may have other ways or even shortcut leading to the same result.

Part I Q1-Q10 Part II Q11-Q20 Part III Q21-Q25

Question 1.

1. Remove the duplicated entry of Vendor Name(Column B) from the range "A3:K159".
Solution:

1. Highlight the range "A3:K159".
2. Data Ribbon > Data Tools Group > Remove Duplicates
3. Make sure that ONLY the box of "Vendor Name" (or Column B) is checked. (Uncheck all others) and then click on OK.

2. Name the cell range "B4:B107": Vendors.

1. Highlight the range "B4:B107".
2. Formulas Ribbon > Defined Name Group > Define name.
3. Enter "Vendor" in the Name box and then click on OK.

MCAS Practice Test Excel (70-602) Q21~25 of 25

(Last Questions Updated: 2010-02-28)

Here is the Third part of the MCAS Excel Practice Test series
For instructions, please refer to the Part I , Part II

---

Question 21

Complete the following THREE tasks:
1.On the current worksheet, insert a chart that compare the products (Column B) with Total Cost Total (Column C), Sales Amount (Column D) and Profit/Loss (Column E) as a clustered cylinder chart (notes: accept all default settings).
2. Move the chart to new worksheet (notes: accept all default settings).
3. Format the chart on the discounts worksheet with the chart style 10.

MCAS Practice Test Excel (70-602) Q11~20 of 25

(Last Questions Updated: 2010-02-28)


Here is the second part of the MCAS Excel Practice Test series
For instructions, please refer to the Part I , next part: Part III

---

Question 11

Complete the following TWO tasks:
1.Insert a function in cell G2 that counts only those customers owned 2 or more cars "G5:G29".
2.Set the sheet tab color as "Orange, Accent 6, Lighter 40%".