Microsoft Excel Question:

Download Job Interview Questions and Answers PDF

While entering a series of numbers I was manually entering a comma. Excel auto-formatted the field to accommodate the comma like 1,200. I erroneously entered 12,00. Obviously the comma was placed in the incorrect position, but Excel interpreted this as text. When I wrote my sum formula, the results were not as expected. How can this be avoided in the future?

MS Excel Interview Question
MS Excel Interview Question

Answer:

Format the column ahead of time to specify the format to show commas, decimal places, etc. This way you don't have to enter the comma or decimal places while keying the numbers.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
I create lots of graphs with Excel. Unfortunately, the options to which Excel defaults are not the ones I use most. Is there any way to change the graph defaults to the ones I prefer?I have several objects that are in my Excel spreadsheet. They are pictures, charts, text boxes; simply a variety of objects to make my spreadsheet look attractive. It is rather difficult to align many of these objects. Is there an easier way than to move objects independently?