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
| +67 | Any tips for sleeping well? | 36 | 3h |
| +50 | Wealthy Parents / Jaded | 13 | 10h |
| +40 | Background check issue IB Full Time | 21 | 10h |
| +36 | Venezuela Debt Restructuring - LAZ vs CVP | 12 | 2h |
| +34 | How are hours rn for SA (interns) | 20 | 1h |
| +28 | Q dealflow slowdown | 22 | 2d |
| +25 | HL vs WB | 19 | 14h |
| +24 | Investment Banking in Mexico | 6 | 1h |
| +23 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 11 | 14h |
| +22 | MM bottom bucket bonus | 9 | 12h |
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?
Eaque facilis nulla labore voluptatum sint quia voluptatem. Nobis voluptate et velit in quo tenetur eius. Omnis nesciunt eum voluptatum. Similique illo quos sunt.
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...