Chapter 2, Problem 9RA

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…

use the code below to create tabels. include screenshots of each completed table. CREATE TABLE PRICE ( PRICE_CODE                NUMBER(2,0)  PRIMARY KEY, PRICE_DESCRIPTION   VARCHAR2(20)  NOT NULL  , PRICE_RENTFEE                      NUMBER(5,2) CHECK (PRICE_RENTFEE >= 0), PRICE_DAILYLATEFEE NUMBER(5,2) CHECK (PRICE_DAILYLATEFEE >= 0) );   CREATE TABLE MOVIE ( MOVIE_NUM    NUMBER(8,0)  PRIMARY KEY, MOVIE_TITLE  VARCHAR2(75) NOT NULL, MOVIE_YEAR  NUMBER(4,0)  CHECK (MOVIE_YEAR > 1900), MOVIE_COST   NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE    NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); CREATE TABLE MEMBERSHIP ( MEM_NUM                   NUMBER(8,0) PRIMARY KEY, MEM_FNAME   VARCHAR2(30) NOT NULL, MEM_LNAME   VARCHAR2(30) NOT NULL, MEM_STREET  VARCHAR2(120), MEM_CITY                   VARCHAR2(50), MEM_STATE    CHAR(2), MEM_ZIP                     CHAR(5), MEM_BALANCE           NUMBER(10,2) ); PRICE: INSERT INTO PRICE VALUES (1, 'Standard', 2, 1);…

use the code below to create tabels. include screenshots CREATE TABLE PRICE ( PRICE_CODE                NUMBER(2,0)  PRIMARY KEY, PRICE_DESCRIPTION   VARCHAR2(20)  NOT NULL  , PRICE_RENTFEE                      NUMBER(5,2) CHECK (PRICE_RENTFEE >= 0), PRICE_DAILYLATEFEE NUMBER(5,2) CHECK (PRICE_DAILYLATEFEE >= 0) );   CREATE TABLE MOVIE ( MOVIE_NUM    NUMBER(8,0)  PRIMARY KEY, MOVIE_TITLE  VARCHAR2(75) NOT NULL, MOVIE_YEAR  NUMBER(4,0)  CHECK (MOVIE_YEAR > 1900), MOVIE_COST   NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE    NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); CREATE TABLE MEMBERSHIP ( MEM_NUM                   NUMBER(8,0) PRIMARY KEY, MEM_FNAME   VARCHAR2(30) NOT NULL, MEM_LNAME   VARCHAR2(30) NOT NULL, MEM_STREET  VARCHAR2(120), MEM_CITY                   VARCHAR2(50), MEM_STATE    CHAR(2), MEM_ZIP                     CHAR(5), MEM_BALANCE           NUMBER(10,2) ); PRICE: INSERT INTO PRICE VALUES (1, 'Standard', 2, 1); INSERT INTO PRICE VALUES (2,…