ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   excel tests (https://www.excelbanter.com/excel-worksheet-functions/8990-excel-tests.html)

Dave

excel tests
 
What is a good source for some free tests (with answers) that can be used to
test someone's knowledge of excel which could include some basic use of
simple formulae (sum, average, etc) as well as some intermediate functions
(such as if functions) and pivot tables etc.

Thanks in advance

Jason Morin

While I've never seen or taken any of these Excel tests,
you may want to try this site:

http://www.brainbench.com/xml/bb/common/testcenter/

Do a search for "excel".

HTH
Jason
Atlanta, GA


-----Original Message-----
What is a good source for some free tests (with answers)

that can be used to
test someone's knowledge of excel which could include

some basic use of
simple formulae (sum, average, etc) as well as some

intermediate functions
(such as if functions) and pivot tables etc.

Thanks in advance
.


Sir Paul

I designed a spreadsheet to do these basic formulas, but what I wanted my
students to do was look at my spreadsheets and try assess what I was trying
to work out, so they fill in the formulas, get the right answer and the
spreadsheet immediately gives them an answer, works wonders for evaluating
new employees.

email me at and I will send you a copy.

"Dave" wrote:

What is a good source for some free tests (with answers) that can be used to
test someone's knowledge of excel which could include some basic use of
simple formulae (sum, average, etc) as well as some intermediate functions
(such as if functions) and pivot tables etc.

Thanks in advance


BattyXLS

Not many tests with answers but these all have answers that you have to display manually... http://www.ca404.com/tests.html - The Excel and Office tests are free...

Quote:

Originally Posted by Dave (Post 29306)
What is a good source for some free tests (with answers) that can be used to
test someone's knowledge of excel which could include some basic use of
simple formulae (sum, average, etc) as well as some intermediate functions
(such as if functions) and pivot tables etc.

Thanks in advance



All times are GMT +1. The time now is 05:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com