DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Formulas
|
|
|
Formatting
|
|
|
Filters
|
|
|
Insertions
|
|
|
Components
|
Detailed explanation-1: -AutoSum lets you find the average in a column or row of numbers where there are no blank cells. Click a cell below the column or to the right of the row of the numbers for which you want to find the average. On the HOME tab, click the arrow next to AutoSum > Average, and then press Enter.
Detailed explanation-2: -Goal Seek. Whenever you create a formula or function in Excel, you put various parts together to calculate a result. Goal Seek works in the opposite way: It lets you start with the desired result, and it calculates the input value that will give you that result. We’ll use a few examples to show how to use Goal Seek.
Detailed explanation-3: -Select the cell with the formula you want to evaluate. Click the Formulas tab. Click the Evaluate Formulas button. The Evaluate Formula dialog box displays, which breaks down the formula arguments for you so that you can isolate the error.