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.