Excel Test
Hi everyone I have a RX AC which has a 45 minute excel test st the end, given that this is an intern position, what can I expect?
Trending Content - Investment Banking Forum
| +238 | UBS Healthcare | 49 | 6d |
| +193 | Coverage Banking is Paradise | 23 | 12h |
| +67 | My Motivation Is At An All Time High | 13 | 7h |
| +58 | Lost all ambition / don’t care at all anymore | 25 | 11h |
| +55 | London Recruiting is Paradise | 25 | 6m |
| +40 | Are Canadians still get jobs in the US? | 21 | 18h |
| +28 | MM IB --> NYC IB? | 13 | 1d |
| +27 | What is the role of an analyst at your firm? | 8 | 15h |
| +23 | Negotiating VP Sign-On Bonus (NOT Tied to Deferred Comp)? | 14 | 2h |
| +21 | "Don't include firm in Cover Letter's file name" | 9 | 5d |
Career Resources
Hey there! Based on the most helpful WSO content, for an intern position, the Excel test might not be too complex. It's likely to cover the basics and perhaps a few advanced features. Here's what you might expect:
Basic operations: You should be comfortable with basic operations such as addition, subtraction, multiplication, and division.
Formulas: You might be asked to use common Excel formulas like SUM, AVERAGE, COUNT, MAX, MIN, etc.
Functions: You may need to use functions like VLOOKUP, HLOOKUP, INDEX MATCH, etc.
Pivot Tables: Creating a pivot table might be part of the test. You should know how to summarize data using a pivot table.
Charts: You might be asked to create a chart or graph based on a given set of data.
Shortcuts: Knowing Excel shortcuts can save you a lot of time during the test.
Remember, the key to acing an Excel test is practice. So, get your hands on Excel and start practicing! Good luck, you've got this!
Sources: Week 1 of IBD Internship: Training, S&T Intern Excel Knowledge, What do you expect from an intern?
Following. Any input on how the exercise was?
Qui suscipit veritatis voluptatum eos aut quasi nihil. Hic magnam esse asperiores nisi. Eum delectus perferendis vero ea voluptatibus.
Non dolorum soluta consequatur fuga maxime tenetur laudantium. Eveniet sunt aut voluptatem tempora ea. Dolores dolorum laboriosam eius sed qui velit provident. Ipsam earum voluptatem asperiores.
Voluptas aliquid magni repellat odit est iure. Dolorem est quibusdam iusto dolorem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...