(Closed) Being tested on excel for interview

posted 7 years ago in Career
Post # 3
Member
1131 posts
Bumble bee
  • Wedding: August 2013

Is this through a job agency? I’ve only ever had to do these through job agencies before.

My main advice is to know what every button in the ribbon does and how to use them. (assuming our using excel 2007 or newer). I’ve done these tests before and always do really well :). good luck!

I’m sorry I have no idea how to explain what the ribbon is if you don’t know… but a quick google search can fix that 🙂

Post # 4
Member
500 posts
Busy bee
  • Wedding: June 2011

hmm, work on formulas, lookup tables, and like the previous poster said, know what the different things in the ribbon are.  Also filters and sorting functionality might be important.

Post # 5
Member
413 posts
Helper bee

Been a long time but I think it’s basic stuff.  They want to make sure you know what a row versus a column is.  Adding data to those.  Typically they have you create a small spreadsheet and most will have you add the columns use the “sum” button as well as creating some basic formula’s. 

If you know the basic 101’s, I wouldn’t be too concerned!

Post # 5
Member
6394 posts
Bee Keeper
  • Wedding: September 2011

What type of job is it? That will depend a lot on what you’re asked to do with Excel. As a basic knowledge level, I would know how to create and sort lists and how to enter formulas.

Post # 6
Member
2103 posts
Buzzing bee
  • Wedding: February 2013

I’ve done these tests and it wasn’t that bad at all. Just familiarize yourself with the features of Excel. Know where all the drop-downs and menus are. And make sure you know at least some basic functions, like organizing (sorting, etc.) and some easy formulas. Good luck!

Post # 7
Member
236 posts
Helper bee
  • Wedding: September 2011

Familiarize yourself with Excel 2007, if that’s what they use! Also, know some basic formulas, like the lookup formulas and maybe some financial ones (maybe the annuity formula? Not sure if you’d be working out payment plans…).  It might be good to play around with the different types of graphs you can make.  And, depending on what you’d be working with, you might want to practice with pivot tables and making sure you can get the data organized the way you want it!

Post # 8
Member
3788 posts
Honey bee
  • Wedding: July 2011

I had to do one when I applied to work for the debt collection company. I was done in literally 2 minutes and when I went to find the supervisor she thought I had a questions. She explained that they often get applicants straight out of high school or older individuals returning to the workforce and that most people who are at all computer literature should be OK. I would think given the entry level sound of the position that you’ll be OK if you are working towards a business degree. Like previous posters said, know all the buttons and how to use them!

Post # 9
Member
629 posts
Busy bee
  • Wedding: October 2011

I had to take an excel test for my current job, and a few of the questions asked me to make a macro that does something to the spreadsheet…and I had NO IDEA how to create macros. 

Post # 11
Member
1183 posts
Bumble bee
  • Wedding: April 2012

They may just be asking you to take the Microsoft Excel exam. In which case you can practice for it on the Microsoft web site if you look up Microsoft Excel in the learning center.

http://www.measureup.com/77-602-MOS-Microsoft-Office-Excel-2007-P2587.aspx

This costs money ($45 but you can look for a promo code—there might be one), but this is what I used for my job (and I got the highest score in the department and went on to become a trainer, so that was cool).

Post # 12
Member
152 posts
Blushing bee

I JUST did one of these a couple weeks ago.  A lot of it was pretty basic, but there were some tough  questions!  I would say just play around with it, know how to do some formulas, know how to sort and filter, that sort of thing. 

Post # 13
Member
1183 posts
Bumble bee
  • Wedding: April 2012

@vcabbyw: Just keep in mind there’s two kinds. There’s the easy peasy kind where most of the target audience/workers are high school graduates (min) with little computer experience, they want like 30-45wpm typing ability, and they really just want you to be competent at using the computer and data entry without screwing anything up (haha). The other kind is where they want you to be able to use the program to format documents for formulas, charting, mail merges, etc…

Macros are small programs that you write in the Basic programming language from within Microsoft Office to quickly accomplish a task. They’re really easy, but intimidating. Personally, I wouldn’t waste too much time learning those now if your test is soon. Each one is very customized, and if you are doing a Microsoft test, then they may only have one or two questions and it won’t kill your score to skip it or get it wrong. And if you are doing a corporate-developed test, they’re not going to want you using them anyway because they don’t want most employees scripting since that’s a virus issue.

I would focus a lot on the formulas, and the complex linking of cells (so when a formula is dependent on a number of cells). Also, correcting errors in formulas or cells. Sorting information, creating charts/graphs, and changing the type of data designation based on the content of the cell are other good things to know too.

They may also ask you to import the Excel data into Word, so you might want to know how to do that.

I’d also want to know how to set your print area and page margins, change the footers and which tabs print, etc.

I can’t see you not being prepared with that type of knowledge. 🙂

The topic ‘Being tested on excel for interview’ is closed to new replies.

Find Amazing Vendors