LearnKey: IC3 GS5 Key Applications Glossary

STUDY
PLAY

Terms in this set (...)

AVERAGE
A function that averages the numbers in a range.
Active Cell
The active cell is the cell that is currently highlighted (chosen) and ready to receive or manipulate data.
Bar Chart
A graphical representation of data where the information runs left to right. Bar charts show progression, trend, and comparison of different series.
Boolean Operators
Simple words such as AND, OR, or NOT which are used in formulas to sort or filter data.
COUNT
A function that counts the entries in a range but does not total the entries.
Cells
The single rectangular box which text or data can be inserted into. Cells are the intersecting points of a column and a row.
Column Chart
A graphical representation of data where the information runs up and down. Column charts show quantity, volume, and comparison of different series.
Columns
A series of cells which run vertically from top to bottom of a spreadsheet. Columns are identified by a letter in the column header.
Copy
An action in word processing, spreadsheet, or presentation programs which allows a user to duplicate text and place the information on the Clipboard.
Cut
An action in word processing, spreadsheet, or presentation programs which allows a user to remove data from one area and place it on the Clipboard for use later.
Database
A collection of data organized into tables which may be used to keep track of information in an easy-to-reference format.
Export
The act of sending or transferring a saved database to another application.
Field
An area used to separate different groups of data which will be stored in a database. The field is what keeps track of one specific portion of the table, similar to a column or row in a spreadsheet.
Filter
A selection criteria for the retrieval and display of records in the database where only those data records are shown in a card file window which comply with the chosen filter criteria.
Find and Replace
A function which allows users to locate and edit specific instances of text without having to conduct a manual search.
Font
A type set which has a particular face and size.
Footer
The bottom portion of a document which may contain information such as title, author, page number, or file name.
Forms
An object which is used to enter, display, or edit data in fields. Forms are not responsible for storing or structuring information, but they do make data entry very simple.
Formula
A set of mathematical instructions that adds, subtracts, multiplies, or divides the entered data.
GIF
Graphics Interchange Format (GIF) is a bitmap file format used by the World Wide Web. Limited to 256 colors, it is more effective for images such as illustrations rather than color photographs.
Groups
1. A collection of data or objects that can be moved or altered as a whole. 2. Collecting and transforming a collection of data or objects into one group.
Header
The uppermost portion of a document which may contain information such as title, author, page number, or file name.
Import
The act of transferring data from one software application into another application.
Landscape
An option that allows a worksheet to be printed horizontally.
Line Chart
A graphical representation of data showing progression and trend of the selected data.
MAX
A function that finds the highest value contained in a range.
MIN
A function that finds the lowest value contained in a range.
Merge
An option which combines two or more cells.
Metadata
Information which describes other data. Metadata can really be any descriptive information about the data. It may refer to the origin.
PDF
Portable Document File (PDF) is a file format designed by Adobe to enable the printing and viewing of documents. Any formatting used in the document will appear the same regardless of which operating system is used.
Pie Chart
A graphical representation of data showing parts of a whole and percentages. A pie chart shows only one series of data.
Plain Text
A text format which is not written in code or specially formatted.
Presentation
A software application which is used to create a series of slides which can contain text, graphics, audio files, or video. The presentation can be used for a public presentation.
Print
The act of printing on paper a document from word processing, spreadsheet, or presentation programs.
Query
An Access 2013 function which allows a user to ask questions of the data tables and display selected information based on the question.
Range
A selected group or block of cells. The set of values that a given function can take as its argument varies.
Read-Only View
A view in word processing, spreadsheet, or presentation programs which allows a user to view the document but no changes can be made.
Redo
An action in word processing, spreadsheet, or presentation programs which allows a user to duplicate the last action taken.
Ribbon
A newer feature of the Microsoft Office program interfaces, located just below the title bar, that replaces menus and toolbars.
Rows
A series of cells which run horizontally from left to right on a spreadsheet. Rows are identified by numbers.
Ruler
An on-screen measurement scale. A ruler may be marked with inches or other units of measure and can be used to measure lengths, widths, and tab settings.
SUM
A function that adds numbers in a selected range.
Slide
A single page of a presentation.
Sort
A process used in a spreadsheet or database to get information arranged systematically in groups.
Spell Checker
An action in word processing, spreadsheets, and presentations used to check the spelling of data. Also commonly called Spelling Checker, or just Spell Check.
Spreadsheet
A software application which arranges data in rows and columns. Data can be manipulated and used to make calculations.
Syntax
A set of rules which is used for analysis.
Table
A table is very similar to a spreadsheet. It is an object which organizes data in rows and columns.
Templates
A set of predesigned formats and layouts applied to a document for a specific purpose.
Undo
An action in word processing, spreadsheet, or presentation programs which allows a user to cancel out actions taken.
Word Processor
A software application used to format, store, and manipulate text.
Workbook
A spreadsheet file which contains worksheets.
Worksheet
A single page in a spreadsheet program such as Excel.
Wrap Text
A text feature that continues text to a new line when a line is full, so each line fits within the viewable window.
XY Scatter Chart
A graphical representation of data showing the values of data in the X-Axis and values of data in the Y-Axis.
Zoom
A tool which allows the user to view close-up details of a document.
YOU MIGHT ALSO LIKE...
STUDY GUIDE