Chapter 3, Problem 1.9EYK

The Department summary table should look up the department abbreviation and return all of the data listed. It needs to be filled out. To begin, next to the cell listed "Department", use a function to search the staff table data (not including the row of headings and the total row) and return the department name based on the abbreviation above. The formula will be copied, so make sure it always references the abbreviation. Copy the formula down to complete the Department summary table, and edit the copied formulas to return the values from the headings listed in the left-hand column. In the appropriate cell below the staff table, use a function to display the current date without displaying the time. The averages will not be needed, so delete column O. The date for the next update isn't certain, so hide row 18. Switch to the Budget worksheet, which contains the department budgets from 2021 to 2025. There's already a pie chart showing 2021 budget information, and Carmelo wants another…

2 The Week worksheet contains data for the week of April 5. In cell D7, insert the appropriate date function to calculate the number of days between the Date Arrived and Date Ordered. Copy the function to the range D8:D35. Next, you want to display the city names that correspond with the city airport codes. In cell F7, insert the SWITCH function to evaluate the airport code in cell E7. Include mixed cell references to the city names in the range F2:F4. Use the airport codes as text for the Value arguments. Copy the function to the range F8:F35. 4 Now you want to display the standard shipping costs by city. In cell H7, insert the IFS function to identify the shipping cost based on the airport code and the applicable shipping rates in the range G2:G4. Use relative and mixed references correctly. Copy the function to the range H8:H35. Finally, you want to calculate a partial shipping refund if two conditions are met. In cell 17, insert an IF function with a nested AND function to…

Modify the Job_class column of the EMPLOYEES table so that it allows storing a maximum width of two characters.

Create a new table containing the category code and description for the categories of books sold by JustLee Books. The table should be called CATEGORY, and the columns should be CatCode and CatDesc. The CatCode column should store a maximum of 2 characters, and the CatDesc column should store a maximum of 10 characters.

Exercise 1 - Ms excel Insert Pivot Table: Your task is to bring up the pivot table. Then remove the grand total and edit the pivot table. Group Data by Year: The second task is to group the sales amount by the year or months. Find Running Total by Date: Your objective is to find the running total by date using the data. Insert a Pie Chart: You will create a pie chart from the data in this problem, you will need to insert slicer to the pivot table. Use the calculated Field to find the sales tax which is 5% of the total sales.

5. Using the Max function, write a formula in cell F7 of Top10_Pivot Sheet to find the maximum "Sum of Percentage" value. Do not select the Grand Total range in the function.6. Using the MATCH function only, write a formula in cell G7 of Top10_Pivot Sheet to find the Row Number of Maximum Sum of percentage.7. Using the INDEX function only, write a formula in cell H7 to find the state name having the maximum "Sum of Percentage". The formula should include the value(row number) that is calculated in G7.

The SAS table hold.work contains a numeric column named ID. Write an entire DATA step to create a table named hold.work2 that is a copy of hold.work but additionally contains a new character column named Name. Name should have the value "Food" when the existing numeric column ID is 50, and it should have the value "Ok" otherwise. [Note: Make sure the entire value is stored.]

Which of the following is not a valid INSERT statement?   a. INSERT INTO table_name VALUES (val1, val2);     b. INSERT INTO table_name (column1, column2) VALUES (val1, val2);     c. INSERT INTO table_name1 SELECT col1, col2 FROM table_name2;     d. INSERT INTO table_name1 VALUES (SELECT col1, col2 FROM table_name2);     e. All of the above     f. None of the above

The HAVING clause applies to columns and expressions for individual rows, while the WHERE clause is applied to the output of a GROUP BY operation.     True or False ?