Excel module 8 sam end of module project 1

People had trouble with this so I really hope this helps. Skip to 2:08 for the beginning

7. The conditional formatting rule in column G highlights cells that contain the value 5 , the highest evaluation rating. Padma wants to change the. Question: New Perspectives Excel 2019 | Module 6: End of Module Project 1 formatting them with Light Red Fill with Dark Red Text. Delete the second instance of the duplicate record, the one with a ...New Perspectives Excel 2019 | Module 3: End of Module Project 1. New Perspectives Excel 2019 | Excel Module 3 SAM End of Module Project 1. Barrel Barnard Consulting#Excel_Module_8_SAM_End_of_Module_Project_1 #NP_EX19_EOM8 #ExcelModule8SAMEndofModuleProject1#Excel_Module_8_SAM_End_of_Module_Project_1 #NP_EX19_EOM8-1 #Exc...Cengage mindtap SAMCompleting the Northern Oregon University Foundation assignment.#Powerpoint #Shelly #Modules#Module 5: sam project 1a #Module 5 sam project 1a #New perspectives excel 2019 module 1 sam project 1a #Shelly cashman excel 201...Question: PROJECT STEPS 1. Madhu Patel is a sales analyst for Four Winds Energy, a manufacturer of wind energy products, in San Antonio, Texas. Madhu is developing a workbook to analyze the profitability of the company's wind turbines. She asks you to help her analyze the sales data to determine how the company can increase profits.Topics covered:1. Switch to the All Employees worksheet. In cell E3, enter a formula using the HLOOKUP function as follows to determine an employee's potenti...

New Perspectives Excel 2016 | Module 1: SAM Project 1b Rico's Cool Cream GETTING STARTED WITH EXCEL GETTING STARTED Dora works for an ice cream chain called Rico's Cool Cream, and uses Excel to calculate the company's payroll expenses and profits. She is currently finalizing the Profit and Payroll worksheets to close out the week's figures. Open the file NP_EX16_1b_ FirstLastName _1 ...New Perspectives Excel 2019 | Module 8: End of Module Project 1 #newperspectives #excel #module8If you directly want to get the project from us then contact ...To the right of the last tab on the ribbon, click the Tell Me box and type Fill Color in the box. In the Tell Me list, point to the Fill Color arrow. In the Theme Colors Section, click the Black, Text 1 option, the second option in the top row. Select cell D22. Literally just click on it.Related Questions. Shelly Cashman Excel 2013 Chapter 11 SAM Project 1a Blue Ribbon Flowers Workbook Collaboration Features; Illustrated Excel 2019 Module 4 End of Module Project 1 Dexter Bank and Trust Insert and Modify Charts GETTING STARTED Open the file ILEX19EOM41FirstLastName1About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright ...Open the file NP_EX19_EOM11-1_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as NP_EX19_EOM11-1_FirstLastName_2.xlsx by changing the "1" to a "2". If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.Recorded with https://screencast-o-matic.comSAM Project Mod 8 1a for Access on Cengage.

End of preview. Want to read all 5 pages? Upload your study docs or become a member. ... Excel Module 4 SAM Project 1 - IL_EX16_4a_YoselinHuayan_2.xlsx. Monroe College. IT T118-54. 2010s. FY. Years in the future. Valet parking. Excel Module 4 SAM Project 1 - IL_EX16_4a_YoselinHuayan_2.xlsx.Change the height of row 1 to 21 points. Merge and center the contents of the range A2:J2. Format the merged range A2:J2 as described below: a. Apply the 40% - Accent 5 cell style. b. Apply bold formatting. c. Change the font size to 14. Enter the values shown in Table 1 into the corresponding cells in the range A5:E5.MS Excel. Share With. Shelly Cashman Excel 2019 | Module 9: SAM Project 1a. Maxwell Training. FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING. Open the file SC_EX19_9a_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as SC_EX19_9a_FirstLastName_2.xlsx by changing the "1" to a "2".Oct 23, 2023 · Join our YouTube Membership community:https://www.youtube.com/channel/UCrMkpdXba7ENnC0mpganL8g/joinJoin our Patreon channel: https://www.patreon.com/TaandarP...

