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%".

---

Question 12
Please download the Excel first, the EditGrid can't display shapes.

Complete the following TWO tasks:
1.Connect the shape "Partial College" to shape "High School" with an arrow of 3PT width. 
2.Copy the "CustomerEdProfile" worksheet to a new workbook.

---

Question 13

Complete the following THREE tasks:

1.In Range country code "D4:D184", change the conditional formatting (Red Color) so that it is applied where the cell value is equal to US.
2.Clear all conditional formattings from current worksheet.
3.Create a custom list contain the following words: "US","CA","DE","UK","AU".

---

Question 14

Complete the following TWO tasks:

1.On the current worksheet, apply the Opulent theme colors to the existing theme.
2.Protect the worksheet with password mcas, with allowing users to edit the content in range "D4:D20".

---

Question 15

Complete the following THREE tasks:
1.format the range A3:E17 on the current worksheet with table style medium 4 (Notes:accept all default settings).
2.Apply conditional formating 3 symbols (Circled) to the range changes (E4:E17).
3.Filter the table(A3:E17) to display Changes(E4:E17) values with cross icon only.

---

Question 16

Complete the following FIVE tasks:
1.Format the chart on the current worksheet with the chart style style 41.
2.Resize the chart, set width as 9cm and height as 10cm.
3.Format the range C3:C11 with table style style medium 1.
4.Enable totals row for the table in C3:C11.
5.Modify the cell C12 in totals row to use the Average function.

---

Question 17

Complete the following TWO tasks:
1.On the USDExRate worksheet, insert a formula in cell D4 that display the text yes if the average exchange rate of ARS in 2003 C4 is higher than that in 2003 B4 otherwise the text no should be displayed.
2.Display the formula in the current worksheet.

---

Question 18

Complete the following FOUR tasks:
1.In the cell D6, insert a formula that multiply the value in C6 to absolute referenced value in exchange rate F2.
2.Copy the formula of cell D6 to range D7:D12.
3.Remove all the comments from the table A5:A12.
4.Save the workbook with the filename TirePriceEuro in the default working folder so that it is compatible with earlier versions of Excel. (Note: Accept all other default settings.)

---

Question 19

Complete the following task:
1.on the current worksheet, insert a function in cell E2 that sum the number of cars. owned (E6:E55) for only those customer with an occupation (B6:B55) of Clerical.

---

Question 20

Complete the following task:
1.On the current worksheet, insert a function in cell G3 that references the value in cell G2 and returns the associated state name (C4:C380) from the cell range B4:C380 based on an exact match.