Spreadsheet Software Questions & Answers

To strike off in Excel

• For Windows- Select the cells and press Ctrl+5.
• For Mac- Select the cells and press Command+Shift+X.

Using the Ribbon

• Select the cell.
• Go to the Home tab.
• Click the Font tab.
• Select the Strikethrough button.
• Click OK.

To calculate age in Excel you should:

• In a column enter birth dates.
• Select cells, right-click and choose “Format Cells”, then click “Date”.
• In the cell you want the age to appear, type formula =DATEDIF (A2, TODAY(), “Y”).

To delete blank rows in excel you should:

• Select your data.
• Go to Home, select Go to Special.
• Choose Blanks and click OK.
• Go to Home, click Delete, then click Delete Sheet Rows.

To strike out in Excel

• On Windows: Select the cell or text and press the keyboard shortcut Ctrl + 5.
• On Mac: Select the cell or text and press the keyboard shortcut Command + Shift + X.

To make pie charts in Excel you should:

• Prepare your data.
• Select the data and Go to the Insert tab.
• Choose a Pie Chart and select a chart type.
• View your chart.
• Customize your chart, add percentages & labels, change colors & styles.

To convert capital letters to small letters in Excel you should:

• Add a new column next to the existing column of capital letters.
• In the first cell of the new column, type the formula: =LOWER(A1).
• Replace A1 with the actual cell reference containing capital letters.
• Apply to other cells, drag the small square at the bottom-right of the cell down to apply the formula to the rest of the column.

To find duplicates in Excel you should:

• Select your data.
• On the Home tab, click the Conditional Formatting.
• Click Highlight Cells Rules, then click Duplicate Values.
• Select a color and click OK.

To delete empty rows in excel you should:

• Select your data range.
• Go to Home, and open Go to Special.
• Choose Blanks and click OK.
• Right-click a cell, choose Delete, and select Entire Row.

Microsoft Excel is the best report writing software as it helps an individual to collect, sort, calculate, and share data.

Here are some ways via which you could undo in Apple Numbers:

• Click on Edit and then choose Undo
• Press Cmd + Z from the keyboard
• Tap or Swipe on the screen using three fingers.