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

• 51

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 45 - 47 out of 51 pages.

Step 3:Click in cell H4.Step 4:Click the arrow for AutoSum in the Editing group on the Home tab, select Averageand 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 TabStep 7:Click the AutoSum button. Notice that Excel selects from B4 to I4, but you do notwant to include your other functions in the formula. This illustrates the need toalways pay attention to what Excel selects when using the AutoSum button. Clickand drag across B4:G4 and press Enter.Step 8:Select H4:J4 and double-click on the fill handle to AutoFill the formulas down. Itstops at row 8. If you want to include these functions for the Total row, you canclick and drag on the fill handle down to row 9.Step 9:Save and close the workbook.EXERCISE4-7Step 1:Open the Computer Sales workbook from the ICAO Student Files folderStep 2:On the Company tab select cell B3 if not already selectedStep 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 taband select cell B4, type a plus sign +, click on the Store4 tab and select cell B4 thenpress EnterStep 4:AutoFill the formula in cell B3 down to row 19Step 5:Click in cell B20, click AutoSum, and press EnterStep 6:Another option is to use what is called a 3-D reference. Click in cell C3, clickAutoSum, select Store 1 tab, hold Shift, select Store4 tab, select cell B3 and pressEnter. AutoFill it down. Click on the Comma style button and reduce the decimalsto zero decimal places.Note: This only works if all of the rows of data are identical meaning the row namesare the same.Step 7:Save the workbook as Computer Sales – Total Worksheets and close the workbook
4-46Introduction to Computers (ITC4)EXERCISE4-8Step 1:Open the Computer Costs workbook from the ICAO Student Files folderStep 2:In cell C4, we will calculate the amount of tax on the motherboard. The formula willend up calculating the motherboard cost multiplied by the tax rate. Enter theformula.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 C3is blank, so the result is zero.Step 5:Press Ctrl+` to show the formulasStep 6:Press the down arrow to see how the cells keep the same relationship to the cost cell– column C and three rows aboveStep 7:Press Ctrl+` again to return to the resultsStep 8:Click in cell C5 and press F2 to put the cell in edit modeStep 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 arecorrect.

Course Hero member to access this document

Course Hero member to access this document

End of preview. Want to read all 51 pages?

Course Hero member to access this document

Term
Fall
Professor
Staff
Tags
Dialog box