Work the following problems and submit your work to this que…
Work the following problems and submit your work to this question in an excel file. Problem 1 Excel Functions (20 points): Navigate to the “Problem 1” worksheet and answer the following questions in the worksheet using Excel Functions. Please input your formulas in the yellow highlighted cells. (a) (5 Points) Number of movies released after 2/10/2004 (Cell H3) (b) (5 Points) Number of movies whose length is greater than 90 minutes(Cell H6) (c) (5 Points) Return the number of movies in each length range (Cells I10:I17) 0-100, 100-120, 120-140, 140-160, 160-180, 180-200, 200-220(d) (5 Points) Find the release date of the following movies Talk, Lifted, & Quantum using the Vlookup function (Cells I22:I24) Problem 2 Excel Functions (10 points): Navigate to the “Problem 2” worksheet and answer the following questions in the worksheet using Excel Functions. Please input your formulas in the yellow highlighted cells. Based on the Time to Failure data in column A, please use the excel If function to classify the Time to Failure data into three groups: High Reliability, Medium Reliability, or Low Reliability in column B based on the following criteria: (Cells B2:B16) Time to Failure High, Medium, or Low Time to Failure
Read DetailsYou only need to answer 2 of the 4 short answer questions -…
You only need to answer 2 of the 4 short answer questions – you are welcome to answer all 4 but only the best 2 responses will count toward your grade. Compare DNA and and RNA. Make sure to discuss the type of sugar, the structure and the nitrogenous bases.
Read Details