In this video, I'm demonstrating a solution to a recent extra credit challenge students had where they needed to calculate weighted average, use conditional formatting with a formula, and create a nested function calculation.
If you'd like to try this, STOP watching the solution. Download the starting file from https://docs.google.com/spreadsheets/... and try it for yourself. Afterward, watch my demo and see how it worked out. There are multiple solutions for both. Several of my students used different, accurate techniques that I thought were quite clever.
Watch video CIS101/120 Extra Credit Solution for Excel Calculating Grades online without registration, duration hours minute second in high quality. This video was added by user Six Minutes. Smarter. 05 March 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,140 once and liked it 15 people.