Microsoft Excel Interview Preparation Guide
Strengthen your MS Excel interview skills with our collection of 143 important questions. Our questions cover a wide range of topics in MS Excel to ensure youre well-prepared. Whether youre new to the field or have years of experience, these questions are designed to help you succeed. Dont miss out on our free PDF download, containing all 143 questions to help you succeed in your MS Excel interview. Its an invaluable tool for reinforcing your knowledge and building confidence.143 MS Excel Questions and Answers:
1 :: In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?
In the date field properties of the table, form, or properties manually input the format you would like. It is not required to choose one of the date formats in the drop down box. Example would be mm/dd/yyyy.
2 :: How do I put password to protect my entire Spreadsheet so data cannot be changed?
1. Click Tools
2. Scroll down to Protection, then Protect Sheet
3. Enter a password, Click OK
4. Re-enter password,
Click OK
2. Scroll down to Protection, then Protect Sheet
3. Enter a password, Click OK
4. Re-enter password,
Click OK
3 :: What is Freeze Panes and how do I do it?
1. Row - Select the row below where you want the split to appear
2. Column - Select the column to the right of where you want the split to appear
3. Go to the Menu Bar
4. Click Windows
and then click Freeze Panes
2. Column - Select the column to the right of where you want the split to appear
3. Go to the Menu Bar
4. Click Windows
and then click Freeze Panes
4 :: How do I Format data in MS Excel?
1. Must Always highlight the data before formatting
2. Click Format
3. Then go to Cells
2. Click Format
3. Then go to Cells
5 :: 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
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
6 :: 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).
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).
7 :: 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.
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.
8 :: I have converted my MS Access database to a current conversion. I am getting conversion errors?
Design specs have changed in new releases of MS Access. Visit the on-line help option for "conversion and compatibility" that explains different portions of Access databases that will have difficulty converting. Some reprogramming may be required.
9 :: Is there a way to apply the same formatting to every sheet in a workbook in Excel?
Yes. To do this, you will need to right click on one of the worksheet tabs and then choose Select All Sheets. After you do this any formatting that you apply or text you enter will show up on all the sheets in your workbook. In order to eliminate certain sheets from the changes, hold down the Ctrl key and click on the tab of the worksheet you want excluded from the others. You can also group sheets by holding the shift key and selecting the worksheet tab.
10 :: How can I identify which cells in my spreadsheet have a formula and which do not in MS Excel?
Option A:
1. Choose Edit + Go To (or press Ctrl + F5).
2. Select Special.
3. Select Formulas.
4. Click OK.
Option B:
1. Choose Tools + Options.
2. Select the View Tab
3. In Window Options choose the check box 'Formulas'.
4. Click OK
1. Choose Edit + Go To (or press Ctrl + F5).
2. Select Special.
3. Select Formulas.
4. Click OK.
Option B:
1. Choose Tools + Options.
2. Select the View Tab
3. In Window Options choose the check box 'Formulas'.
4. Click OK