Скачать или смотреть Shelly Cashman Excel 365/2021 | Modules 8-11 | Capstone Project 1c | SC_EX365_2021_CT_CS8-11c

Hire Me For Complete Course
For Help Contact Me on
WhatsApp Number : +994 40 158 33 14


#SC_EX365_2021_CT_CS8-11c_Mac_FirstLastName_1.xlsm
#SC_EX365_2021_CT_CS8-11c
#SC_EX365_2021_CT_CS8-11c_Mac_FirstLastName_2.xlsm
#CellValuesforTheRaisePriceScenario
#SolverConstraints
#SurveyWorksheet
#SalesComparisonWorksheet
#MaySales byRegionWorksheet
#MaySalesbyProductTypeWorksheet
#OrdersWorksheet
#InstallationsWorksheet
#IncomeScenarioReportWorksheet
#IncomeAnalysisWorksheet
#TradeShowAnswerReportWorksheet
#TradeShowsWorksheet


2. Eva wants to make it easy for clients to contact the company and find information about products. Add links to the form.
a. Select the cell labeled "Porter website", add a link to the www.porter.example.com website.
b. In the cell below, add a link to the [email protected] email address. Use Contact Porter 360 as the ScreenTip for the email link.
3. Eva asks you to finish automating the form, which contains sample data for testing. In cell D23, enter a formula without using a function that displays the client's city from the named range City.
4. Add a sixth option to the "How did you hear about Porter 360 products and services?" section as follows:
a. In cell H12, insert an Option Button (Form Control). Edit the option button text to use the Website to replace the placeholder text.
b. Format the new option button to link it to cell $I$24 (if necessary), and format the option button to use 3-D shading.
c. Position the new option button so that its top aligns with the Social media option button to its left, and that its left aligns with the TV ad option button above it.
5. Add a check box to the section titled "Which products do you want to know more about?" as follows:
a. In cell G15, insert a Check Box (Form Control). Edit the check box text to use Video doorbell to replace the placeholder text.
b. Format the new check box to link it to cell $L$23, and format the check box to use 3-D shading.
c. Position the Video doorbell check box so that its box aligns with the top of the Security lights check box to its left.
6. Eva created a macro in Visual Basic named ClearData that clears the form for a new client. Add a button to run the macro as follows:
a. In cell G17, insert a Button (Form Control) to the right of the Save Data button. Edit the button to use Clear to replace the placeholder text, and assign the ClearData macro to the new button.
b. Format the new button to change the height to 0.3" and the width to 1". Position the Clear button to align with the top of the Save Data button on its left.
12. Eva finds that the data points are clustered too close together. She asks you to make the scatter chart easier to interpret by moving them farther apart. Change the Minimum bounds of the horizontal axis to 3000 to allow more space for the data points on the chart.
13. Go to the Orders worksheet, which contains order details for the month of May in a table named Orders. Eva wants to make sure that anyone entering the product information for other months enters the correct product IDs.