Mark the steps as checked when you complete them.<\/p>\n\nSkills List<\/h2>\n\n\nOpen the start file <\/span>EX2021-SkillReview-9-2<\/span>. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.<\/span><\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nIf the workbook opens in Protected View, click the <\/span>Enable Editing<\/span> <\/span>button in the Message Bar at the top of the workbook so you can modify the workbook.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\nUse Consolidate to create a summary sheet totaling sales from the <\/span>Northeast<\/em>, <\/span>Southeast<\/em>, <\/span>Southwest<\/em>, and <\/span>Northwest <\/span><\/em>worksheets. Include links to the source data.\n\n\nGo to the <\/span>Summary<\/span> <\/span>worksheet.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nSelect cells <\/span>B4:E11<\/span>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nOn the <\/span>Data<\/em> <\/span>tab, in the <\/span>Data Tools<\/em> <\/span>group, click the <\/span>Consolidate<\/span> <\/span>button.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nIf there are existing references in the <\/span>All References<\/em> <\/span>box, remove them by clicking each one and then clicking the <\/span>Delete<\/span> <\/span>button.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nVerify that <\/span>Sum<\/span> <\/span>is selected in the <\/span>Function<\/em> <\/span>list.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nAdd the first reference. Click in the <\/span>Reference<\/span> <\/span>box.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nClick the <\/span>Northeast<\/span> <\/span>worksheet tab and click and drag to select cells <\/span>B3:E10<\/span>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nClick <\/span>Add<\/span>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nClick the <\/span>Southeast<\/span> <\/span>worksheet tab and then click <\/span>Add<\/span>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nClick the <\/span>Southwest<\/span> <\/span>worksheet tab and then click <\/span>Add<\/span>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nClick the <\/span>Northwest<\/span> <\/span>worksheet tab and then click <\/span>Add<\/span>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nIf necessary, click the <\/span>Create links to source data<\/span> <\/span>check box to add a checkmark.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nClick <\/span>OK<\/span>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n<\/ol>\n<\/li>\nExpand the details for the Equipment sales type category and add data validation to find any individual sales less than 125,000.\n\n\nOn the <\/span>Summary<\/em> <\/span>worksheet, click the + next to <\/span>Equipment<\/em>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nSelect cells <\/span>B4:E7<\/span>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nOn the <\/span>Data<\/em> <\/span>tab, in the <\/span>Data Tools<\/em> <\/span>group, click the <\/span>Data Validation<\/span> <\/span>button.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nIn the <\/span>Data<\/em> <\/span>Validation<\/em> <\/span>dialog, expand the <\/span>Allow<\/span> <\/span>list and select <\/span>Whole Number<\/span>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nExpand the <\/span>Data<\/span> <\/span>list and select <\/span>greater than<\/span>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nType <\/span>124,999<\/kbd> in the <\/span>Minimum<\/em> <\/span>box.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nClick <\/span>OK<\/span>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nOn the <\/span>Data<\/em> <\/span>tab, in the <\/span>Data Tools<\/em> <\/span>group, click the <\/span>Data Validation<\/span> <\/span>button arrow and select <\/span>Circle Invalid Data<\/span>. There should be four values circled.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n<\/ol>\n<\/li>\nAdd a hyperlink from one of the circled cells to its cell in the source worksheet.\n\n\nOn the <\/span>Summary<\/em> <\/span>worksheet, click cell <\/span>B5<\/span>. Look in the address bar to see the cell reference for this particular value.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nOn the <\/span>Insert<\/em> <\/span>tab, in the <\/span>Links<\/em> <\/span>group, click the <\/span>Link<\/span> <\/span>button.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\nUnder <\/span>Link to<\/em>, select <\/span>Place in this Document<\/span>.<\/label><\/p>\n<\/div>\n<\/div>\n<\/li>\n\n