The process of inserting data from another application, such as bringing in data from a text delimited file into an Excel worksheet.
What is importing?
100
An area within the worksheet that specifies the conditions to filter the table.
What is criteria range?
100
Process of splitting a column of data into multiple columns.
What is convert text to columns?
100
Functions based on a criteria.
What are conditional functions?
200
Character used to separate one column from another in a text file.
What is a delimiter?
200
Word or string of characters, to represent a cell, range of cells, or constant value. May be used within a formula instead of a cell reference.
What are range names?
200
Joins two or more text strings into one text string and permits you to include the comma or space separators in the text string.
What is concatenate?
200
Functions that enable a user to select from multiple options.
What is a logical function?
300
Apply specific formats automatically to cells that contain particular values or content.
What is conditional formatting?
300
Area of the worksheet containing the entire table on which the database functions operate.
What is a database range?
300
Functions used to manipulate text into all lowercase, uppercase, etc. format.
What are text functions?
300
This function enables you to calculate total values in a range that satisfies a specific condition you specify instead of calculating the total of an entire range.
What is SUMIF?
400
The action that arranges records in a table by the value of one or more fields within a table.
What is sorting?
400
The column in the database that contains the values operated on by the database function.
What is a field?
400
Inserts a subtotal row, such as the sum or average of values by category, where the value of the designated field changes.
What is a subtotal?
400
Adds the cells in a range that meet multiple criteria.
What is SUMIFS
500
A powerful, interactive data mining feature that enables you to quickly summarize and analyze large amounts of data in tables.
What is a pivot table?
500
Adds up or sums the numeric entries in a field of records in a list or database that match conditions you specify.
What is DSUM?
500
The process of dividing a worksheet window into two or four resizable panes so you can view widely separated parts of a worksheet at the same time.