By Colette Frechette at March 03 2019 11:54:49
Using the Consolidation feature. You can determine whether or not the link will be interactive when creating the consolidation. This method provides the greatest level of detail in the summary worksheet. You can choose between any function, not just the sum function. For example, you could create an average of several divisions in a summary worksheet. Some of the disadvantages of this method are that the worksheets must be identical. Although it is not impossible, it is difficult to use consolidation across workbooks.
In choosing a worksheet, it is important to review the source and check the material. Ensure that the material and answers are accurate. Evaluate the worksheet by completing it yourself. The worksheet should provide information clearly and accurately. Make sure it is exactly what you need to homeschool your child.