Microsoft Excel Questions & Answers

To recover corrupted Excel files, follow the steps given below:

• Launch Microsoft Excel
• Tap on File > Open
• Choose the Corrupted file
• Tap on the Arrow icon next to Open Button
• Click on the ‘Open and Repair’ button
• Tap the Repair button 
• In case the process of repairing fails, click Extract Data and excel restores the values and formulas associated with that file.

To uncorrupt an Excel file, follow the steps given below:

• Go to the place where you have saved the faulty file
• Right click on the file and then click ‘Open and Repair’ option
• Select Repair and then tap Close.

To undo deletes in Excel press Ctrl + Z from the keyboard or go to the Quick Access Toolbar and then select the Undo option.

To scale a worksheet in Excel, follow the steps given below:

• Go to Design on the menu bar
• Toggle to Page Setup and then tap on the More Arrow
• Tap on the Window launcher button
• Click on Setting and then choose ‘Adjust to’
• Enter the scale value with Percentage as the unit.

To make a dot plot graph in Excel, follow the steps given below:

• Select the range of data whose graph you want to plot
• Click on the Insert Tab present in the menu bar
• Click on the Scatter chart type
• Choose the desired scatter chart sub-type.

In Excel, a pixel is 1/96 of an inch. And, in a new Excel worksheet, the default column width is 8.43 characters, or 64 pixels.

To change the language back to English in MS Excel, follow the steps given below:

• Go to File from the menu bar
• Click on Options > Language
• Now search for the language of your choice (English in this case)
• Select the language and click on the checkbox labelled ‘Set as Default’.

To access the language setting in MS Excel, follow the steps given below:

• Go to File from the menu bar
• Click on Options > Language
• Now search for the language of your choice (English in this case)
• Select the language and click on the checkbox labelled ‘Set as Default’.

Some popular data entry softwares are:

• Microsoft Excel
• Google Sheet
• Microsoft Access
• Tableau

Scroll Lock is the most common cause. Look for a light on your keyboard over the Scroll Lock button if Scroll Lock is enabled. By pressing the Scroll Lock key or using the on-screen keyboard in Windows, you can disable it if it is enabled.