Excel Test Question Paper needed

**luckyros** · 03-01-2011, 02:59 AM

Hi,

I need to prepare a MS Excel 2007 Test paper on the following things.

1. Vlookup

2. Pivot Table

3. Conditional Formatting

4. Filters

5. Sorting

6. General formulaes such as sum, average, countif etc

7.Validations

I need 2 questions for each point mentioned above. I have some knowledge of excel but preparing a question paper is very dificult for me. Please help me.

**royUK** · 03-01-2011, 04:38 AM

What have you done so far?

**luckyros** · 03-02-2011, 09:24 AM

i have not started with anything thats why i am asking for help here. Please help me or atleast guide me on how to proceed to do the same or provide me with link where i can get help on setting the test paper.

**royUK** · 03-02-2011, 09:39 AM

You aren't actually asking for help, you are asking to us to do it for you. Atleast make an effort & I am sure that you will get lots of help

**royUK** · 03-02-2011, 09:43 AM

I see that you have already asked this question, I suggest that you read the Forum Rules.

A 10 second Google Search came up with this

**Marcol** · 03-02-2011, 09:44 AM

Hmm...?
Just a thought.
If you can't set the test, how do you intend marking it?

**luckyros** · 03-03-2011, 04:19 AM

My intention was not to make a test paper from you but i only need the best source from which i can get help. and thus i thought this forum would be the best source to get help.