My Lab IT CH. 5 Excel Homework
record
All of the categories of data pertaining to one person, place, event, thing, or idea
Database
An organized collection of facts related to a specific topic
The operator that requires each and every one of the comparison criteria that you specify must be true is the?
And comparison operator
The area where you place the results when copying the results of a filter to another location in the worksheet
Extract area
Find
The command to find and select specific text, formatting, or type of information within a workbook quickly
Freeze Panes
The command to set the column and row headings so that they remain on the screen while you scroll to other parts of the worksheet.
XPS
The file type developed by Microsoft that is a visual representation of a document
The file type developed by adobe systems that is a visual representation of a document
Tab delimited text file
The file type that saves an Excel file with tabs between each cell in a row and a paragraph return at the end of each row.
And operator
The operator that requires each and every one of the comparison criteria that you specify must be true
A single piece of information that is stored in every record
field
The page formatting that reduces the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify is?
Scaling
Arrange All
The command that tiles all open program windows on the screen.
criteria
The term used for conditions that you specify that must be matched for the record to be included in the search results
Arrange all
The command that tiles all open program windows on the screen.
comparison operator
The equal sign, greater than, less than, used singly or in combination to compare two values
The file type developed by Adobe Systems that is a visual representation of a document
Comma Separated Values (CSV)
The file type that saves an excel file so that there is a comma between each cell and a paragraph return at the end of the row.
Scaling
The page formatting that reduces the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify
Query
The term that refers to asking a question of the data in a database.
A predestined set of colors, fonts, lines and fill effects that look good together is a:
Theme
Criteria
The term used for conditions that you specify that must be matched for the record to be included in the search results.
CSV file (comma separated values)
The file type that saves an Excel file so that there is a comma between each cell and a paragraph return at the end of each row.
Ascending
Values sorted from A to Z
Auto Filter menu
A menu of filtering commands that displays when you click one of the filter arrows in an Excel table.
Auto Filter menu
A menu of filtering commands that displays when you click one of the filter arrows in an excel table
Pane
A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars
Theme
A pre-designed set of colors, fonts, lines, and fill effects that look good together
Cell styles
A set of formatting characteristics that you can apply to a cell.
cell style
A set of formatting characteristics that you can apply to a cell.
Field
A single piece of information that is stored in every record.
The default file format for excel 2016
.xlsx
Hyperlink
Colored and underlined text that, when clicked, games you to another location in the worksheet, to another file, to a webpage on the internet, or on your organizations intranet.
A sort order that you can define is a
Custom list
The command that locates and selects specific text, formatting or type of information within a workbook quickly.
Find
A position of a worksheet sundown bounded by and separated from other portions by vertical or horizontal bars is a:
Pane
To organize data in a particular order is to
Sort
The file type that saves an excel file with tabs between each cell in a row and paragraph retention at the end of each row.
Tab delimited text file
Comparison operator
The Equal sign (=), Greater Than sign (>), or Less Than sign (<) used singly or in combinations to compare two values.
Extract area
The area where you place the results when copying the results of a filter to another location in a worksheet.
Additive
The term that describes filtering actions in which each additional filter that you apply is based on the current filter
query
The term that refers to asking a question of the data in a data base
Wildcard
A character such as the asterisk (*) used to search a field when you are uncertain of the exact value or when you want to widen the search to include more records.
Record
All of the categories of data pertaining to one person, place, thing, event, or idea.
Database
An organized collection of facts related to a specific topic.
Hyperlink
Colored and underlined text that, when clicked, takes you to another location in the worksheet, to another file, to a Web page on the Internet, or on your organization's intranet.
Command used to move to a specific cell or range of cells in a large worksheet
Go to
A language web browser can interpret
HTML
A term sometimes used to refer to the first sort level in the sort dialog box
Major sort
Descending order
Numbers sorted from highest to lowest
Sort
To organize data in a particular order
extract
To pull out multiple sets of data for comparison purpose
Numbers sorted from the highest to lowest are sorted in
descending order
