Chapter 1, Problem 1.11CP

TabIndex values begin with the number 1. True or False?

Which comparison operator indicates a value is not equal?   a. <>   b. <=   c. <   d. >=

Type Reduction in cell M1   The amount is 50% of sick days above 10, whenever sick days exceed 10. For all other records, the amount is 0 Create the criteria area, starting in cell P8   Enter formula(s) to complete column M, using an IF Statement.

q7-  Options for both fill in the blanks are- primary key,foreign key

The Movie table has the following columns: ID - integer, primary key Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write a SELECT statement to select the year and the total number of movies for that year. Hint: Use the COUNT() function and GROUP BY clause

Write a Select statement that returns the Trading_Symbol column and the Num_Shares column only from the rows where Selling_Price is greater than Purchase_Price and Num_Shares is greater than 100. The results should be sorted bythe Num_Shares column in ascending order.

(p) Using the SUMIFS function, write a formula in cell H64 to compute the total number of hours for which Small & Spot servers are rented. Copy the formula down to cells H65 to H69. (q) In cell I64, write a formula to compute the Average Hourly Rate for the Spot and Small servers. Average hourly rate = (Total Cost)/(Total Number of hours). Copy the formula down to cells I65 to I69. Screen shots attached below thank you!!