Microsoft Excel Questions & Answers

Here’s how you can create a heatmap in Excel:

• Use Conditional Formatting
• Customize the Heatmap
• Hide Numbers (Optional)
• Create a Dynamic Heatmap

Here’s how you can create a bar chart in Excel:

• Enter Your Data
• Insert a Bar Chart
• Customize the Chart
• Finalize & Share

To create a stacked bar chart in Excel you should:

• Select the entire data range and click “Insert”
• Click “Charts” select a stacked bar chart.
• Right click on the vertical axis and select “Format Axis”.
• Go to “Chart design” to add title and legend.
• Customize your bar chart and select chart style.

Here’s how you can create a waterfall chart in:

Method 1: Using Built-in Waterfall Chart

• Prepare Your Data – Arrange your data with categories and values.
• Insert a Waterfall Chart – Select your data, go to Insert > Charts > Waterfall.
• Set Totals – Right-click the first and last bars, then select Set as Total.
• Customize the Chart – Adjust colors, labels, and remove unnecessary elements.

Method 2: Using a Stacked Column Chart

• Create Helper Columns – Add columns for base, increase, and decrease values.
• Insert a Stacked Column Chart – Select your data and go to Insert > Column Chart > Stacked Column.
• Format the Chart – Adjust transparency, colors, and labels to resemble a waterfall chart.

To create a pie chart in excel you should:

• Select the data.
• Select Insert: insert pie or doughnut chart.
• Select the chart and customize by adding data labels, colors and text.

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.