Microsoft Excel Formula assignment: The objective of this assignment is to create 100 [5x5] tables and each 5 by 5 table will have mix of numbers from 1 to 100. The numbers placed in the 5x5 table have to be randomized and cannot have a matching table (out of the 100 tables). AND each table cannot repeat the same number. I need to create this without having to manually type numbers and create the 5 by 5 tables. Please solve this assignment. simpifly the assignment (If needed) by producing 20 tables to start it out. This assignment demonstates the examples for formulas on excel. TIP: Formulas would help out! Here is two examples for 2 tables. TABLE 1: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 TABLE 2: 59 2 3 4 1 33 72 8 9 66 11 22 13 88 15 16 17 18 19 5 29 40 99 30 21

Use Visual Studio to create a database named Personnel.mdf. The database should have a table named Employee, with columns for employee ID, name, position, and hourly pay rate. The employee ID should be the primary key. Insert at least five sample rows of data into the Employee table. Create an application that displays the Employee table in a DataGridView control.

Create a formula that provides the start date of a project as follows: In cell H4, begin to enter a formula using the INDEX Use the Lookup table (range A2:E23) as the array. For the row_num argument, use the MATCH Use the Project ID (cell H2) as the lookup_value for the MATCH function. Use the ID column (range A2:A23) as the lookup_array for the MATCH function. Specify an exact match (0) for the MATCH function. Use the Start Date column (column 4) as the column_num for the INDEX function.

Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer whose ID currently is stored in I_CUST_ID. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. When the procedure is called it should output the contents of I_CUSTOMER_NAME and I_CREDIT_LIMIT.

Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.

SELECT RegisteredName, Height FROM HorseWHERE Height > ALL(SELECT avg(Height) FROM Horse GROUP BY Height); This does not work^

Which command will return the corner elements of a 10-by-10 matrix A?

The Movie table has the following columns: ID - positive integer Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write ALTER statements to make the following modifications to the Movie table: Add a Producer column with VARCHAR data type (max 50 chars). Remove the Genre column. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.

Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for 215ドル per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered To Price per Roll From 1 70 215ドル 71 140 195ドル 141 280 175ドル 281 and up 155ドル Click on the datafile logo to reference the data. DATA file (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. (b) Use the COUNTIF function to determine the number of orders in each price bin. From Number of To Price per Roll 70 215ドル !!! 140 195ドル 280 175ドル and up 155ドル 1 71 141 281 Orders 172

Create R code to verify all factorial scenarios.

calculate_trip_time( iata_src: str, iata_dst: str, flight_walk: List[str], flights: Flight Dir float: def ) -> """ Return a float corresponding to the amount of time required to travel from the source airport to the destination airport to the destination airport, as outlined by the flight_walk. The start time of the trip should be considered zero. In other words, assuming we start the trip at 12:00am, this function should return the time it takes for the trip to finish, including all the waiting times before, and between the flights. If there is no path available, return -1.0>>> calculate_trip_time("AA1", "AA2", ["AA1", "AA2"], TEST_FLIGHTS_DIR_FOUR_ 2.0 "AA7", ["AA7", "AA1"], TEST_FLIGHTS_DIR_FOUR_ "AA7", ["AA1", "AA7"], TEST_FLIGHTS_DIR_FOUR_ "AA1", ["AA1"], TEST_FLIGHTS_DIR_FOUR_CITIES) "AA2", ["AA4", "AA1", "AA2"], TEST_FLIGHTS_DI "AA3", ["AA1", "AA2", "AA3"], TEST_FLIGHTS_DI>>> calculate_trip_time("AA1", "AA4", ["AA1", "AA4"], TEST_FLIGHTS_DIR_FOUR_ 2.0 || || ||>>>...

DONT COPY FROM CHEGG == REPORT + DISLIKE 9. List the genre name and count of all tracks in each genre, in descending order of track count (so the genre with the most tracks is listed first)

In cell B12, create a nested formula using the AVERAGE and ROUND functions to first find the average number of clothing sets sold in January (the range B6:B9), and then round the answer to 0 digits. Copy the formula from cell B12 to the range C12:N12.