Advertisement Upgrade to remove ads

Application Software

computer software created to allow the user to perform specific a job or task

Central Processing Unit

executes commands from a computer's hardware and software; the principal computer chip that contains several
processing components, which determines the computer's operating speed; the "brain" of a computer

File Management System

A program on a computer that allows the user to create, edit, view, print, rename, copy, or delete files, folders, or an entire file system

File Type

an extension at the end of a file name, indicating which application was used to create a document

Input Device

data entered into the computer through a variety of devices such as a keyboard, microphone, scanner, flash drive, or mouse

Logon

the action of gaining access to a computer or a network by entering a username and password; also called Login/Sign In

Memory

computer chips that store data and programs while the computer is working; often called RAM or Random Access Memory

Operating System

software that acts as a "go-between", allowing computer hardware and other software to communicate with each other

Output Device

allows the user to view or listen to the data a computer processes such as a monitor, printer, headphones, or speakers

Peripheral

additional hardware that isn't necessary for a computer to function, but does enhance how the computer can be used

Save

storing data for later use

Save As

a feature that allows the user to change the attributes of a file (such as location, file name, or file type) before saving it

Storage Device

external hardware used to store and retrieve data, such as a disk drive, CD/DVD drive, flash drive, or tape drive

System Software

software responsible for the general operation of a computer system, including the operation of hardware, running application
software, and file management

System Unit

a computer case that contains the CPU, power supply, memory, and storage

Destination File

the file that an object is embedded in or linked to

Embedded File

a file that becomes part of the current file but is a separate object that can be edited using the application that created it

Integration

the sharing or combining of data between applications

Linking

placing a copy of an object or data in a destination file that will update when changes are made to the source file

Merge

a feature that combines a data document with a main document to mass produce personalized letters or other documents
Unit

Ascending

sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest

Database

a collection of organized data that allows access, retrieval, and use of data

Data Type

indicates the type of data that can be stored in a field

Descending

sort order arranging text or numbres from Z to A, from largest to smallest, or from latest to earliest

Field

a single characteristic of data that appears in a table as a column

Field Name

a name that identifies a field

Form

a database view that allows the user to see all fields for one record and enter them one at a time

Primary Key

a field that uniquely identifies a record in a table

Query

a question presented in a way that allows the database to process and generate specific data from one or more tables

Record

a collection of fields that appear as a row in a database or table

Report

a document that uses data from tables and/or queries, the user controls which items in the database will appear in the report and how it is filtered or sorted

Sort

to arrange a list of words or numbers in ascending or descending oreder

Table

a database view of information arranged in a grid of rows and columns

Alignment

how the edges of a line, paragraph, object, or table are positioned horizontally and vertically between the margins or on a page

Ascending

sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest

Automatic Page Break

a feature that automatically generates a new page, allowing text to flow to the new page when space runs out on the
previous one; also known as a Soft Page Break

Borders

lines around the edge(s) of text, a page, a cell, or a table

Bullets and Numbering

a feature in a word processing application that allows the user to create outlines or itemized lists with either icons or
numbers

Clip Art

a feature that includes pre-made illustrations, drawings, pictures, and other graphic that can be inserted into a document

Column

one of two or more vertical sections of printed material on a page; usually separated by margins

Copy and Paste

a feature that allows a user to select text or a graphic, duplicate it and place it in another location within a document

Cut and Paste

a feature that allows a user to select text or a graphic, remove it from its current location and place it in another location within a
document

Descending

sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliest

Desktop Publishing

through the use of a personal computer, combining text and graphics to produce a high-quality documents, such as newsletters,
flyers, brochures, etc.

Drag and Drop

a feature that allows a user to select text using a mouse or pointing device, and quickly move (drag) it to a different location

Edit

to make changes by adding, deleting, or modifying text, graphics, or other items in a document

Find and Replace

a feature that scans a document, searches for occurrences of specific text, symbols or formatting, and allows a user to replace it
with new text, symbols or formatting

Font

the size, style, and design of text

Footer

text appearing at the bottom of each page, separate from the main body of a text

Format

in word processing, to utilize features that enhance the appearance and overall layout of text, graphics, tables within a document

Graphics

drawings, pictures, or other illustrations inserted in a document to either explain data or enhance the appearance of text on a page

Hard Return

a break in a line or a paragraph that is forced by the user when the return key is pressed, creating a new paragraph

Header

text appearing at the top of each page, separate from the main body of text

Indent

to move text horizontally away from the left or right margin, setting it apart from surrounding text

Landscape Orientation

a page layout in which documents are printed across the length of a page, making the page wider than it is tall

Line Spacing

the amount of space between lines of text

Manual Page Break

page break the end user forces into a document, creating a new page at a specific location; also known as a Hard Page Break

Margins

the white space surrounding the content of a page at the top, bottom, left and right sides, defining where a line of text begins and ends

Print Preview

a feature that allows the user to view a document onscreen and make necessary formatting changes prior to printing it

Point Size

the measurement, or size of a font (text); each point is approximately 1/72 of an inch

Portrait Orientation

