To consolidate the worksheets, click the annual totals sheet tab to select only the annual totals worksheet, To create the SUM function with a 3-D reference, select cell C4, and then click AutoSum Button |Home Tab| editing group. Click the qtr 1 sheet tab to display the worksheet, and then click cell C4 to select the first portion of the argument for the Sum Function. SHIFT+click the qtr 4 sheet tab to select the ending range of the argument for the SUM function. Click and enter the formula bar to enter the SUM Function with 3_D references in the selected cell.

Module 5 Apply your knowledge

Microsoft Excel beginning excel class