Got this during an interview pipeline. How far could you realistically get? What would you look for if you were the test giver?

My opinion is this is a useless test at 30min. You wither get a messy result thay probably hasn't been checked for accuracy or an incompete assignment yielding little to no insight.

Post Photo
like
Posting as :
works at
You are currently posting as works at

I honestly feel like I could complete this in 30m.

likesmart

I just created an Excel based analytics test to hire for a role. It wasn’t testing Excel, but I think my point here will apply. These tests have to be hard enough to have some real variance in assessment between candidates. If it’s easy, then it’s hard to tell just how skilled people are. If designed well, and sufficiently challenging, you can get better data to compare across candidates.

like

The question is whether they look at cleanliness and that it's well structured, or at the correct answer. It's a bit like a coding test in that sense.

like

I think I could do it in 30 min if I wasn’t worried about making it super pretty and user- friendly. I have some free time next week, I might give it a shot. Do you suppose questions b-d are asking for the average value?

Forgot your second question. I have used excel tests to evaluate candidates for a consulting role. I allowed more time, I think 90 minutes, and I explicitly stated that I wanted a “client-ready deliverable”, with documentation and formatting. So I looked at that as much as whether they got the correct answer. In this case, given the short time period, I’d be looking at the problem-solving process the applicant used. How did they structure their solution and what steps did they take to get there? I’d be lenient on “the right answer” and formatting simply because of the time constraints.

They lose all their customers every year? 😁

Related Posts

Hello, has anyone filled in the Forte Fellows Kira video questions?

Are they any different from usual Kira interview questions?

like

Exit interviews, who has access to them? ACN says it's kept within HR and if managers were to ask for them, they'll get turned away. Is that so? Can MD/leadership's from your practice see them?

like

I’ve just passed the final interview for a Business Development Manager position for SaltPay, UK. Does anyone know of the commission structure, KPI’s etc to expect? We didn’t get a chance to discuss it in my other interviews (it’s been a very quick process) . Would love to hear any insights you might have in the company. Thanks!

like

Advice needed - final interview last Friday at one place, heading into final interview at other place next week. If I get an offer at one before final travel interview at other, any suggestions Cont'

For people with Non-technical backgrounds who are now Product managers in the Tech industry, what kind of resources did you use to prep for your interviews? I've had people recommend brushing up on cracking the PM code but there's SO MUCH information out there and it's hard to figure out if I'm looking at the right thing or not. Please share resources that helped you get into PM roles (bonus points if you work at companies like Amazon and Google).

like

In the current lateral market what is the usual time for hearing a decision after a final round of interviews? For context, final round went really well, it’s not even been a week yet, they thought I was a great fit etc, said they’re expanding and looking to hire someone ASAP. Just wanted to know what others’ experiences have been like.

like

in live hirevue interviews, can they tell if you switched tabs? I have a few notes on my computer id like to refer to if possible

like
like

As someone with ADHD, have you ever asked for adjustments to the interview process (PST, case interview, etc.)?

If so, what did you ask for (extra time, or anything else else)? and did you feel like it helped?

likefunny

I have an interview scheduled for technical project management/scrum master at Walmart Global Tech. What to expect and how can I best prepare it for Walmart

hi Recently I had an interview at Airbus for Technology analyst ii role. That was the final round but HR did not give me a number after my expectation and said that they would offer me as per company standard . can you tell me what is the pay scale at this position? this is for e2 level

like

I am appearing for an interview next week for .Net profile. What should I expect in the interview Resume based questions or DS and Algo related questions?

like

If I were to start talking/applying to other agencies in my network, would that news reach the HR department at my current agency and raise alarm bells? Just curious how that works.

like

Is this normal? Have only 2 interviews for my on-site and then would have another “informal chat” with VP if I pass on-site before sending to HC, haven’t read of anyone else with this experience

like

Terrified of lateraling as a 5th year. I feel like I might know less that what my new firm thinks I know. It’s a great firm and a superlative practice group. I went through 12 partner interviews in 4 rounds and am both excited and scared. 3 weeks until I start. Any tips?

like

