Microsoft Excel Question:
Download Questions PDF

How do you set Excel to automatically place a decimal point for every number you enter?

Answer:

Select the Tools menu and then the Options menu. The Options menu will give you a property sheet with several tabs. Select the tab labeled "EDIT". Check the box for Fixed Decimal. This action allows you to increase or decrease the "PLACES" field. Note: The default for PLACES is 2. When you have selected the proper is setting click OK to save the property.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
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?In Excel, how can I prevent a row from printing in a range if certain cells in a particular column equal 0. I do not want to extract the records to another section of the sheet. Is it possible to hide those rows, then print, then unhide?