Step 3 click in cell h4 step 4 click the arrow for

Step 3: Click in cell H4.
Step 4: Click the arrow for AutoSum in the Editing group on the Home tab, select Average
and press Tab to move to cell I4.
Step 5: Type =me and double-click on Median.
Step 6: Click and drag across B4:G4 and press Tab
Step 7: Click the AutoSum button. Notice that Excel selects from B4 to I4, but you do not
want to include your other functions in the formula. This illustrates the need to
always pay attention to what Excel selects when using the AutoSum button. Click
and drag across B4:G4 and press Enter.
Step 8: Select H4:J4 and double-click on the fill handle to AutoFill the formulas down. It
stops at row 8. If you want to include these functions for the Total row, you can
click and drag on the fill handle down to row 9.
Step 9: Save and close the workbook.
E
XERCISE
4-7
Step 1: Open the Computer Sales workbook from the ICAO Student Files folder
Step 2: On the Company tab select cell B3 if not already selected
Step 3: Type an = sign then click on the Store 1 tab and select cell B4, type a plus sign +,
click on the Store 2 tab and select cell B4, type a plus sign +, click on the Store3 tab
and select cell B4, type a plus sign +, click on the Store4 tab and select cell B4 then
press Enter
Step 4: AutoFill the formula in cell B3 down to row 19
Step 5: Click in cell B20, click AutoSum, and press Enter
Step 6:
Another option is to use what is called a 3-D reference. Click in cell C3, click
AutoSum, select Store 1 tab, hold Shift, select Store4 tab, select cell B3 and press
Enter. AutoFill it down. Click on the Comma style button and reduce the decimals
to zero decimal places.
Note: This only works if all of the rows of data are identical meaning the row names
are the same.
Step 7: Save the workbook as Computer Sales – Total Worksheets and close the workbook

4-46 Introduction to Computers (ITC4)
E
XERCISE
4-8
Step 1: Open the Computer Costs workbook from the ICAO Student Files folder
Step 2: In cell C4, we will calculate the amount of tax on the motherboard. The formula will
end up calculating the motherboard cost multiplied by the tax rate. Enter the
formula.
Step 3:
AutoFill the formula down to row 13 and notice the errors.
Step 4: Click on cell C6 and notice that the formula is =C6*C3. The problem is that cell C3
is blank, so the result is zero.
Step 5: Press Ctrl+` to show the formulas
Step 6:
Press the down arrow to see how the cells keep the same relationship to the cost cell
– column C and three rows above
Step 7: Press Ctrl+` again to return to the results
Step 8: Click in cell C5 and press F2 to put the cell in edit mode
Step 9: Click the F4 key to make cell C2 an absolute value (The formula should look like
=C6*$C$3) and press Ctrl+Enter.
Step 10: AutoFill the formula down again and notice the errors are gone and the results are
correct.