Microsoft Excel 面试题与答案

问题 26. How do I resize Columns and Rows to better fit the data in MS Excel?

1. Move the mouse in between any two labels (Rows/numbers or Columns/letters) 
2. The pointer will turn into a vertical (letters) or horizontal (numbers) line with arrows on both ends 
3. Simply drag the column or row to the desired size 

问题 27. What does a red triangle at the top right of a cell indicates?

A red triangle in the cell indicates the comment associated with the cell.  If you place mouse on it, it will show the comment.

问题 28. How do I combine different chart types into my Excel spreadsheet?

To combine chart types, follow these steps: 
1. If the Chart toolbar isn't already displayed, right-click any Toolbar and select Chart. 
2. On the chart, click the series you want to change. 
3. On the Chart toolbar, click the arrow next to the Chart Type button and then select the new chart type for the series (in our example, a line chart). 

问题 29. Using Excel is there a way to close all open Excel files at once instead of closing them one at a time?

Yes, you can close down all your Excel files at once by using the following instructions: 
1. Hold down the Shift key. 
2. Choose File + Close All from the menu. Holding down the Shift key changes Excel's File + Close command to a File + Close All command. 

问题 30. What is IF function in excel?

To perform the logic test IF function is performed. It checks whether certain conditions is true or false. If the condition is true then it will give result accordingly if the condition is false then the result or out-put will be different.

Example: For example, you select the cell and you want to display that cell as “Greater than five”, when value is true (=5 or 5) and “less than five” when value is false( <5 ). For that by using IF condition you can display result.

=IF (Logical test, value if true, value if false)

=IF (A1>5, “Greater than five, “Less than five”)