BUSI 201 Assignment 5 Excel 2016 Skill Review 3.2 Liberty University answers complete solutions

BUSI 201 Assignment 5 Excel 2016 Skill Review 3.2 Liberty University answers complete solutions Complete many different versions to get an A on your grade! Download it for more and ace on your assignments! Skill Review 3.2 Skills needed to complete this project: • Using Date and Time Functions • Using CONCAT to Combine Text • Formatting Text Using Functions • Creating Formulas Using Counting Functions • Using Formula AutoComplete to Enter Functions • Displaying and Printing Formulas • Naming Ranges of Cells • Using the Logical Function IF • Using the Function Arguments Dialog to Enter Functions • Working with Named Ranges • Finding Minimum and Maximum Values • Calculating Averages • Finding Data Using the VLOOKUP Function • Checking Formulas for Errors c. Click cell C10 to enter the cell reference in the Text1 argument box. 1. Open the start file EX2016-SkillReview-3-2. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. Click the Enable Editing button in the Message Bar at the top of the workbook so you can modify it. 2. Take a look at the two sheets. The first sheet contains the students' names and their scores. The second sheet will be used to look up the letter grade for each student. 3. On the Scores worksheet, enter a function in cell B3 to display the current date and time. 4. The first column should display the full student name. Use CONCAT to combine the values from the First Name and Last Name columns. 5. Add the PROPER function to the formula so student names do not appear in all uppercase. =PROPER(CONCAT(C10," ",B10)) 6. Count the number of students to calculate the class size. 7. Display your formulas to check for accuracy. 8. Define a named range for the total possible points up to the class drop cut-off point. 9. 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. 10. Find the highest score for each assignment. 11. Find the lowest score for each assignment. 12. Calculate the average score for each assignment. 13. Compute the students’ total points. Enter a SUM function in cell AC10 to add all the points across for the first student. 14. 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. 15. The grade scale is stored in the Grades worksheet. Before calculating students’ final grades, create a named range to use in the formula. a. Click the Grades sheet tab. 16. Now you are ready to create a lookup formula to display each student’s final letter grade. a. Return to the Scores sheet, and click cell AE10. 18. When Excel displays a message that the error check is complete, click OK. 19. Save and close the workbook. 20. Upload and save your project file. 21. Submit project for grading.