DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Click the Share Workbook button on the Review tab
|
|
|
Go to the cells with the totals that are not updating, press the F2 key and then press Enter to re-enter the formulas
|
|
|
Click the Calculation Options button on the Formulas tab and change the calculation setting from Manual to Automatic.
|
|
|
Send the workbook back to your co-worker and have them fix it
|
Detailed explanation-1: -Your co-worker sent you a workbook to update. You have entered new numbers in your worksheet, but the totals are not updating. Which of the following statements best describes how to remedy the problem? Click the Calculation Options button on the Formulas tab and change the calculation setting from Manual to Automatic.
Detailed explanation-2: -Cooperation is a process in which multiple people edit a workbook, either simultaneously or at different times. All Excel features are supported in a co-authoring environment.
Detailed explanation-3: -Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####.
Detailed explanation-4: -Excel includes a special group of functions to modify text. When you change a name, Excel automatically updates the name in any formula that references that name.