+ Reply to Thread
Results 1 to 2 of 2

Have to take an Excel test at job interview

  1. #1
    Registered User
    Join Date
    06-07-2014
    Posts
    1

    Have to take an Excel test at job interview

    I landed an interview for a part-time billing assistant position at a healthcare clinic. The interviewer told me that I'd have to take an excel test at the clinic before the interview with the billing manager.

    I hardly use excel at all, if I do, it's for graph making for class projects. I usually grasp this type of stuff really fast when I have the exact directions to go about doing something on Excel. I'm not sure if this test will be multiple choice or if it will be on the excel program itself..does anyone have any suggestions/tips on how I should go about preparing for this test? It's going to be this coming Friday so I have some time.

    Thanks as always everyone.

  2. #2
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: Have to take an Excel test at job interview

    Yes. Youtube ExcelIsFun. Since the job is a billing assistant, I can't imagine the test will be that hard. All they could want you to know if how to set up billing info. I'm sure you know how to use the SUM function. You should know the difference between absolute and relative references. Other than that, I can't image you'd need anything more than INDEX and MATCH (or VLOOKUP). I would assume the test is completing some tasks on Excel. A multiple choice test wouldn't tell you anything. Other things that might be useful to know: Pivot tables, text-to-columns, dynamic ranges, and remove duplicates. They are all pretty easy to pick up. Good luck!
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 01-19-2014, 07:26 PM
  2. Excel/VBA Test Job Interview
    By xtasio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2013, 10:35 AM
  3. Pull sub-test scores from test w/best overall test score (PSAT)
    By PowerSchoolDude in forum Excel General
    Replies: 0
    Last Post: 11-19-2009, 08:29 PM
  4. Excel Interview Question
    By ricker65 in forum Excel General
    Replies: 4
    Last Post: 07-29-2008, 02:10 AM
  5. Excel Interview Question
    By ricker65 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-28-2008, 10:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1