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
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?
Laborum et recusandae ea quisquam totam ratione. Illum sint nemo et quam quibusdam aut voluptatem. Mollitia cumque non rerum ex.
Sint asperiores consequuntur nihil et ut dignissimos. Voluptate doloremque omnis nobis.
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...