LESSON 4 - ADVANCED SPREADSHEET SKILLS

In this lesson, I learned how to create in microsoft excel.

Microsoft Excel is a spreadsheet program for entering, editing,manipulating and printing information in a tabulate form. When you need to compute the grades, you need to know the formula and functions to compute it.

  There are 8 formula when computing, sum(range) is to compute the all items, average(range) used to get the average of items, count(range) used to count the values, min(range) used to get the smallest value, max(range) used to get the largest value, sumif(range,criteria) is a function used to compute for the summation, countif(range,criteria) used to count the cells and last the averageif(range,criteria) used to compute the average.

  Creating in Microsoft Excel is easy if we are going to follow the steps. We need to know how to create in microsoft excel because what if we are required to make a spreadsheet form? That's why this is important to us.