Question: Mark the steps as checked when you complete them . 1 . Open the PlacerHills - 0 7 start file. Click the Enable Editing button.

Mark the steps as checked when you complete them.1. Open the PlacerHills-07 start file. Click the Enable Editing button. The #NUM! error appears in three cellsbecause arauments for the formulas in those cells are missina2. 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.NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.3. Find and clear data validation settings.a. Click the Find & Select button [Home tab, Editing group] and choose Go To Special.b. Select the option button for Data validation (Figure 7-62).c. Click OK. Cells with data validation settings are highlighted.d. Click the Data Validation button [Data tab, Data Tools group]. Row differenc column afterensee. Click Clear All on the Settings tab and leave the dialog box open.4. Set data validation with an error alert.a. Verify that the following cells in the worksheet are selected: C9:C12, H9, H11, H13:H14, and H16.(If they are not, close the Data Validation dialog box, select the cells, and click the Data Validation button [Data

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!