Chapter 1, Problem 2AYK

The accompanying Gradebook spreadsheet contains a partially completed spreadsheet model for computing and summarizing the grades for a class. Complete the spreadsheet model by entering and copying the formulas in the appropriate cells. Cell range H4:H17 should contain the course number grades using the grades from exams and homework assignments and the grade allocation in row 22. Cell range I4:I17 should contain the course letter grades based on the grading criteria in cell range K4:L8. Rows 19, 20, and 21 should contain the average, maximum, and minimum exam, homework, and course number grades. You should only enter each formula once and copy the formulas to other cells. Gradebook                               Student ID Exam 1 Exam 2 Exam 3 Homework 1 Homework 2 Homework 3 Course Number Grade Course Letter Grade   Grading Criteria 000-01-5562 60 50 40 79 92.0 76       0 F 000-01-2667 80 71 70 84 81.0 90       60 D 000-01-7376 65 65 65 60 90.0 94       70 C 000-01-1986…

Using the colon symbol, create a row vector (assign it to a variable named Fives) with five elements that are all five.

Task Instructions X Use the Word Count dialog box to display the number of words in the document, and include words in textboxes, footnotes, and endnotes in the count. Close the Word Count dialog box when you are finished.

From this data frame, remove the age column and make the day in increasing order - Code should have comments Gender Age 1 2 M 3 F F 45 5 M 17 51 62 23 Month Day 3 4 22 12 13 25 8 1

Create a table using a two-dimensional array that stores a Fahrenheit temperate and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures -10 through 100 in increments of 10, thus the temperatures will be -10, 0, 10, 20, 30, 40, 50 …and so on Display the contents of the list. Similarly create tables/lists for the following (starting at 0 through 100 in increments of 10 Miles to kilometers Gallons to liters Pounds to kilograms Inches to centimeters Display the contents of each list

Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20

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.

1- Display contact First name and contact Last name for customers after sorting the customersby their contact Last name in ascending order.2- selects the order line items (orderNumber, orderlinenumber) from the “orderdetails” table.Also, display the subtotal (quantityOrdered * priceEach) for each line item and sorts the resultset based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantity ordered(itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition “total”greater than 1000.8- Display product code, product…

Which of the following statements assigns the string “California” to the element located in the fourth column, sixth row in the two-dimensional strStates array? a. strStates(3, 5) = "California" b. strStates(5, 3) = "California" c. strStates(6, 3) = "California" d. strStates(3, 6) = "California"