DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You’re trying to write formulas in five different cells located many columns apart on three different worksheets, and you’d like to see how the values of these cells change as you work on various parts of the workbook. Which of the following methods can be used to accomplish this?
|
|
Click the formula tab and then click the currency button
|
|
|
Click the Watch Window button on the Formulas tab and add the cells as Watches
|
|
|
Click the Find button and then type in the data of that cell to find that correct one
|
|
|
Click the page layout ribbon and then click view page and print
|
Explanation:
Detailed explanation-1: -AVERAGE: This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.
Detailed explanation-2: -Select the cell with the inconsistent formula, and then hold down the SHIFT key while pressing one of your arrow keys. This will select the inconsistent cell along with others. Then do one of the following: If you selected cells below, press CTRL+D to fill the formula down.
There is 1 question to complete.