a page layout in which documents are printed across the width of a page, making the page taller than it is wide

Shading/Fill

the background color of a cell, table, or page

Sort

to arrange a list alphabetically (text) or numerically (numbers), in ascending or descending order

Spell Check

a feature used to automatically locate and correct spelling errors

Tab Stop

a formatting feature that allows the user to control where a line of text will be entered and how the text will be aligned; so that when the tab
key is pressed, the insertion point will move to that location

Table

a set of data arranged in a grid of rows and columns

Template

a feature that includes pre-made documents that allow the user to fill-in-the blanks to create new documents, such as calendars, invoices,
reports, resumes, etc.; enhances user's efficiency and creativit

Thesaurus

a feature that allows the user to view synonyms and antonyms, and automatically replace words for enhanced writing

View

a feature that allows the user to view the current page of a document onscreen in a different ways

Word Processing

the use of software application to create, edit, format, print and save text-based documents, such as letters, reports, and memos

Word Wrap

also called a soft return; a feature that automatically moves text to the next line when the previous line is full without the user pressing
the enter key

Word Art

text created as a graphic image

Wrap Text

a feature that allows text to be included with pictures, shapes, or tables without covering or hiding under the image, giving the user control over how the text is position

Electronic Mail

transmission of messages and files using a computer network

Fax

a document generated by using a facsimile machine

Internet

a vast network of computers linked to one another

Intranet

a company's private network of computers

Local Area Network

a computer network that covers a small area

Network

computers that are connected to each other

Online

computers that are connected and ready to receive and/or transmit data

Protocol

the rules that must be observed for two electronic devices to communicate with each other

Stand alone

a computer that is not connected to a network

Telecommunications

transmitting information and communicating electronically

Uniform Resource Locator

Internet address that identifies hypertext documents

World Wide Web

a system of computers that share information by means of links on web pages

Presentation

An application that allows the user to create and save slides to use as a slide show

Normal View

The default view in a presentation, which contains the slide pane, the outline pane, the task pane, and the notes pane

Slide Sorter View

A view that displays all slides simultaneously in miniature form

Outline View

A view that displays text in an outline format

Slide Show View

Runs slides as they will appear during a presentation

Transition

A feature that can be applied in presentations to control the way slides move on and off the screen

Animation

The way text and objects move on and off a slide during a slide show

Graphic

An image or object created or inserted into a document that illustrates the text or makes the page more attractive

Design Template/Theme

Prepared designs that can be applied to presentation slides that include patterns, formatting, and color schemes

Placeholder

A boxed outline on a slide that can be used to insert text or an object when clicked

Slide Layout

The arrangement of placeholders on a slide

Handouts

A print option that allows you to choose the number of slides displayed per page and places a thumbnail, or small picture, of each slide on the page

Notes Page

Printouts that contain the slide image in the top half of the page and the speaker's notes in the lower half of the page

Absolute cell reference

cell reference that does not adjust to the new cell location when copied or moved

Active cell

a selected worksheet cell that is ready for data entry

Alignment

the position of data within a cell

Argument

value, cell reference, range, or text that acts as an operand in a function formula

Ascending

sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest

Autosum

a function that automatically adds the values in the cells directly above or to the left of the active cell

AVERAGE

returns the average (arithmetic means) of its arguments

Cell

the space formed by the intersection of a row and a column; the basic unit of a worksheet

Cell reference

a unique identifier for a cell which is formed by combining the cell's column letter and row number

Chart/graph

a graphic representation of values and their relationships: pie, line, column, bar, scattered

Column

vertical group of cells in a worksheet identified by letters

Column Chart

a chart that uses bars of varying height to illustrate values in a worksheet

COUNT

returns the number of cells in a range that contains numbers

Descending

sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliest

Fill

to copy a cell's contents and/or formatting into an adjacent cell or range

Format

arranging the shape, size, type, and general makeup of a cell or group of cells

Formula

an equation that calculates a new value using values currently on a worksheet

Freeze

keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls

Function

a prewritten formula that makes it easy to perform common calculations

Label

alphanumeric text that will not be used in calculations

Line Chart

a chart that uses points connected by a line to illustrate values in a worksheet

MAX

returns the largest value in a set of values

MIN

returns the smallest value in a set of values

Mixed cell reference

a cell reference that contains both relative and absolute references

Operand

a number or cell reference used in a formula

Operator

a symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/)

Order of Operation

the mathematical rules used for calculating the value of a formula

Pie Chart

a chart that shows the relationship of a part to a whole

Range

selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon

Relative Cell reference

cell reference that adjusts to a new location when copied or moved

Row

a horizontal group of cells in a worksheet identified by numbers

Sort

to arrange a list of words or numbers in ascending or descending order

Spreadsheet

a grid of rows and columns containing numbers, text, and formulas used to perform calculations

SUM

adds all the numbers in a range of cells

Value

numeric characters that can be used in a calculation

What-if analysis

process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet

Workbook

a collection of related worksheets

Worksheet

the workspace made up of columns and rows where data is entered to create an electronic spreadsheet

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set