MS Excel

  Home  Applications Programs  MS Excel


“MS Excel Interview Questions and Answers will guide us that Microsoft Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993. Get MS Excel Job interview preparation with this MS Excel Interview Questions and Answer Guide”



120 MS Excel Questions And Answers

81⟩ I am using Microsoft Excel and I would like to know if there is an easy way to figure out the number of working days (Monday through Friday) between two dates and also exclude specific holidays?

Yes, you can use the NETWORKDAYS function. The following is the syntax for the function: NETWORKDAYS(START_DATE,END_DATE,HOLIDAYS) START_DATE is a date that represents the start date. END_DATE is a date that represents the end date. HOLIDAYS is an optional range of one or more dates to exclude from the working calendar.

 137 views

82⟩ My furnace and air conditioner are both new. Do I really need to have it cleaned?

1. Press and hold the shift key while clicking on the File menu

2. Choose Close All. Holding down the shift key changes the File Menu option from Close to Close All.

Yes!! Even though your system is new, it still needs to have annual maintenance performed. This will help keep the warranty in effect. Most all equipment manufactures state in the terms of their warranty that annual maintenance must be performed by a qualified technician. Keeping your system maintained will give you assurance that it is operating at peak efficiency and safety.

 141 views

83⟩ Can I open .PRN files in Microsoft Excel?

Yes you can. You will need to open Excel and then open the .prn file. This will open up the Text Import Wizard. Follow through the wizard to determine the outcome of how you want you text to be imported into Excel.

 139 views

84⟩ Is there a way to set up a toolbar button in Excel to access Page Setup?

This requires customizing your toolbar as follows: 1. Choose Tools + Customize to launch the Customize dialog box. 2. Click the Commands tab. 3. In the Categories list, select File. 4. In the Commands list, drag the Page Setup button (it has the words Page Setup and no picture) to the Standard toolbar. We recommend positioning it just to the left of your Print button. 5. Click Close to make the Customize dialog box disappear and save your changes.

 140 views

85⟩ I know I can use the fill handle (the small black box in the lower-right corner of the range) to copy data and formulas in Excel, but is there a way to use it to clear ranges in Excel?

To do this you will need to select the range you want to clear. Once you have it highlighted then drag the fill handle (the small black box in the lower-right corner of the range) up or to the left to clear what you want in the range.

 146 views

88⟩ Can you tell me how I can put comments in my spreadsheet for instructions that pertain to a specific cell in Microsoft Excel?

First you will need to click on the specific cell that you want the comment to refer to. Go to Insert on the menu bar and then select Comment. You can now type your message. After typing your message you can click outside of the comment box onto another cell. You can tell that there is a comment associated with that cell because a small red triangle will be in the upper right hand corner of the cell. When you want to see the comment, you can either put your mouse over the cell and it will appear or you can set Excel to always show comments. To do this you will need to go to Tools on the Menu bar and select Options and then click on the View tab. Then, choose the Comment & Indicator option in the Comments section and then click on OK.

 125 views

89⟩ Please tell me how I can split combined data into separate columns in an Excel spreadsheet. For example I have a spreadsheet that contains the city and state (i.e. Kennett Square, PA) in the same column and I would like to have them in two separate columns?

In Microsoft Excel you can convert delimited text into columns. To do this you must first insert a blank column to the right of the data you want to split. Next, select the text you want to convert and on the menu bar choose Data then Text to Columns. The Delimited wizard will then open. You then need to select Delimited option and click on Next. On the next sheet of the wizard, select the character that separates your data from the Delimiters panel (i.e. comma, space, tab or whatever may be separating the text in your spreadsheet, in this case it would be a comma between the city and state). Take notice of the changes shown in the Data Preview panel. Click Next and look through the Data Preview panel to make sure your data is converted to the format you like. Make any necessary changes in the Column Data Format panel. Finally, click Finish.

 139 views

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

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.

 150 views

91⟩ 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?

There's a menu-driven solution that's called AutoFilter. Just put the cursor anywhere in the range of cells you want to print, open the Data menu, select Filter, then choose AutoFilter. When you do, Excel will add dropdown-arrows to the cell at the top of each column. Click that dropdown arrow for the column that contains the zero entries. Select the Custom... option. That opens the Custom AutoFilter dialog box. In the Show Rows Where fields section, choose the greater-than sign for the operator and enter 0 (the number) for the value. Then, click OK. When you do, Excel will display only the rows that contain values greater than zero in the column you selected. To re-display those rows, open the Data menu, choose Filter, and choose AutoFilter again to deactivate it.

 126 views

92⟩ 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?

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.

 139 views

93⟩ 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?

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.

 121 views

94⟩ 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?

Objects can be snapped to alignment by using the Drawing toolbar through the following steps: 1. Hold down the Ctrl key and click each object you want to align. 2. On the Drawing toolbar, click the Draw button. 3. Choose Align or Distribute from the pop-up menu. 4. Select the alignment option you prefer; the diagrams next to each option illustrate the result. Excel aligns the objects. Because the objects are still selected, you can also move them together to another location without disturbing the alignment.

 139 views

95⟩ I am using Excel, and want to create a line graph with the data on my spreadsheet, ranging from January to December. However, I don not want the empty cells to be represented as zeroes in the line graph. Is there a way to graph all months without displaying the zero values?

This can be accomplished by going to Tools, Options, menu, choose the Graph Tab, under "Plot empty cells as" option, Select, "not plotted (leave blank)".

 133 views

97⟩ I am working in MS Excel 5.0 in Windows 95. I have a spreadsheet where the gridlines are not printing. The sheet is 87 rows by 49 columns, "A1 to AW87." The gridlines are not printing from column "AP" to "AW." The other gridlines are printing correctly. What is the problem?

First, make sure Gridlines are turned on (File, Page Setup, Sheet tab, Gridlines checked). If the gridlines are still not printing, perform a Copy and Paste of the affected gridlines to New File.

 122 views

100⟩ In Excel, I am trying to open a Lotus 1-2-3 WK4 file. The file contains a bitmap. I am receiving the following error message "This program has performed an illegal operation and will be shut down, Invalid Page Fault in Excel.exe at 0137304997F4." Why am I receiving this message?

This is a common problem, and despite the message, you're still a law-abiding citizen. You can solve your dilemma by installing Excel SR-1, or by removing the bitmap, or by opening the file and then saving the .wk4 file in Excel 7.0 before opening the file in Excel.

 159 views