answersLogoWhite

0

The Average function in Excel will help you calculate the average, or more specifically the arithmetic mean. Excel's average function checks all the number in a given range and calculates the average of them, by adding the values and dividing by the amount of values. Cells with no data will not be included in the calculation.

The Average function looks like this =AVERAGE(number1,number2) where each number can be a reference for a cell or range of cells or can be entered manually. For example =AVERAGE(50,100) equals 75.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

What does mean spreadsheet?

A spreadsheet means a computer application that is used to simulate paper accounting.


How can the average value of all the values in column D between rows 4 and 20 be calculated within a spreadsheet program?

=AVERAGE(D4:D20) or =AVERAGE(D5:D19), depending on what you mean by "between rows"


How many rows are used in the average salary spreadsheet?

There is no way to determine that without knowing how many salaries you what to list on the spreadsheet.


What does it mean to paint in Excel?

paint it on the spreadsheet


What do the letters in the file name extension 'xls' mean?

They are short for "Excel Spreadsheet."


Why do we learn Microsoft excel?

If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.


What is another name for worksheets in excel?

A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.


What is another name for worksheet?

A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.


What are Four typical commands implemented in a spreadsheet program?

SUM, AVERAGE, MIN and MAX.


What is the difference between spreadsheet and worksheet?

A spreadsheet file can contain multiple worksheets. Worksheet is the "grid" that you use to fill information and a spreadsheet can be a single worksheet or multiple worksheets


What is more smallest a column or a row?

There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.


What does debug mean when opening an Excel spreadsheet?

To debug means to fix errors.