ACECQA has been established to guide the implementation and administration of the National Quality Framework, and to ensure national consistency. Information on the NQF, including information sheets and sector support material, is available on the ACECQA website.
There are three ways to highlight cells. 1  Click, hold and drag your mouse. 2  Click on the first cell in the range, and then hold down your Shift key while you click the last cell in the range.  Enter the range in the Name Box.
Calculate only visible cells. As you remember, Subtotal formulas with function_num 101 to 111 ignore all hidden cells - filtered out and hidden manually. So, when you use Excel's Hide feature to remove irrelevant data from view, use function number 101-111 to exclude values in hidden rows from subtotals.