Prove it excel normal user hold ctrl and click on the link in blue to access it preparation packs or our power user packs in the first part questions in the style of the interactive test the questions appear in black while the answers below them appear in red. Prove it test answers cheat sheet excel fullexamscom is there a way to run a pivot table on an excel sheet that already has columns filtered thus far ive had to manually copy and paste the sheet into another sheet and then run a filter on that prove it test answers cheat sheet excel . Prove it excel test cheat sheet related files 5f1874068f9711f30a4309c5c50bbf91 powered by tcpdf wwwtcpdforg 1 1. In addition to the prove it tests on microsoft word and microsoft excel kenexa also has exams designed to test typing skills data entry skills and even accounting skills as well as three general aptitude tests numerical reasoning verbal reasoning and logical reasoning the kenexa prove it test will ask you a variety of questions that seek to test your skills and abilities on the . This test will help you demonstrate your abilities with programs like word and excel as well as identifying any particular strengths or weaknesses whats on it the aim of this test is to prove that you have the skills and ability to use microsoft office at your new job without too much guidance or prep