What's the most in-depth Excel-related question you've been asked during an interview?

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

Are you comfortable with vlookups? 

likefunny

If you’re asking whether I know how to do them, the answer is yes…if you’re really asking whether I’m comfortable with them, it is an emphatic no…

like

A zinger could be “Walk me through when you would use the FLOOR function rather than ROUNDDOWN? How about CEILING versus ROUNDUP?”

likefunnysmart

Just for funsies, maybe throw in an INT and TRUNC as well!

I’ve been asked if I know what a vlookup or pivot table is…that’s about it.

In my interviews it’s been more about how comfortable I feel working backwards in Excel. Not necessarily creating anything crazy, but understanding the existing formulas in their sheets and understanding what data it’s pulling

like

why would you do a vlookup in 2024 though

index-match and xlookup are so much better

like

Create your own equation in excel from column A (Names) and C (Amount) where there is no common column and the goal is to match the right name to right amount with an equation!

like

I’d have to ask for clarification on that one…not sure I follow

likefunny

How to create Custom Lists using excel’s native features

I had to do a simple demo of it on a shared screen. Simple enough a high schooler could easily pass with an A

Related Posts

I applied for a role a few days ago and found the relevant hiring manager today via LinkedIn. Should I send a follow up mail/introduce myself to this person. Would it leave a good impression or come across as desperate?

Btw, the person is in a “Talent Acquisition” position at the company.

like

Hello, anyone here who can guide regarding the interview process and preparation for Google Cloud Migration Consultant role?
Do they have the hiring committee and team match processes for India hiring as well or is it more straightforward?

Recruitment team has reached out and scheduled the first round and I am extremely nervous!!!*bites nails*

like

In how many days, BDO rise give reply to your interview 2nd round? Anyone here from BDO rise here?

Do you tell the recruiters what clients have you been on? Or just the industry? I was under the impression that u don’t mention the name of the clients or am I wrong?

like

Almost a week with On-site interview and it’s been a radio silence from my recruiter. Should I reach back to them or is it normal? Not at all impatient, just trying to know what’s the norm.

like

So I've had 2 hiring managers and several recruiters from Amazon reach out to me about applying for some open positions with the company (android). I completed the coding assessment and now they want me to go through a round of 5 hour interviews next week. Is there a good chance I'll be hired if engineering managers are reaching out to me? I'm really not sure how badly I want to work for them and I don't want to be laid off months after being hired on. Anyone know what Amazon hiring is like?

like
like

Looking for a casing buddy! Fairly new to casing and come from a science background not business. 2nd round BCG interview coming up. :)

like

Anyone have tips on writing a cover letter without referring to anything in the resume?

like

Failed interview at McKinsey + Bain… Feeling very de-motivated for this upcoming grad cycle. At what point do I give up/think I’m not cut out for this?

like

Any recommendation after 13 years experience in data engineering how to hunt job in walmart?

like

Hi all, Can someone help with interview questions with the Information Security Auditor role? Please

likefunny

What is 2nd round for In an Interview ? What do they ask ?

like

What excuses have you used to leave for an interview that is not a “doc appointment”?

like
like

Hi guys,
I have cleared all the rounds for LTI post which I received autogenerated mail and then later HR asked to upload documents. In how many days can I expect offer letter?

like

What questions are asked in KPMG next round after L1 ? Is it technical or totally HR? KPMG KPMG India

like

Hi fishes,
How's the interview process in Infosys for data analytics role? How I can prepare myself for that? And, how much I can ask considering my YOE is 2 years and current profile devops.

I have an upcoming interview with Virtusa , is anyone aware of interview format , what to prepare ?

Hey guys I’m new to fishbowl. I’m currently at a job where the is paying way below the cost of living for the area I live in. So it’s time to start updating my resume my question is jobs that I was at for less then a year do include them?

More Posts

If you’re a fourth year in biglaw, what responsibilities are you given in m&a? I feel like I still haven’t had a ton of opportunities working on purchase agreements (and mostly just take the lead on ancillary work streams) and I’m afraid I’m falling behind others in my class year.

like

Any recommendations for recruiters? NY RR second year. I prefer to stay in NY.

like

Which techstack according to you is being paid the highest package with same level of experience😇😇😇😇?
Highly appreciate mentioning the yoe, the techstack and the package offered🥰🥰🥰🥰

like

Hi everyone
I have less than a month left in serving notice period and i am looking for opportunities as an AZURE DEVOPS engineer. I would really appreciate of someone can help me with a referral.

Skill stack: Azure Devops
YOE:4.8 years

Thanks all in advance

like

Anyone feel like self-control is more difficult on stimulants in general? Like reflecting back on things, thinking before speaking, holding out on pleasure activities

like

What are the average age brackets at Big 4 to be a Con, Senior Con, Manager, Senior Manager, Director, Partner? Keen for people’s perspectives.

like

Waldorf Shanghai on the Bund

like

Are there any All Inclusive Marriott properties?

Welcome to the 30s and 40s singles bowl! Here’s to hoping the posts in this bowl are a bit more mature. Relying on the honor system here, try not to lie about your age.

like

Chicago 🐟here in the process of moving to LA.

Holy cow how do you guys live? Everywhere is so expensive but there are so many homes on the market.

Do you guys plan on living in LA for the long term? Any tips on navigating the neighborhoods and where I good starter location would be?


(For reference, new jobs office would be in Santa Monica)

likefunny

Incoming offer from a REIT as an acquisitions analyst in the Carolinas. I have 2 YOE. I’m hoping for 85K + ~30K bonus range. is this feasible? or should i expect something lower?

like

We as the armed forces of the United States have a research department, but the greatest advances at the armament level come from private sectors, this could not be something counterproductive because if they sell a product to us, what deprives them of selling it to other countries?

like

Hi fishes,
I am currently working as Branch Manager (scale-2 officer) in one of the leading public sector banks and have 5 yr experience in core banking. I am having 2.5 years experience in the IT sector on vision plus as a software engineer (before joining the bank). I have knowledge of core banking as well as good knowledge of banking tools like finacle, caps, imac etc. I want to switch to private financial institutions.
Any suggestions about such institutions and the domain for I can apply

Guys, just want to hear your opinion on something/ what a guy would think ): my husband and I rarely argue but we recently have argued a lot more for little things. (See comment)

like

Hi, any idea about WFO,?

like

Looking to get into the Finance, Consulting, or Business Analytics field as an entry level (graduating in December 2022) and would really appreciate if people could refer me!

Post Photo
like

My agency is shifting to begin doing quick turn organic social production for a few brands and I’m trying to build a team that can support these asks. Ive honestly never worked at an agency that successfully handled this without it feeling chaotic- anyone ever have a successful team with this type of work? Any advice is appreciated!

likehelpful

Hi guys,what is the take home salary for month after deductions for the below package in TCS..need you inputs ..yoe 10.3

Post Photo

As everybody tells u will get more offers during the last one month of notice.

My scenario is i have decent offer but i dont like to join there because of location issue and im looking for jobs in new tech where i have less exp.

Considering this even though if i have less knowlege and if i perform a decent interview process will i get offers at the last moment?Is the offers during the late notice is given based on as he can join early even his performance is average during interview. Pls share

like

Hi Fishes, Can you all please help me with the inhand salary?

I have made 80C, 80D, HRA investments already filling individual limits.

Post Photo
like

Additional Posts in Excel Genius

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

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!

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

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)

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Anyone know what these badges are?

Post Photo
likefunny

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

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