Practice: A Grade Book
A teacher records two tests and an exam. The final mark is 30% test 1, 30% test 2 and 40% exam. Then a grade is given and a class summary is worked out.
In this course each line of an example is one cell: the address, a colon, then what is in the cell. A line starting with = is a formula. Press Run to see the sheet with every formula worked out.
Exampleexcel
Quick check
Which function finds the name of the student with the highest final mark?
Your turn: write the code
Fill E2:E5 with the final mark: 30% of test 1 plus 30% of test 2 plus 40% of the exam, rounded to 1 decimal.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.