Do My Homework / Homework Help Answers / Business Homework Help / Skill Review Excel Sheet (Only adding to or changing sheet)

Skill Review Excel Sheet (Only adding to or changing sheet)

Online tutoring services

Need help with this question or any other Business assignment help task? Click on the button below to to hire an expert cheap.

The excel sheet is already completed, but things half to be changed on the excel sheet for the homework. I have a lot of these sheets I need help on so if the price is good and the work is good I am willing to let this site do all my excel sheets. 

  1. On the Scores worksheet, enter a function in cell B3 to display the current date and time.
  2.  If necessary, click the Scores worksheet tab. Click cell B3.
  3.  On the Formulas tab, in the Function Library group, click the Date & Time button.
  4.  Click NOW.
  5.  Click OK.
  6. The first column should display the full student name. Use CONCAT to combine the values from the First Name and Last Name column.
  7.  Click cell A10.
  8.  On the Formulas tab, in the Function Library group, click the Text button, and select CONCAT.
  9.  Click cell C10 to enter the cell reference in the Text1 argument box.
  10.  Press Tab to move to the Text2 argument box.
  11.  Type " "to place a space between the first and last names.
  12.  Press Tab to move to the Text3 argument box.
  13.  Click cell B10 to enter the text reference in the Text3 argument box.
  14.  Click OK. The completed formula should look like this: =CONCAT(C10," ",B10)
  15. Add the PROPER function to the formula so student names do not appear in all uppercase.
  16.  Double-click cell A10 to edit the formula.
  17.  Create a nested formula by typing PROPER(between the = symbol and CONCAT.
  18.  Type another ) at the end of the formula.
  19.  Press Enter. The completed formula should look like this: =PROPER(CONCAT(C10," ",B10))
  20.  Copy the formula from cell A10 to A11:A26 to fill the list of student names. Use any method you want.
  21. Count the number of students to calculate the class size.
  22.  Click cell B2.
  23.  Type =COU
  24.  Double-click COUNTA in the Formula AutoComplete list.
  25.  Click cell A10 and drag to cell A26.
  26.  Press Enter. The completed formula should look like this: =COUNTA(A10:A26)
  27. Display your formulas to check for accuracy.
  28.  On the Formula tab, in the Formula Auditing group, click the Show Formulas button.
  29.  When you are ready to continue, hide the formulas and display formula values by clicking the Show Formulas button again.
  30. Define a named range for the total possible points up to the class drop cut-off point.
  31.  Select cells D7:R7.
  32.  In the Name box, type: PossiblePtsMid
  33.  Press Enter.
  34. Find out which students have a grade below C at the cut-off point for dropping the class. Enter an IF function in cell S10 to check if the student’s total points divided by the total possible points through the midterm is less than 70% (the lowest percentage for a C grade). Use SUM functions within the IF function. Be sure to use the range name you just defined for possible points. If the student is below a C grade, display Warning! in the cell; otherwise leave the cell blank.
  35.  Click cell S10.
  36.  On the Formulas tab, in the Function Library group, click Logical.
  37.  Click IF.
  38.  If necessary, move the Function Arguments dialog so you can see the worksheet data.
  39.  In the Logical_test argument box, type: SUM(D10:R10)/SUM(PossiblePtsMid)<70%
  40.  In the Value_if_true argument box, type: Warning!
  41.  In the Value_if_false argument box, type:""
  42.  Click OK. The completed formula should look like this:
  43. =IF(SUM(D10:R10)/SUM(PossiblePtsMid)<70%,"Warning!"," ")
  44.  Fill the IF function in cell S10 down for all students. Use any method you want. There should be three students with Warning! in the Class Drop Cut-Off Point column.
  45. Find the highest score for each assignment.
  46.  Click cell D4.
  47.  Type=MAX(and then click cell D10 and drag to cell D26.
  48.  Press Enter. The completed formula should look like this: =MAX(D10:D26)
  49.  Copy the formula across the row to cell AB4. Use any method you want. Be sure to leave cell S4 blank.
  50. Find the lowest score for each assignment.
  51.  Click cell D5.
  52.  Type =MIN(and then click cell D10 and drag to cell D26.
  53.  Press Enter. The completed formula should look like this: =MIN(D10:D26)
  54.  Copy the formula across the row to cell AB5.Use any method you want. Be sure to leave cell S5 blank.
  55. Calculate the average score for each assignment.
  56.  Click cell D6.
  57.  Type =AV and then double-click AVERAGE in the Formula AutoComplete list.
  58.  Click cell D10 and drag to cell D26.
  59.  Press Enter. The completed formula should look like this: =AVERAGE(D10:D26)
  60.  Copy the formula across the row to cell AB6. Use any method you want. Be sure to leave cell S6 blank.
  61. Compute the students’ total points. Enter a SUM function in cell AC10 to add all the points across for the first student.
  62.  Click cell AC10.
  63.  Type =SU and then double-click SUM in the Formula AutoComplete list.
  64.  Click cell D10 and drag to cell AB10.
  65.  Press Enter. The completed formula should look like this: =SUM(D10:AB10)
  66.  Copy the formula from AC10 through cell AC26. Use any method you want.
  67. Enter a formula to compute the percentage for the first student. Divide the student’s total points by the total possible points. You will be copying this formula, so make sure the reference to the total possible points uses an absolute reference.
  68.  In cell AD10, enter the following formula to calculate the percentage: =AC10/$AC$7
  69.  Copy the formula from AD10 through AD26. Use any method you want.
  70. The grade scale is stored in the Grades worksheet. Before calculating students’ final grades, create a named range to use in the formula.
  71.  Click the Grades sheet tab.
  72.  Select cells B4:C8.
  73.  Type GradeScale in the Name box.
  74.  Press Enter.
  75. Now you are ready to create a lookup formula to display each student’s final letter grade.
  76.  Return to the Scores sheet, and click cell AE10.
  77.  On the Formulas tab, in the Function Library group, click the Lookup & Reference button, and select VLOOKUP.
  78.  Click cell AD10 to enter it in the Lookup_value argument box.
  79.  Type GradeScale in the Table_array argument box.
  80.  The rates are located in the second column of the lookup table. Type 2 in the Col_index_num argument box.
  81.  In this case, you do not want to specify an exact match, as the percentage grades do not match the grade scale percentages exactly. An approximate match will return the correct letter grade.
  82.  Click OK. The completed formula should look like this: =VLOOKUP(AD10,GradeScale,2)
  83.  Fill down for all students. Use any method you want.
  84. Before closing the project, check your workbook for errors.
  85.  On the Formulas tab, in the Formula Auditing group, click the Error Checking button.
  86.  If errors are found, use the error checking skills learned in this chapter to find and fix the errors.
  87.  When Excel displays a message that the error check is complete, click OK.

Get Help With a similar task to - Skill Review Excel Sheet (Only adding to or changing sheet)

Login to view and/or buy answers.. or post an answer

Related Questions

Similar orders to Skill Review Excel Sheet (Only adding to or changing sheet)
32
Views
0
Answers
Financial Reporting 1 hr 30 (Short Exam)
The exam paper will include two sections: •Section A - 60 marks, all questions are COMPULSORY. There is a mixture of calculations and close-ended questions. •Section B - 40 marks, two out of three 3 analytical and long discursive questions....
50
Views
0
Answers
Criminal Law Make up Midterm Dan was a passenger in Vics car. While driving in a desolate mountain area

Criminal Law

Make up Midterm

Dan was a passenger in Vics car. While driving in a desolate mountain area, Vic stopped and offered Dan a hallucinogenic drug. Dan refused, but Vic said if Dan wished to stay in the car, he would have to join Vic in using the drug. Fearing that he would be abandoned in freezing temperatures many miles from the nearest town, Dan decided to ingest the drug.

Dan started to hallucinated. While under the influence of the drug, Dan killed Vic, left the body beside the road, and drove Vics car to the nearest town. On his drive back into town he ran over Ped, who was standing on the side of the road because his car had broken down. Ped died from internal bleeding, and would have survived if Dan would have stopped after hitting him and rendering aid.

After several days Dan was arrested by police officers who had discovered Vics and Peds body on the side of the road. Dan has no recall of the events between the time he ingested the drug and his arrest.

Dan has been charged with murder of Vic, and the murder of Ped. Evidence of the above facts has been introduced by the prosecution. At trial, Dan testified about the event...

94
Views
0
Answers
University of Phoenix BUSINESS IT 210 1)Internet advertising typically is one-way and impersonal. Which of the

University of Phoenix

BUSINESS IT 210

  1. Internet advertising typically is one-way and impersonal.
  2. Which of the following electronic payments is ideal for micropayments?
  3. The primary characteristic of auctions is that prices are determined dynamically by competitive bidding.
  4. Clicks-and-mortar organizations conduct some business in the physical world, yet their primary business involves e-commerce activities.
  5. When two companies fight over a domain name, the company that has been in the business longer and has already purchased the domain name is considered the owner of the domain.
  6. When organizations request for bids for contracts on their own Web site for procurement, such business is classified as a(n)
  7. In general, the e-commerce Web sites of click-and-mortar companies operate only during the business hours of their brick-and-mortar stores.
  8. Cybersquatting refers to the tampering of existing Web sites and selling unrelated products.
...
159
Views
0
Answers
Formulating Functions in a pre-made incomplete excel sheet
Hi there, This is my first time submitting a question here. As I am extremely busy with multiple deadlines from several courses. I overlooked this one particular assignment have don't have enough time to complete it. The assignment consists of basic Excel functions such as VLOOKUP, COUNTIF, SUMIF. If you have the time to complete this within my desired completion date. I would greatly appreciate it. P.S. The Microsoft Word doc is a guideline on what to do. The Excel sheet is where you must complete the work....