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.

---

Question 22

Complete the following TWO tasks:
1.On the chart of current worksheet, insert a data point display. The data point Labels should position outside the end of data point.
2.Remove the primary horizontal axis title, and then display a rotated title for primary vertical axis title.

---

Question 23

Complete the following TWO tasks:
1.On the current worksheet, sort the table(A3:E13) by the hire date(Column C) in ascending order and then by employee name (Column A) in ascending.
2.Format the image on the right by Bevel picture effect "Divot".

---

Question 24

Complete the following tasks:
1. On the current wokrsheet, insert a function in cell B21 that counts the number of Promotions(A4:A19).

---

Question 25

Complete the following THREE tasks:
1. Convert the text in range A4:A19, which seperated by commas "," into 3 columns.
2. Format the converted range into table with table style style 9.
3. On the current table, apply the first and last column table style.