I Didn't Do Well in Excel Interview Tests - Need Help

sayme

New Member
Joined
Apr 21, 2018
Messages
17
In the past I've gone to financial interviews where my know-how of excel was tested. They asked about SUMIFS, IF statements, vlookup, hlookup. I know the basics behind these. I thought I knew enough of excel. But the test results differ. I'm an intermediate.

I want to know how to prepare for these interview tests. What are the resources to help test my skill level? So far I have excel worksheets with problem and answers that I practice on. What I'm looking for are random excel problems with increasing levels of difficulty (with answers of course) that will test me. Where can I find these tests?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
it can be difficult to know what the examiner is after , I have worked with teams on setting some 30/60 min test for employing staff into a financial team and also a business planning team in an IT company.
I have also been on the other end of tests for interviews etc
Pivot tables, graphs were important as well as interpreting the results.
I hsve also coached a few people privately, who were starting new positions but did not know excel
there are quite a few websites offering tests

what did the test ask for that you did not know
various ways to SUM and Count would be expected
Lookup values
Logic and IF statements
conditional formatting
Pivot tables
Charting
how excel calculates - very important to know the order
Then presentation
Dashboard
 
Upvote 0
it can be difficult to know what the examiner is after , I have worked with teams on setting some 30/60 min test for employing staff into a financial team and also a business planning team in an IT company.
I have also been on the other end of tests for interviews etc
Pivot tables, graphs were important as well as interpreting the results.
I hsve also coached a few people privately, who were starting new positions but did not know excel
there are quite a few websites offering tests

what did the test ask for that you did not know
various ways to SUM and Count would be expected
Lookup values
Logic and IF statements
conditional formatting
Pivot tables
Charting
how excel calculates - very important to know the order
Then presentation
Dashboard

Hey etaf,

Appreciate the response. I have 2 questions for you.....

1) What is a good resource that provide tests to questions with answers with increasing difficulty?

2) Since youve provided staff with tests, would you provide at least 1 test a week for me? Say I want to be tested on IF statements. Would you provide just 1 test so I can solve and you can review? Not asking for much. Just 1 basic test a week.

Appreciate it and looking forward to your response.
 
Upvote 0
The tests I worked on were with a team and also wanted to show very specific skills for how excel was used in the team as a minimum, also being prepared ,for the right person also providing further training and support, the role requires more than just excel manipulation.

search for free excel tutorials and quizzes
This site has a lot of resources
https://www.mrexcel.com/learn-excel-resources/

heres the resources I have used with people when training
https://edu.gcfglobal.org/en/excelformulas/quiz/

full tutorial
https://edu.gcfglobal.org/en/excelformulas/

also on youtube
https://www.youtube.com/playlist?list=PLpQQipWcxwt-1HtGi8YTYTvXCQBFfbKjl

other sites i have used as i learned excel
http://www.cpearson.com/Excel/Topic.aspx

Plus on forums , answering questions is useful teaching aid
have a search on the forums for various questions and try and answer them , see if you get the same answer

providing a test question once a week, would take a bit of resource from myself, as if you get it wrong, i would have to explain why and it will become a teaching exercise, and i doing that for free is quite a commitment
its not just a quiz, but setting up spreadsheets for a scenario and then you completing
have a look at the resources i listed and try the quiz

I also purchased quite a few excel books years ago , Excel for beginners and then the QUE series of books
again your find a lot of books from this site MrExcel
 
Upvote 0

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top