I think I might get 75-90% on this becasue I did everything that was on my last file ( VLOOKUP,IF,SUM, MIN<MAX,basic operations,data validation), but I also had time to annotate my work this time. I inserted a scroll bat which is a Level 7 as well as protecting my sheet.
I disagreed with the peer assessment because, it states that I have not done several thing from level 7 and 6 that I have.
I did my own self assessment and added at least three marks to my peer assessment.
My peer state that I did not protect my worksheet (I did protect the second page in my work book),name cells and ranges (which I did) and that I apparently did not VLOOUP across files ( which I did).
If I could do the exam again, I would have used: conditional formatting, use goal seek and relative and absolute references. I do not know how to do any of level 8 or exeptional performance.
I think I might get 75-90% on this becasue I did everything that was on my last file ( VLOOKUP,IF,SUM, MIN<MAX,basic operations,data validation), but I also had time to annotate my work this time. I inserted a scroll bat which is a Level 7 as well as protecting my sheet.
Exam:
I disagreed with the peer assessment because, it states that I have not done several thing from level 7 and 6 that I have.
I did my own self assessment and added at least three marks to my peer assessment.
My peer state that I did not protect my worksheet (I did protect the second page in my work book),name cells and ranges (which I did) and that I apparently did not VLOOUP across files ( which I did).
If I could do the exam again, I would have used: conditional formatting, use goal seek and relative and absolute references. I do not know how to do any of level 8 or exeptional performance.
Flash Pressentation:
Example:
Flash Practise : Colour Tween
Self Assessment:
Sound file: