software

could some one please help ? i have created a workbook that i want to
use for a test system. treat it like a survey and have dropdows that
they pik the answer, and it picks from 1-4 depending on their choice,
and its put on the results worksheet. Then i have a quot;correct or not?quot;
row that has eihter TRUE or FALSE if the student picked the correct
answer according to the answer key (another worksheet)
i want to try and figure out a way that if i make up a 100 questions
and i use this method of having true or false, how can i calculate how
manye false vs true are there and get a percentage?
so if the miseed 4 questions (4 false) then the result is 96%

i am new to this excel world, but im trying to learn, if there is a
eaier way to do this, please advise. thanks in advance...

Ironwig--
Ironwig
------------------------------------------------------------------------
Ironwig's Profile: www.excelforum.com/member.php...oamp;userid=33527
View this thread: www.excelforum.com/showthread...hreadid=533207Use the COUNTIF function to count the number of occurences of False then
divide by the total number of questions and format as a percentage.

Thanks
Delordson Kallon
www.instantsoftwaretraining.com

quot;Ironwigquot; wrote:

gt;
gt; could some one please help ? i have created a workbook that i want to
gt; use for a test system. treat it like a survey and have dropdows that
gt; they pik the answer, and it picks from 1-4 depending on their choice,
gt; and its put on the results worksheet. Then i have a quot;correct or not?quot;
gt; row that has eihter TRUE or FALSE if the student picked the correct
gt; answer according to the answer key (another worksheet)
gt; i want to try and figure out a way that if i make up a 100 questions
gt; and i use this method of having true or false, how can i calculate how
gt; manye false vs true are there and get a percentage?
gt; so if the miseed 4 questions (4 false) then the result is 96%
gt;
gt; i am new to this excel world, but im trying to learn, if there is a
gt; eaier way to do this, please advise. thanks in advance...
gt;
gt; Ironwig
gt;
gt;
gt; --
gt; Ironwig
gt; ------------------------------------------------------------------------
gt; Ironwig's Profile: www.excelforum.com/member.php...oamp;userid=33527
gt; View this thread: www.excelforum.com/showthread...hreadid=533207
gt;
gt;


If you want to learn how to make drop down lists check out these sites

here's a little video to learn datavalidation,

www.datapigtechnologies.com/f...alidation.html

and here is a site to read about data validation and drop down lists

www.contextures.com/xlDataVal01.html--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=533207