Bellisario pizza shop menu.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. Final Figure 1: Builders Worksheet. Final Figure 2: GymWear Worksheet. Final Figure 3: Logistics WorksheetIllustrated Excel 2019 | Module 8: End of Module Project 1 Slate Blue Technology ANALYZE DATA . Illustrated Excel 2019 | Module 8: End of Module Project 1 Slate Blue Technology ANALYZE DATA ... Shelly Cashman Excel 2019 Module 5 SAM Critical Thinking Project 1c Media Hub CONSOLIDATE WORKBOOK DATA GETTING STARTED Open the file ...one IF function placed inside another IF function to test an additional condition. DATEDIF function. a function that calculates the difference between two dates and shows the result in months, days, or years. Study with Quizlet and memorize flashcards containing terms like TRANSPOSE function, conditional sum, conditional count and more.Chemical Engineering questions and answers. New Perspectives Excel 2019 | Module 8: SAM Project 1b a. c. 12. Switch to the All Services worksheet. Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Current, Increase Hourly, and Contractors scenarios. Use the range C17:E17 as the result cells.Subject: MS Excel Price: 19.99 Bought 11. Share With. New Perspectives Excel 2019 Module 10: end of module project 1. Peak Partners. ANALYZE DATA WITH POWER TOOLS. GETTING STARTED. Open the file NP_EX19_EOM10-1_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as NP_EX19_EOM10-1_FirstLastName_2.xlsx by changing ...

Whatsapp no : +92326-1963514Whatsapp link : https://wa.link/y3o2mxGmail : [email protected]#Excel_2019_|_Module_8:_SAM_Project_1b #SC_EX19_8b_FirstLastNa...Subject: MS Excel Price: 19.99 Bought 11. Share With. Shelly Cashman Excel 2019 | Module 8: End of Module Project 1. lilyona martinez. 1. Sonia Montero is a sales manager for Barasch & Company, an insurance agency with three offices in Wichita, Kansas. She is using an Excel workbook to analyze the agency's financial performance, and asks for ...Switch to the Timesheet worksheet. In cell C5, insert the NOW function to record the current date. Each worksheet covers a period of 20 work days. In cell C4, create a formula using the WORKDAY function to calculate the date 19 days from the start date (cell C3). Use AutoFill to complete the labels in the table of hours.Topics covered:1. Switch to the All Employees worksheet. In cell E3, enter a formula using the HLOOKUP function as follows to determine an employee's potenti...Join this channel to get access to perks:https://www.youtube.com/channel/UCrMkpdXba7ENnC0mpganL8g/join PROJECT STEPS1. Enrique Vaquero is a city planner for...New Perspectives Excel 2019 | Module 3: End of Module Project 1 New Perspectives Excel 2019 | Exc. Login; Register; 4.9/5 Samples ... Excel Module 3 SAM End of Module Project 1. Barrel Barnard Consulting. Perform Calculations with Formulas and Functions .Learn how to create and modify an Excel spreadsheet using formulas, functions, conditional formatting, cell formatting, Average, Maximum, and Minimum.2 Jul 2020 ... Follow along as @4doxs1lab Linda Sessions looks at the basics of Excel and modifies an existing PowerPoint presentation with font changes, ...#Excel_Module_1_SAM_End_of_Module_Project_1 #NP_EX19_EOM1-1 #ExcelModule1SAMEndofModuleProject1 #Module1EndofModuleProject1 #ExcelModule1 #Excel_Module_1 #NP...Join to get access to full-length videos:https://www.youtube.com/channel/UCrMkpdXba7ENnC0mpganL8g/joinFull-length video: https://youtu.be/JiQ3xsoLv2M PROJEC...

Question: Shelly Cashman Excel 2019 | Module 8: SAM Project 1a. Open the file SC_EX19_8a_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as SC_EX19_8a_FirstLastName_2.xlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it.

