Question

5. Identify the invalid data in the worksheet and correct the entry as follows: a. Circle the invalid data in the worksheet. b. Type 15 as the minimum number of trainees for the Tech Skills program (cell C5). c. Verify that this change cleared the remaining errors in the worksheet

Answer 1

a. Use conditional format, select the worksheet, input a condition in a given column, and use a circle to format the invalid data rows.

b. Double-click on cell C5, delete the current data and input 15.

c. If the errors are corrected, the circles are removed.

Step-by-step explanation:

Microsoft Excel is a spreadsheet application used to manipulate statistical data. It is made up of cells arranged in rows and columns. There are several built-in formulas and tools used to analyze data.

The conditional formatting tool is an example of excel tools used for analysis. In conditional formatting, a pattern is selected to be used in a selected column or worksheet if a condition is met, if not, the pattern will not be used.