USING MICROSOFT EXCEL
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: -To insert a new worksheet in front of an existing worksheet, select that worksheet and then, on the Home tab, in the Cells group, click Insert, and then click Insert Sheet. Tip: You can also right-click the tab of an existing worksheet, and then click Insert. On the General tab, click Worksheet, and then click OK.
Detailed explanation-4: -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 #####.