Module 2 Unit 4
What is next?
Now that you have populated your spreadsheet with the names and surnames of one of your classes, as well as put in some test results, let's start using the functionality which MS Excel (or Google Sheets) can offer us! Using this spreadsheet is supposed to make your work easier and up to now, you have been putting in all the effort - let's make the spreadsheet put in the effort now!
It's useful to know what the average mark was in a particular test. Well, using a spreadsheet, you will be able to get this information almost immediately!
Sometimes in a spreadsheet, we don't just want to find out the average or add a column of numbers, we may have more sophisticated requirements! For example, some tests may be out of 50 and others out of 10: you may want to convert the test out of 10, to the equivalent mark out of 50. To do this, you will need to insert a formula into your spreadsheet. You only need to write the formula into one cell, then you can automatically apply this formula to an entire column or row. Let's find out more....