COMP 242 Excel Chapter 5

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

And operator

The operator that requires each and every one of the comparison criteria that you specify must be true

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.

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.

Arrange all

The command that tiles all open program windows on the screen.

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.

PDF

The file type developed by Adobe Systems that is a visual representation of a document

Criteria

The term used for conditions that you specify that must be matched for the record to be included in the search results.

Find

The command to find and select specific text, formatting, or type of information within a workbook quickly

XPS

The file type developed by Microsoft 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.

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

Additive

The term that describes filtering actions in which each additional filter that you apply is based on the current filter

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.

Field

A single piece of information that is stored in every record.

Query

The term that refers to asking a question of the data in a database.

Sort

To organize data in a particular order

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.

Descending order

Numbers sorted from highest to lowest

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.


संबंधित स्टडी सेट्स

Chapter 8 The cardiovascular system

View Set

Requirement That No Defense Exist

View Set

Chapter 43: Nursing Care of the Child With an Alteration in Urinary Elimination/Genitourinary Disorder

View Set

Chapter 5 - Membranes and Transport

View Set

Women's health/Disorders & Childbearing

View Set

Algebra (8th Grade) - Proportional Relationships -

View Set