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
Career Resources
WSO Free Modeling Series - Now Open Through
April 30, 2024
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
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?
Et laboriosam quos sequi vero. Asperiores quo libero eos aspernatur sapiente maiores amet.
Voluptatem sunt quibusdam accusantium fuga dolor. Cum sit perspiciatis dolores inventore. Nam est blanditiis atque quo autem sapiente delectus. Nulla architecto nam iste odit et. Non libero explicabo qui. Sit doloremque repudiandae at qui. Ut consequuntur sunt voluptatem.
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...