Does anyone have any interview insights for Grant Thornton? I’m interviewing for CX Specialist and confused why it’s 2 half hour meetings and unsure what to expect or how to prepare.

like

Been in the strat game for over a decade; I’ve realized that a strong department with clear process that is built on end to end problem solving (with time to think) is when I’m happiest vs this award show / case study grind. What are some agencies you all work or have worked at, that value strategy as a department and not a creative case study farm? Looking to figure out what’s next.

like

Hi Big 🐟,

Can somebody refer me into EXL services, As I have got shortlisted on Job ID 568888 but getting no response from their side. It will be more convenient to go through the interview process.
As well I'm looking for a change into O2C(Billing, Cash Application & Contract Management). I have 5 years of experience in the accounting & auditing field.

like

Just finished my 2nd round of interviews with Deloitte for the GPS analyst position. I think they went well but I want more options in case I don’t get an offer. I’m a life sciences graduate from UT Austin, any recommendations? Doesn’t have to be life science/healthcare specific, although that’s my preference.

like

More Posts

When it comes to the digitization of healthcare, how important is it to have tech exp vs. healthcare exp? I understand it’s ideal to have both, but healthcare seems so far behind other industries. Is it better to go into tech for a few years and then go back to healthcare and try to become a change agent?

like

All of us want the same thing! Money- Flex Timing- Great Culture- Respect - Value in what we are doing!
We, the employees make an organization. If all of us want the same thing, how come the culture of that organization still remains the same! Why can’t we be the pioneer? Thoughts…

likeupliftingfunny

Hi all! Just wondering what kind of economics people consult in :). I'm personally a health economist working between pharma clients and NICE

I cleared all my rounds for 2.2 level and shared all my documents on the link HR shared. It's been two weeks and the offer letter is not generated. The HR keeps telling me to wait until Friday and then postpones to next week. Can anyone help me understand this?

like

How is SAP Security Job Market in Canada?

like

one thing I do not do is pick up the phone before 9:30…after 7 years, you would think they’d learn.

likefunny

Hi everyone! I’d love to hear your thoughts on EEO surveys during the job application process. Is it more beneficial to self-disclose or refrain from disclosing race, gender, disability, etc?

Which method is more likely to get your application noticed? Any guidance would be helpful on my job hunt. Thank you.

like
like

Any opportunities for an AD (3yrs experience) in NYC?

like

Does BOA provide welcome kit to new joiners?
If yes, what's that?

like

Just saying... 🤷🏾‍♂️

Post Photo
likesmart

Hi all NICE interactive solutions is hiring for various positions. Anyone interested DM me.

Post Photo

Got an offer for M level at Deloitte UK for one of engineering teams. Need to know the wlb for folks at this level and any other advise that you would like to pass on

like

I have recently joined EY SaT group as senior consultant recently in Netherlands. I’m tripple masters in MS economics, MBA and MS business analytics. Have 4 YOE in different industries but no M&A experience specifically. Any ideas what company should be offering me? I’ll be working as expert on commercial due diligence, FDD and valuation teams and doing automation alongside. is it wise to demand higher salary or promotion soon after I have proven that I can work and do it better than most?EY

likefunny

Is salary credited for KGS today or will it be tomorw

like

What is your total “wedding look” budget/est. spend? (Everything including dress, make up, jewelry, shoes, outfit changes, accessories, etc.). I have put so much emphasis on my looks (no regrets) and I actually just tallied up my spend and my head almost exploded. Frankly just seeking a little validation that I am not the only crazy person out there 🙃

like

Any news about promotions any deadline?

like
like

We’re having a destination wedding and I feel selfish/silly for taking a honeymoon after. But I feel like if we don’t do it then we will put it off and it won’t really feel like a “honeymoon”. What would you do?

like

Hi FIRE friends! My mom is going to get about 250k from the sale of her house in a few days. She’s 58 and has very little saved for retirement (immigrated to the US at 45 so only about 50k in her retirement savings currently). She’s maxing out 401k, Roth IRA, and HSA. I’d love to get all of your thoughts, where do you think she can put the money from the sale of her home?

like

Additional Posts in Excel Genius

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Hi there,
Which Excel courses you recommend for a beginner?

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal