Flashcards
Excel Module 6
Flashcards do conjunto (30)
- 1table arrayA table of information in which data is looked up. Uses a reference to a range or a range name. See also Lookup table
- 2lookup tableSee also Table array
- 3HLOOKUP functionSearches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows.
- 4VLOOKUP functionOne of the lookup and reference functions to be used when you need to find things in a table or a range by row. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.
- 5lookup valueThe data, or location of the data, you wish to look up.
- 6table argumentsThe left column values in a table array.
- 7return valueThe answer you want to appear as a result of a VLOOKUP function.
- 8column index numberThe column location of the return value within the table array.
- 9extract rangeRange in which Excel copies the records that meet the comparison criteria in the criteria range in a search or filter to another part of the worksheet.
- 10outline symbolsSymbols that appear beside rows or above columns or data that you wish to group.
- 11tableAn organized collection of data. See also Database
- 12databaseAn organized collection of data. See also Table
- 13recordThe data related to each person or item in a table.
- 14fieldsThe individual data items that make up a record.
- 15calculated fieldA field (column) in a table that contains a formula, function, cell reference, structured reference, or condition. See also Computational field
- 16computational fieldA field (column) in a table that contains a formula, function, cell reference, structured reference, or condition. See also Calculated field
- 17structured referenceReference that uses some combination of a table name, the column heading, or any named or special rows, rather than the usual column letter and row number references.
- 18sortingArranging records in a specific sequence.
- 19ascending orderData sorted from lowest to highest, earliest to most recent, or alphabetically from A to Z.
- 20descending orderData sorted from highest to lowest, most recent to earliest, or alphabetically from Z to A.
- 21sort keysThe field or fields you select to sort.
- 22criteriaA logical rule by which data is tested and chosen.
- 23queryThe process of filtering activity based on one or more filter criteria.
- 24search stringThe data you enter in a search.
- 25criteria rangeA location separate from the table used to list specific search specifications.
- 26DAVERAGE functionFunction that calculates the average of numbers in a table field that pass a test.
- 27DCOUNT functionFunction that counts the number of numeric entries in a table field that pass a test.
- 28control fieldA field on which you sort.
- 29treemap chartChart that provides a hierarchical, visual view of data, making it easy to spot patterns and trends.
- 30—
Informações
- Descrição
- FlashCards sobre Excel Module 6, criado por Jason Van Nus em 03-04-2018.
- Criado por
- Jason Van Nus
- Visualizações
- 2
- Avaliação