# In Excel what is a list?

It is like the ordinary understanding of a list, in that it is a set of values that are listed in your spreadsheet. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel. If you type in any day of the week or any month of they year into a cell, and then click and drag on the fill handle, it will fill out subsequent days or months. You will find Custom Lists under the Tools menu under Options.

### What does daverage do in Excel?

It calculates an average from a database list in Excel, using specified criteria. It calculates an average from a database list in Excel, using specified criteria. It calculates an average from a database list in Excel, using specified criteria. It calculates an average from a database list in Excel, using specified criteria. It calculates an average from a database list in Excel, using specified criteria. It calculates an average from a database list in Excel…

### What is Drop Down list called in Excel?

The control to create a drop down list in Excel is called a Combo Box. The control to create a drop down list in Excel is called a Combo Box. The control to create a drop down list in Excel is called a Combo Box. The control to create a drop down list in Excel is called a Combo Box. The control to create a drop down list in Excel is called a Combo Box…

### What is a lookup list in Excel?

It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below. It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below. It is a list that you can search through to find a value. There are…

### What is the meaning of error in macros- Excel?

Macros are like small programs, which are a list of instructions to Excel to do a task. If there is a mistake in the instructions or some other problem, then it may not work properly and you will get an error. Macros are like small programs, which are a list of instructions to Excel to do a task. If there is a mistake in the instructions or some other problem, then it may not work…

### What are the functions that can be use in Excel?

Excel has about 334 functions, so too many to list here. They are divided into the following main categories: Financial Date and Time Math and Trigonometrical Statistical Database Text Logical Lookup and Reference Information Engineering Cube In Excel you will find a list of the functions under each category when you go to insert a new one. You will also find a list at the link below: Excel has about 334 functions, so too many…

### What is a Table array in Excel?

An array is a list of values that are in some way related to each other. It could be a list of wages or a list of sales or a list of dates of birth etc. When they are laid out in a table, it can be called a table array. A lot of functions in Excel use table arrays to do their calculations. You can also create array formulas.

### How do you put a multiple filter in Microsoft Excel spreadsheet?

It is not possible to have multiple autofilters in one worksheet. What you can do is select your range(s) and convert them to a list/table by going to Data->List in Excel 2003 or Insert->Table in Excel 2007. This will give you the functionality of an autofilter, but it can be applied to several ranges within the same worksheet.

### How do you open Microsoft Excel and MS PowerPoint programme?

Click the Start button, then All Programs, and you may then have Microsoft Office on your list. In there you would find both Excel and Powerpoint. Click on the one you want to start it. They may even be directly on the All Programs list. Click the Start button, then All Programs, and you may then have Microsoft Office on your list. In there you would find both Excel and Powerpoint. Click on the one…

### What are three things you can ask Excel to do?

Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application. Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application. Sort…

### What is the function AutoComplete list in Excel?

When you are entering a function, after you type an = (equal sign) and beginning letters or a display trigger, Excel displays below the cell a drop-down list of valid functions, names, and text strings that match the letters or trigger. This is the Autocomplete list for the functions. When you then pick a function, you can also get help for the individual arguments within the function.

### What is the function of Custom Filter in Excel?

It allows you to define you own criteria to filter out cells from a list. This has many uses for a user of Excel. You can choose to list cells that fit certain conditions, like choosing values within a set range that you define. So you could have a load of values and list just the ones between 50 and 100 for example.

### What is extract in Excel?

It is when you want to get some data that fits some criteria out of a full list of data, like you would in a database. So if you had a list of people, you might want to extract the ones who are over a certain age or who are male or who live in a certain place. Excel provides that facility. The extracted data can be listed separately to the full list of data…