Advanced Excel Interview Questions You'll Most Likely Be Asked

Price: $19.95


Advanced Excel Interview Questions You'll Most Likely Be Asked is a perfect companion to stand ahead above the rest in today’s competitive job market. Rather than going through comprehensive, textbook-sized reference guides, this book includes only the information required immediately for job search to build an IT career. This book puts the interviewee in the driver's seat and helps them steer their way to impress the interviewer.


Table of Contents
1. General Questions
2. Formulae
3. Problems
4. VBA / Coding
5. Specific Uses
6. Graphs, Drawing and Pictures
7. HR Questions


a) 191 Advanced SAS Interview Questions, Answers and Proven Strategies for getting hired as an IT professional

b) Dozens of examples to respond to interview questions

c) 51 HR Questions with Answers and Proven strategies to give specific, impressive, answers that help nail the interviews

d) 2 Aptitude Tests download available on



Sample from the book
(Below Questions and Answers are randomly taken from different pages of the book)

Back to front

36: You are designing a spreadsheet where it would be preferable if the column headings went down instead of up (as shown below). Is it possible to do this and, if so, how?



Yes, in File -> Options -> Advanced, tick the option Show Sheet right to left. The result is like this:





Menus using the keys


37: How is it possible to perform Menu and Ribbon options using just the keyboard, and how would you figure out which key you need for each option?



In a cell, press the / key. Excel switches to keyboard menus and shows you the shortcut for each ribbon:




After you have pressed the key for the ribbon, Excel then shows you the keystroke(s) for each icon:




Notes: Very good if you are doing a function regularly (on different spreadsheets).



Line Up

38: When aligning text, the usual options of Left, Centered, Right and Justified are all there. But what are Fill and Distributed alignments?

For example if we have the following cells left justified,

how would they appear if they were aligned using Fill or Distributed?



Fill will fill a cell repeating the text. Distributed spreads the words across the cell.


Notes: Can be used a separator, or to draw attention to a row.



Moving House

39: You are planning to move house, and want to create an Excel spreadsheet with all the tasks you need to do and the status of each (with probably some notes somewhere). Where do you start?



There is an Excel template set up for this. You may want to modify it, but it is a good place to start.


Notes:The moving house template starts like this:







Customers who bought this product also purchased...