Create a table of your courses for this semester with fictitious grades for Test 1, Test 2, and Test 3 with appropriate weighting. The next column should determine the grade using the 'if' function, with plus and minus. The grade cell should show a discrete color scheme with below C- in red; above B in green and, yellow for the rest. This should be done using conditional formatting of cells.

Create a table of your courses for this semester with fictitious grades for Test 1, Test 2, and Test 3 with appropriate weighting. The next column should determine the grade using the 'if' function, with plus and minus. The grade cell should show a discrete color scheme with below C- in red; above B in green and, yellow for the rest. This should be done using conditional formatting of cells.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 3.3CP

See similar textbooks

Similar questions

Split the MR_X and MR_y into training set and test set. You should use the num training variable to extract the data from MR_X and MR_y. Extract the first 'num_training' samples as training data, and extract the rest as test data. Name them as: MR_train_X and MR_train_y for the training set MR_test_X and MR_test_y for the test set
Statistics AUS DFW IAH # of Shipments Total Order Value Average # of Days Houston (IAH) Orders Over $1,000 Number of Orders Shipped Total of Orders Shipped Highest Order Value Airport Order Date Ordered Total Days 4/5/2021 4/5/2021 4/5/2021 Code Total 4 AUS $ 975 $ 1,055 $ 1,075 $ 1,000 $ 2,535 $ 1,890 10 AUS 11 IAH 4/5/2021 7 DFW 4/5/2021 11 IAH 4/5/2021 4/5/2021 7 DFW 11 AUS 950 4/6/2021 9 DFW $ 1,485 4/6/2021 4/6/2021 3 DFW $ 550 $ 1,250 $ 1,600 $ 2,500 $ 1,425 13 AUS 4/6/2021 8 IAH 4/6/2021 13 DFW 4/7/2021 IAH Week Stats Map Loan
The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER_ID, and two calculated columns: DAY and RIDES. The DAY column is calculated using the DAY() function with the TRAVEL_START_TIME as the argument. The RIDES column is calculated by using the COUNT() function to determine the number of rides given for each day. Filter the results with the MONTH function.
HW7_3 Ball bearings are hardened through a process known as quenching-submersion of the heated ball bearing in oil or water in order to cool it rapidly. The data below represent the temperature of the ball at various points in the cooling process time (sec) 0 30 Temp (C) 800 457 269 79 46 60 150 240 Plot the data (as discrete points). In the same figure window, also plot a) interpolating polynomial, (use polyfit and polyval) b) piecewise cubic interpolation (not-a-knot) and c) piecewise cubic interpolation (shape-preserving) Include a legend for the three methods used: polynomial interpolation, not-a-knot, shape-preserving. Then looking at the plot, choose the method you believe to be the best and smoothest fit of all these to predict the temperature after 3 minutes of cooling. Print the result using fprintf.
Lael is constantly looking for students who are interested in running for office in student organisations. In cell M2, insert the following formula, which uses a nested IF function and structural references to assess if a student has already been elected to office in a student group, and if not, whether that student fits the conditions to run in the future: If the Elected column value equals the string "Yes," the formula should display Elected as the text. Otherwise, the formula should check if the value in the Finance Certified column is equal to the word "Yes" and return the text Yes if it is and No if it is not. What is the formula that should be entered into Excel?
Q6. What is the code to align Name, Score1, Score2, Score3 in Form-Load(). Select and apply passing function according to the situation.
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…
Click cell C9 and insert a VLOOKUP function that looks up the code in cell B9, compares it to the codes and types of art in the range B2:C6, and returns the type of art. Copy the function in cell C9 to the range C9:C54. Hide column B that contains the codes.
The population of the five most populous Australian cities at the last three census is recorded in the following cell. Piot a side- by-side bar chart to show the change in the populations, The chart should be grouped by each city and show each census in different colours. The legend should explain the colours for the census. Your plot should include an appropriate title. In [ J: cities - ['sydney', Melbourne', 'Brisbane', Perth', 'Adelaide') Pop_2016 - (4321535,4196198,2054614,1874578,11656321 Pop_2011 - [3908642,3707530,1874427,1627576,11039791 Pop_2006 - [3641422,3371888,1676389,1256035,10407191 In [ ]:
: The general equation for the distance, d, in meters that a free falling body has travelled (neglecting air friction) is Gravity on Mars is, g = 3.711 m/sec2. Create a table of time vs distance traveled on Mars for each of the following conditions. You should have 3 tables, one for each part a b c, when you are finished. Your tables must have column headings. You do not necessarily need to use Properties.VariableNames, but I prefer it. Values of time from 0 to 120 seconds in 10 second increments. Ten evenly spaced values of time from 0 to 120 seconds. (Evenly spaced does not mean 12 seconds between each!) Fifteen logarithmically spaced values of time from 0.1 seconds to 100 seconds
Open the Excel file Student_Excel_Intro_Cap1_Year_End_Report.xlsx downloaded with this project. On the Net Sales worksheet, calculate totals in the ranges F4:F8 and B9:F9. Apply the Total cell style to the range B9:F9. Using absolute cell references as necessary, in cell G4, construct a formula to calculate the percent that the Colorado Total is of Total Sales, and then apply Percent Style with zero decimals. Fill the formula down through the range G5:G8. In the range H4:H8, insert Line sparklines to represent the trend of each state across the four quarters. Do not include the totals. Display Markers. Select the range A3:E8, and then use the Recommended Charts command to suggest an appropriate chart. Click the first Clustered Column chart that uses the state names as the category axis. Align the upper left corner of the chart inside the upper left corner of cell A11, and then size the chart so that its lower right corner is slightly inside cell H24. Apply chart Style…
The box plots show student results in Maths and Science test scores. What is the lowest mark in the Science test? Compare the distribution of the marks in the Maths test and marks in theMaths test.