Apr 18, 2023 · In the range E5:H14, create a one-variable data table using cell C5 as the Column input cell, to calculate the revenue, expenses, and net income based on units sold. 2. Madhu asks you to provide a... Click the Manage arrow, click the Excel Add-Ins option, and then click the Go button. In the Add-Ins dialog box, click the Solver Add-In check box and then click the OK button. Follow any remaining prompts to install Solver. PROJECT STEPS 1. Madhu Patel is a sales analyst for Four Winds Energy, a manufacturer of wind energy products, in San ... New Perspectives Excel 2019 | Module 8: End of Module Project 1 #newperspectives #excel #module8If you directly want to get the project from us then contact ... New Perspectives Excel 2019 | Module 7: SAM Project 1b #newperspectives #module7 #samproject1bIf you directly want to get the project from us then contact us...PROJECT STEPS Amy Zhao is a financial analyst with MedSight Instruments, a global manufacturer of medical instruments and devices. The MedSight Auditory Instruments Division is planning to manufacture and market an innovative hearing aid suitable for all ages. Amy is using an Excel workbook to estimate the sales, expenses, and profits of …Shelly Cashman Excel 2019 | Module 8: Textbook Project Briana Jones GE ver. 12.0.0-rc0000 1. Non-graded - Project: Bell & Rodgers Accounting 2. To Create a 2-D Line Chart 3/3 To Format a 2-D Line Chart 0/3 In the Trendline Chart worksheet, the Line with Markers chart's title should be "Total Billable Hours 2016 - 2021". To Add a Trendline to a Chart 3/3 To Change the Theme 3/3 To Change the ...Computer Science questions and answers. PROJECT STEPS 1. Homestead Partners is a company that connects independent home owners with longterm renters. You work in the Customer Service Department of Homestead Partners as a data analyst. You are developing an Access database application to help manage and analyze several types of customer service ...Open the file NP_EX19_8a_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as NP_EX19_8a_FirstLastName_2.xlsx by changing the "1" to a "2". If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

Is ucf closed on presidents day.

Prank soundboard calls.

