Microsoft Excel Question:
Download Questions PDF

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?

Answer:

1. Right-click a chart that uses the defaults you prefer. 2. Choose Chart Type from the menu that appears. 3. Click the Set as Default Chart button. 4. Click OK. From now on, Excel will create charts based on the default you prefer, this will save you a couple of clicks per chart.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
Can you tell me how I can put comments in my spreadsheet for instructions that pertain to a specific cell in Microsoft Excel?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?