Question: Open the InsertFormControls workbook in Excel, and then perform the following tasks: 1. Create a spin button, with the label text Pounds, that initially displays
Open the InsertFormControls workbook in Excel, and then perform the following tasks: 1. Create a spin button, with the label text Pounds, that initially displays the number 0 and lets the user enter a value from 0 to 70 pounds, in increments of 1 pound, into cell A2. 2. Create a spin button, with the label text Ounces, that initially displays the number 0 and lets the user enter a value from 0 to 16 ounces, in increments of 1 ounce, into cell B2. 3. Create a combo box with the label text Method that derives its values from cells A2:A6 on the ServiceLevels worksheet, and assign its output to cell C2. 4. Create two option buttons labeled Signature Required and Signature Waived. Assign the value of the Signature Required option button to cell D2 and the value of the Signature Waived option button to cell E2. 5. Create a group that allows either the Signature Required or Signature Waived option button to be selected, but not both.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