In Excel, click the File tab, and then click the Options button in the left navigation bar. Click the Add-Ins option in the left pane of the Excel Options dialog box. Click the Manage arrow, click the Excel Add-Ins option, and then click the Go button. In the Add-Ins dialog box, click the Solver Add-In check box and then click the OK button.About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright ...Click . Click SAM assignments. Locate a project assignment and click . Click the file under Solution File to download it to your computer. Open the solution file. View the correct answers for SAM projects.Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. New Perspectives Excel 2019 | Module 9: End of Module Project 1 Final Figure 1: Business Plan Worksheet Microsoft product screenshot reprinted with permission from Microsoft Incorporated.Subject: MS Excel Price: 20.01 Bought 16. Share With. New Perspectives Excel 2019 | Module 8: End of Module Project 2. 1. Fernanda Oliveira is a financial analyst for Expo Events, a full-service trade show and exhibition company headquartered in Orlando, Florida. Fernanda created a workbook containing details about events scheduled for March ...Click . Click SAM assignments. Locate a project assignment and click . Click the file under Solution File to download it to your computer. Open the solution file. View the correct …Chemical Engineering questions and answers. New Perspectives Excel 2019 | Module 8: SAM Project 1b a. c. 12. Switch to the All Services worksheet. Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Current, Increase Hourly, and Contractors scenarios. Use the range C17:E17 as the result cells.Support: https://buymeacoffee.com/taandarJoin this channel to get access to perks:https://www.youtube.com/channel/UCrMkpdXba7ENnC0mpganL8g/joinThese are the ...9. Create a 2-D Column chart based on the range A5:E10. Move the 2-D Column chart to the Revenue Summary worksheet, and then resize and reposition the chart so the upper-left corner is located within cell A5 and the lower-right corner is located within cell K22. Select Switch Row/Column to edit the chart data source.She estimates revenue will be $825,000 in Year 1 and $1,400,000 in Year 5 of the shuttle service. She needs to calculate revenue for Years 2–4. Revenue should increase at a …Click the Add-Ins option in the left pane of the Excel Options dialog box. Click the Manage arrow, click the Excel Add-Ins option, and then click the Go button. In the Add-Ins dialog box, click the Solver Add-In check box and then click the OK button. Follow any remaining prompts to install Solver.MS Excel. Shelly Cashman Excel 2019 | Module 10: End of Module Project 1. Wyoming Commerce Department. ANALYZING DATA WITH POWER TOOLS. Open the file SC_EX19_EOM10-1_FirstLastName_1.xlsm, available for download from the SAM website. Save the file as SC_EX19_EOM10-1_FirstLastName_2.xlsm by changing the “1” to a “2”. ….

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. Final Figure 1: New Branches Worksheet. Illustrated Excel 2019 | Module 4: End of Module Project 1 Dexter Bank and Trust Insert and Mo.Shelly Cashman Excel 2019 | Module 3; End of Module Project 1 9. Copy the formula in cell K 4 and then paste the formula and number formatting in the range K5:K8. 10. In cell C12, insert a formula that divides the total orders for August (cell C9) by the total number of orders (cell I9). Use an absolute reference to cell 19, and then copy the ...8/8 Format a table. Change the column width. 4. 8/8 Add a record to a table. 5. 8/8 Sort a table by multiple columns. 6. 4/8 Create a Find Duplicates conditional formatting rule. In the Contractors worksheet, a conditional formatting rule should be applied to the range A5:A53. Delete a record from a table. 7. 8/8 Format a conditional formatting ... MS Excel. Shelly Cashman Excel 2019 | Module 8: End of Module Project 1. lilyona martinez. 1. Sonia Montero is a sales manager for Barasch & Company, an insurance agency with three offices in Wichita, Kansas. She is using an Excel workbook to analyze the agency's financial performance, and asks for your help in creating advanced types of charts ... New Perspectives Excel 2013 Tutorial 2 SAM Project 1b 1; Illustrated Excel 2019 Module 1 SAM Project 1b Faith Addison 1; New Perspectives Excel 2019 Module 5 End of Module Project 2 City of Bradford Pools GENERATING REPORTS FROM MULTIPLE WORKBOOKS GETTING STARTED Open the file NPEX19EOM52FirstLastName1This document is a study resource for Excel 2019, Module 8. It focuses on exploring business options using what-if tools. It provides data on sales, expenses, variable costs, fixed costs, profit, gross profit, and break-even analysis. Cairo Consulting EXPLORE BUSINESS OPTIONS WITH WHAT-IF TOOLS Author: Muhammad Ali Raza New Perspectives Excel ...https://gofund.me/1478735c I just recorded this on my phone and have no screen recorder or editor so there u go. Pls donate to get me to the super bowl and I...Module 8: SAM Project 1b | Shelly Cashman Excel 2019 #module8 #samproject1b #shellycashmanexcel2019 If you directly want to get the project from us then cont...View full document. View Instructions_SC_EX365_2021_8a.docx from ACC 221 at Women Institute of Learning, Abbottabad. Shelly Cashman Excel 365/2021 | Module 8: SAM Project 1a Eastern Mobile ANALYZE DATA WITH CHARTS AND.Computer Science questions and answers. Lewellen Group GENERATE REPORTS FROM MULTIPLE WORKBOOKS a of GETTING STARTED Open the file NP_EX19_EOMS … Excel module 8 sam end of module project 1, Excel Module 11 Project Steps 1 -7. Steps 8-11 are in a second video. The second video can be accessed at https://youtu.be/qEzY4UMnhAc ., As a front end developer, choosing the right projects is crucial for your career growth. It’s not just about the paycheck or adding another project to your portfolio. The projects ..., New Perspectives Excel 2019 | Module 3: End of Module Project 2 #newperspectives #excelproject 1) Ying Chou is an intern with the Sandhills-Sand River Water ..., Click a slice in the pie chart. Click San Diego slice and right click. Click format data point. Serious options should be open. Select point explosion and type 30 then click enter close the tab. Insert a shape into a worksheet. Click insert tab, click the shapes button. Click rectangle option., Learn how to use charts, PivotTables, and histograms to analyze data in Excel with this project from Shelly Cashman Excel 2019. Follow the steps to create and format various types of charts and PivotTables for Eastern Mobile, a communications company., 12 Aug 2020 ... Learn how to create a chart in Excel using functions, formulas, formatting tips and inserting a chart., new perspectives excel 2019 module 1 sam project 1a_module 5: sam project 1a_#shelly cashman excel 2019 | module 1: sam project 1b_new perspectives excel 201..., New Perspectives Excel 2019 | Module 1: End of Module Project 1. Switch to the Scheduling worksheet. In cell A3, change the cell content to Week of February 22, 2021 (instead of Week of February 15, 2021). Cut the contents and formatting of the range D15:E18 and paste them into the range A13:B16., Click . Click SAM assignments. Locate a project assignment and click . Click the file under Solution File to download it to your computer. Open the solution file. View the correct …, 9. Create a 2-D Column chart based on the range A5:E10. Move the 2-D Column chart to the Revenue Summary worksheet, and then resize and reposition the chart so the upper-left corner is located within cell A5 and the lower-right corner is located within cell K22. Select Switch Row/Column to edit the chart data source., Shelly Cashman Excel 2019 | Module 8: SAM Project 1a. Eastern Mobile. ANALYZE DATA WITH CHARTS AND PIVOTTABLES. GETTING STARTED; Open the fileSC_EX19_8a_ FirstLastName _1.xlsx, available for download from the SAM website.; Save the file asSC_EX19_8a_ FirstLastName _2.xlsx by changing the "1" to a "2".. If you do not see the .xlsx file extension in the Save As dialog box, do not type it., Your workbook should look like the Final Figures on the following pages. Save your. changes, close the workbook, and then exit Excel. Follow the directions on the SAM. website to submit your completed project. Final Figure 1: 2018-2021 Share Totals Worksheet. Final Figure 2: Non-Produce Chart - Trends Worksheet., New Perspectives Excel 2019 Module 8 End of Module Project 2 1 Fernanda Oliveira is a financial analyst for Expo Events a fullservice trade show and exhibition company headquartered in Orlando Florida ..., Cengage mindtap SAM Excel module 2 project lecture parts 1 to 7. Cengage mindtap SAM Excel module 2 project lecture parts 1 to 7., New Perspectives Excel 2019 | Module 1: End of Module Project 1. Switch to the Scheduling worksheet. In cell A3, change the cell content to Week of February 22, 2021 (instead of Week of February 15, 2021). Cut the contents and formatting of the range D15:E18 and paste them into the range A13:B16., This is a special Pandemic Working From Home Zoom Edition on Cengage Excel SAM Module 9 Project #1. Please note, if you are on a Mac, we encountered an erro..., Shelly Cashman Excel 2019 | Module 8: SAM Project 1a. Eastern Mobile. ANALYZE DATA WITH CHARTS AND PIVOTTABLES. GETTING STARTED. Open the file SC_EX19_8a_FirstLastName_1.xlsx , available for download from the SAM website. Save the file as SC_EX19_8a_FirstLastName_2.xlsx by changing the “1” to a “2”., Join this channel to get access to perks:https://www.youtube.com/channel/UCrMkpdXba7ENnC0mpganL8g/joinProject Steps:1. Kayla Rowe is an investment banker at ..., Illustrated Excel 2019 | Module 8: SAM Project 1a 8. Refresh the data source so that it displays accurate data, including the new record you added to the Orders table. 9. Sandra wants to display the average discount for each product rather than the sum of discount values in the Products PivotTable. Modify the Products PivotTable as follows: a. Change the Value Field Settings for the Sum of ..., Study with Quizlet and memorize flashcards containing terms like The COUNT function returns the total number of cells in the selected range that contain both text and numbers., The MAX function returns the total of all cells in the selected range., The MIN function returns the smallest value in a range of cells. and more., Related Questions. Shelly Cashman Excel 2013 Chapter 11 SAM Project 1a Blue Ribbon Flowers Workbook Collaboration Features; Illustrated Excel 2019 Module 4 End of Module Project 1 Dexter Bank and Trust Insert and Modify Charts GETTING STARTED Open the file ILEX19EOM41FirstLastName1, Illustrated Excel 2019 | Module 8: SAM Project 1a 8. Refresh the data source so that it displays accurate data, including the new record you added to the Orders table. 9. Sandra wants to display the average discount for each product rather than the sum of discount values in the Products PivotTable. Modify the Products PivotTable as follows: a. Change the Value Field Settings for the Sum of ..., The program will add the file extension for you automatically. · With the file NP_EX19_7a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. o If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS., Join to get access to full-length videos:https://www.youtube.com/channel/UCrMkpdXba7ENnC0mpganL8g/joinFull-length video: https://youtu.be/JiQ3xsoLv2M PROJEC..., #Excel_Module_2_SAM_End_of_Module_Project_1 #NP_EX19_EOM2-1 #ExcelModule2SAMEndofModuleProject1 #Module2EndofModuleProject1 #ExcelModule2 #Excel_Module_2 #NP..., Open the file NP_EX19_8a_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as NP_EX19_8a_FirstLastName_2.xlsx by changing the "1" to a "2". If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically., Related Questions. Shelly Cashman Excel 2013 Chapter 11 SAM Project 1a Blue Ribbon Flowers Workbook Collaboration Features; Illustrated Excel 2019 Module 4 End of Module Project 1 Dexter Bank and Trust Insert and Modify Charts GETTING STARTED Open the file ILEX19EOM41FirstLastName1, Go to the Scores by Date worksheet. In cell A3, insert another PivotTable based on the Calls table. Use Scores as the name of the PivotTable. Display the Date values as column headings, which automatically groups the data by month. Display the Service Rep names as row headings and the Average score data as values., In Excel, click the File tab, and then click the Options button in the left navigation bar. Click the Add-Ins option in the left pane of the Excel Options dialog box. Click the Manage arrow, click the Excel Add-Ins option, and then click the Go button. In the Add-Ins dialog box, click the Solver Add-In check box and then click the OK button., Shelly Cashman Excel 2019 Module 6 SAM Project 1a City of Honu Point CREATE SORT AND QUERY TABLES GETTING STARTED Open the file SCEX196a FirstLastName 1 ... New Perspectives Excel 2019 Module 10 SAM Critical Thinking Project 1c Lighting Designs ANALYZE DATA WITH POWER TOOLS GETTING STARTED Open the file NPEX19CT10cFirstLastName1 ..., Illustrated Excel 2019 | Module 8: SAM Project 1a 8. Refresh the data source so that it displays accurate data, including the new record you added to the Orders table. 9. Sandra wants to display the average discount for each product rather than the sum of discount values in the Products PivotTable. Modify the Products PivotTable as follows: a. Change the Value Field Settings for the Sum of ..., Shelly Cashman Excel 2019 | Module 2: SAM Project 1b Edgerton-Norris Shelly Cashman Excel 2019 | Module 2: SAM Project 1b Format WorksheetsGETTING STARTED Open the file SC_EX19_2b_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as SC_EX19_2b_FirstLastName_2.xlsx by changing the "1" to a "2". If you do not see the .xlsx file extension in the Save As ..., In Excel, click the File tab, and then click the Options button in the left navigation bar. Click the Add-Ins option in the left pane of the Excel Options dialog box. Click the Manage arrow, click the Excel Add-Ins option, and then click the Go button. In the Add-Ins dialog box, click the Solver Add-In check box and then click the OK button.