Excel chapter 5

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

record

All of the categories of data pertaining to one person, place, event, thing, or idea

PDF

The file type developed by adobe systems that is a visual representation of a document

The area where you place the results when copying the results of a filter to another location in the worksheet

Extract area

criteria

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

A predestined set of colors, fonts, lines and fill effects that look good together is a:

Theme

A single piece of information that is stored in every record

field

Auto Filter menu

A menu of filtering commands that displays when you click one of the filter arrows in an excel table

cell style

A set of formatting characteristics that you can apply to a cell.

The default file format for excel 2016

.xlsx

The command that locates and selects specific text, formatting or type of information within a workbook quickly.

Find

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

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

query

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

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

And comparison operator

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.

Database

An organized collection of facts related to a specific topic

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

A position of a worksheet sundown bounded by and separated from other portions by vertical or horizontal bars is a:

Pane

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.

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.

comparison operator

The equal sign, greater than, less than, used singly or in combination to compare two values

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.

extract

To pull out multiple sets of data for comparison purpose

Ascending

Values sorted from A to Z

Numbers sorted from the highest to lowest are sorted in

descending order


Kaugnay na mga set ng pag-aaral

Intermediate Accounting Part I Chapt 1

View Set

Financial 7 - Stockholder Equity

View Set

unit 4 Copy, Paste and Printing in Excel

View Set

Anthropology questions, chapter 2

View Set

ATI Cardiovascular, ATI Respiratory System, musculoskeletal pharm 4.0, The Neurological System (Part 1), ATI focused assessments and pharm

View Set

Last chapter: insurance regulation

View Set