This resource contains an interactive quiz (10 questions) with integrated demonstrations of how to apply the following in Excel.
• IF Statement
• Simple Pivot table
This resource follows on from the existing intermediate/advanced Spreadsheets previously listed or can be used as a standalone resource for assessment.
Interactive quizzes are available in htm, swf and pdf formats. There are two quiz/demo options; one showing learner progression as they navigate through the quiz and the other option does not.
The user interface consists of: submit button, play, back, forward, fast forward (enables the user to speed up demonstration sections), rewind (answers cannot be changed). To exit close the browser or software.
Both quizzes have a pass rate of 80%; learners have the option of reviewing their answers at the end of the quiz whether they achieve the 80% pass mark or not.