LESSON 4: Advanced Spreadsheet Skills

ADVANCED SPREADSHEET SKILLS

In this lesson we use the Microsoft Excel and we learned about the keyboard short cuts for making cells, series of numbers and dates. The Microsoft Excel is a spreadsheet that we can use when we work, the example of it is computing a grades. We knew that we can compute in this spreadsheet using formulas and functions like =sum which was used to total the item in a range. The = average which is the average of all the item of the range. The =count which is the value that has been found in the average. In function it uses the =count If for computing the summation of the range and the =average If for computing the average of the range.