You are taking a teaching methods course at your college to prepare you to be a secondary educa-tion teacher. One course module teaches students about gradebook preparation, in which you learn how to create formulas to assign grades based on course assessment instruments. Your methods professor assigned a flawed gradebook to see how well you and the other future teachers will do in identifying and correcting the errors. Open e09d1Grades and save it as e09d1Grades_LastFirst. Set validation rules for the range of quiz and final exam scores to accept whole number scores between 0 and 100 only. Create appropriate input and error messages. Use the feature to circle invalid data. Use the Windows Snipping Tool to capture a screenshot of the Excel window, copy it, and paste it in cell N2. Crop the image to show just column letters, row numbers, and spreadsheet data through column M. Adjust the height of the screenshot to 3″. Insert a comment in each cell containing invalid data describing what is wrong with the data and how to fix it. Then fix the data-entry errors. Use the auditing tools to find errors and display precedents and dependents to identify errors. The auditing tools will not find the errors. They will help you trace formulas so that you can iden-tify logic errors in formulas and functions. Use the Windows Snipping Tool to capture a screenshot of the Excel window, copy it, and paste it in cell N21. Crop the image to show just column letters, row numbers, and spreadsheet data through column M. Adjust the height of the screenshot to 3″. Correct the errors in the formulas. Insert comments indicating the errors found and how you cor-rected the formulas. Delete the data in the range E3:G3 and notice the #DIV/0! Error in cells H3, K3, and L3. Click Undo to restore the quiz values. Edit the quiz average function in cell H3 by enclosing it as the first argument in an IFERROR function. Type Missing all three quiz scores in the Value_if_errors argument. Save the workbook. Delete the range E3:G3 again. Notice the message in cell H3. Click Undo to restore the quiz values. Copy the IFERROR function with the nested AVERAGE function from cell H3 to the range H4:H12.

Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the worksheet. Save and close the file. Based on your instructor’s directions, submit e09d1Grades_LastFirst.

You are taking a teaching methods course at your college to prepare you to be a secondary educa-tion teacher. One course module teaches students about gradebook preparation, in which you learn how to create formulas to assign grades based on course assessment instruments. Your methods professor assigned a flawed gradebook to see how well you and the other future teachers will do in identifying and correcting the errors. Open e09d1Grades and save it as e09d1Grades_LastFirst. Set validation rules for the range of quiz and final exam scores to accept whole number scores between 0 and 100 only. Create appropriate input and error messages. Use the feature to circle invalid data. Use the Windows Snipping Tool to capture a screenshot of the Excel window, copy it, and paste it in cell N2. Crop the image to show just column letters, row numbers, and spreadsheet data through column M. Adjust the height of the screenshot to 3″. Insert a comment in each cell containing invalid data describing what is wrong with the data and how to fix it. Then fix the data-entry errors. Use the auditing tools to find errors and display precedents and dependents to identify errors. The auditing tools will not find the errors. They will help you trace formulas so that you can iden-tify logic errors in formulas and functions. Use the Windows Snipping Tool to capture a screenshot of the Excel window, copy it, and paste it in cell N21. Crop the image to show just column letters, row numbers, and spreadsheet data through column M. Adjust the height of the screenshot to 3″. Correct the errors in the formulas. Insert comments indicating the errors found and how you cor-rected the formulas. Delete the data in the range E3:G3 and notice the #DIV/0! Error in cells H3, K3, and L3. Click Undo to restore the quiz values. Edit the quiz average function in cell H3 by enclosing it as the first argument in an IFERROR function. Type Missing all three quiz scores in the Value_if_errors argument. Save the workbook. Delete the range E3:G3 again. Notice the message in cell H3. Click Undo to restore the quiz values. Copy the IFERROR function with the nested AVERAGE function from cell H3 to the range H4:H12.

Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the worksheet. Save and close the file. Based on your instructor’s directions, submit e09d1Grades_LastFirst.

You are taking a teaching methods course at your college to prepare you to be a secondary educa-tion teacher. One course module teaches students about gradebook preparation, in which you learn how to create formulas to assign grades based on course assessment instruments. Your methods professor assigned a flawed gradebook to see how well you and the other future teachers will do in identifying and correcting the errors. Open e09d1Grades and save it as e09d1Grades_LastFirst. Set validation rules for the range of quiz and final exam scores to accept whole number scores between 0 and 100 only. Create appropriate input and error messages. Use the feature to circle invalid data. Use the Windows Snipping Tool to capture a screenshot of the Excel window, copy it, and paste it in cell N2. Crop the image to show just column letters, row numbers, and spreadsheet data through column M. Adjust the height of the screenshot to 3″. Insert a comment in each cell containing invalid data describing what is wrong with the data and how to fix it. Then fix the data-entry errors. Use the auditing tools to find errors and display precedents and dependents to identify errors. The auditing tools will not find the errors. They will help you trace formulas so that you can iden-tify logic errors in formulas and functions. Use the Windows Snipping Tool to capture a screenshot of the Excel window, copy it, and paste it in cell N21. Crop the image to show just column letters, row numbers, and spreadsheet data through column M. Adjust the height of the screenshot to 3″. Correct the errors in the formulas. Insert comments indicating the errors found and how you cor-rected the formulas. Delete the data in the range E3:G3 and notice the #DIV/0! Error in cells H3, K3, and L3. Click Undo to restore the quiz values. Edit the quiz average function in cell H3 by enclosing it as the first argument in an IFERROR function. Type Missing all three quiz scores in the Value_if_errors argument. Save the workbook. Delete the range E3:G3 again. Notice the message in cell H3. Click Undo to restore the quiz values. Copy the IFERROR function with the nested AVERAGE function from cell H3 to the range H4:H12.

Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the worksheet. Save and close the file. Based on your instructor’s directions, submit e09d1Grades_LastFirst.