locked
EXCEL 2007 Expert Exam 77-851 RRS feed

  • Question

  •  

    1. The syllabus for subject is found at:-

     

    http://www.microsoft.com/learning/en/us/exam.aspx?ID=77-851&Locale=en-us#tab2

     

    2. The first main section is called:-

     

    Capturing Data

     

    3. The first 2 sub sections within:-

     

    Capturing Data

     

     - are:-

     

    Restrict data entry by using data validation.

     

    Link form controls to cells.

     

    4. In the sub section called:-

     

    Restrict data entry by using data validation.

     

     - there is an item called:-

     

    referencing external data in drop-down lists

     

    5. In the sub section called:-

     

    Link form controls to cells.

     

     - there is an item called:-

     

    drop-down

     

    MY QUESTION IS: what's the difference between point number 4. and point number 5. above? (as far as I can see there is no difference).

     

    Thanks in advance for any replies.

     

    Wednesday, April 27, 2011 9:04 AM

Answers

  • Hi,

    In the first you need to understand how you would link to external data and restrict data input in the second you need to understand how you would put these controls in a cell.  So cover different parts of the same thing.

    Kind Regards,

    Ozzy Geoff

    • Proposed as answer by Geoff Clark MCM Wednesday, April 27, 2011 12:12 PM
    • Marked as answer by Rubel Khan Sunday, May 8, 2011 6:39 AM
    Wednesday, April 27, 2011 12:12 PM

All replies

  • Hi,

    In the first you need to understand how you would link to external data and restrict data input in the second you need to understand how you would put these controls in a cell.  So cover different parts of the same thing.

    Kind Regards,

    Ozzy Geoff

    • Proposed as answer by Geoff Clark MCM Wednesday, April 27, 2011 12:12 PM
    • Marked as answer by Rubel Khan Sunday, May 8, 2011 6:39 AM
    Wednesday, April 27, 2011 12:12 PM
  • Geoff, thanks for the quick reply.

    I have already been through item 4 in detail (and have set up a Workbook for it): part of that process is that you have to tie it to a particular cell.

    As far as I can see item number 5 is just a duplication of what has already been done.

    This is the way it currently stands:-

    Capturing Data

    ·         Restrict data entry by using data validation.

    o    This objective may include but is not limited to: referencing external data in drop-down lists, validating data by using formulas, and encircling invalid data

    ·         Link form controls to cells.

    o    This objective may include but is not limited to: scroll bars, check box, label, and drop-down


    This item can be closed. I will probably ask in the EXCEL forum to see if they can throw any light on this.
    • Edited by trip_to_tokyo Thursday, April 28, 2011 9:05 AM added last sentence
    Wednesday, April 27, 2011 12:20 PM