Chapter 5, Problem 4AYK

1. Use the fill handle to create two lists of percentages: (a) 4.00% through 13.00% in increments of 0.50% in the range I5:I23 and (b) 4.00% through 11.00% in increments of 1.00% in the range J4:Q4. 2. Use the Data Table button in the What-If Analysis gallery (Data tab | Forecast group) to define the range I4:Q23 as a two-input data table. Enter C8 in the ‘Row input cell’ box and C5 in the ‘Column input cell’ box (Data Table dialog box). Click OK to populate the table. 3. Format the two-input data table using a White, Background 1 font color and the fill color used in cells B3:G12. Bold ranges I4:Q4 and I5:I23. Format cells J5:Q23 to match the number format used in cells F5:G12. Place a light style border around the range I3:Q23, light style borders between columns in that same range, and a light style bottom border on the range I4:Q4. 4. Protect the worksheet so that the user can select only unlocked cells (C3:C6 and C8:C9). *Complete the following using Excel based off the document…

CLL question Next within the form, create a field set with the ID deliveryInfo. Within this field set, add the following: A legend containing the text Delivery Options. A text area box with the ID addressBox and field name of delAddress containing the placeholder text Enter delivery address. A label containing the text Delivery time (leave blank for earliest delivery) associated with the delBox control. Add an input element with the ID delBox and field name delTime for storing delivery time values. Use a data type of “time” for the control.

Delivery Info Next within the form, create a field set with the ID deliveryInfo. Within this field set, add the following: A legend containing the text Delivery Options. A text area box with the ID addressBox and field name of delAddress containing the placeholder text Enter delivery address. A label containing the text Delivery Time (leave blank for earliest delivery) associated with the delBox control. Add an input element with the ID delBox and field name delTime for storing delivery time values. Use a data type of “time” for the control. Pickup Info Next within the web form, create a field set with the ID pickupInfo containing the following information for pickup orders: A legend containing the text Pickup Options. A label containing the text Pickup Time (leave blank for earliest pickup) associated with pickupBox control. Add an input element with the ID pickupBox and field name pickupTime for storing time values. Add the disabled attribute to the tag to disable this control…