Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Test Questions (MS-Excel 97-2002)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> All

    I was asked to develop a test that would test one's ability with MS-Office.

    I have some cute questions, but I am soliciting some questions, with answers no doubt, that will challenge one's experiences and start them thinking and reaching for a solution.

    What I am looking for is questions such as:

    1) How do you select the whole column?
    2) What is the meaning of the Red Triangle in the Top-Right Corner of a cell? You know that Comment indicator..
    3) What key do you use to make a chart.

    Now these were suggested questions, but I think they are too easy. I need a bit harder questions, so take them as a sample only. I sure would like to know who knows enough about MS-Office as well.

    Thanks

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Test Questions (MS-Excel 97-2002)

    See if the thread starting here <post#=58551>post 58551</post#> triggers some ideas, and search the net for class tests used in various schools.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Test Questions (MS-Excel 97-2002)

    See my reply in Compuserve'sOffice forum
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Test Questions (MS-Excel 97-2002)

    Wassim

    I was given the same task by the company I work for. <img src=/S/bwaaah.gif border=0 alt=bwaaah width=123 height=15>

    Previously to assess Excel skills, they would send out check sheets and questionaires for people to self assess. Based upon the answers it was determined how much additional training time was required to meet the company standard. Unfortunately, most people are not 'honest' with self assessment and unless you watch while they do a paper test you will get a small number who will 'cheat'.

    I created a test of 61 tasks from opening a worksheet to charts and basic functions. The test is timed (40 minutes) and I observe how people are doing. It may be time consuming but you can really tell who knows their stuff and who is struggling. Some assessment software we tried I found was too easy and people were able to figure out the answers without understanding the why and what.

    By having certain tasks to perform on certain worksheets and adding conditional formatting, you can easily see where people really stand. They save the results on the network, I open up their workbook and I can review the results at my leisure. Marking it only takes about 5 minutes per person.

    Good luck to you. <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

  5. #5
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Test Questions (MS-Excel 97-2002)

    What, no array formulas on the test? Well, I think that I would have only gotten 1 out of your 3 questions correct! <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15> If you want to correctly determine MS Office abilities, you really need to administer an Interactive, task-oriented, test such as the MOUS that simulates a real-world/product environment. The MOUS exam is probably too difficult / too expensive. The best alternative that I have found is SAM/TOM from Course Technology. It's only $18 and it provides interactive training (TOM) as well as assessment (SAM). HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •