The active cell is the cell that is currently highlighted (chosen) and ready to receive or manipulate data.
A graphical representation of data where the information runs left to right. Bar charts show progression, trend, and comparison of different series.
Simple words such as AND, OR, or NOT which are used in formulas to sort or filter data.
A function that counts the entries in a range but does not total the entries.
The single rectangular box which text or data can be inserted into. Cells are the intersecting points of a column and a row.
A graphical representation of data where the information runs up and down. Column charts show quantity, volume, and comparison of different series.
A series of cells which run vertically from top to bottom of a spreadsheet. Columns are identified by a letter in the column header.
An action in word processing, spreadsheet, or presentation programs which allows a user to duplicate text and place the information on the Clipboard.
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.
A collection of data organized into tables which may be used to keep track of information in an easy-to-reference format.
The act of sending or transferring a saved database to another application.
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.
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.
A type set which has a particular face and size.
The bottom portion of a document which may contain information such as title, author, page number, or file name.
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.
A set of mathematical instructions that adds, subtracts, multiplies, or divides the entered data.
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.
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.
The uppermost portion of a document which may contain information such as title, author, page number, or file name.
The act of transferring data from one software application into another application.
An option that allows a worksheet to be printed horizontally.
A graphical representation of data showing progression and trend of the selected data.
A function that finds the highest value contained in a range.
A function that finds the lowest value contained in a range.
An option which combines two or more cells.
Information which describes other data. Metadata can really be any descriptive information about the data. It may refer to the origin.
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.
A graphical representation of data showing parts of a whole and percentages. A pie chart shows only one series of data.
A text format which is not written in code or specially formatted.
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.
The act of printing on paper a document from word processing, spreadsheet, or presentation programs.
An Access 2013 function which allows a user to ask questions of the data tables and display selected information based on the question.
A selected group or block of cells. The set of values that a given function can take as its argument varies.
A view in word processing, spreadsheet, or presentation programs which allows a user to view the document but no changes can be made.
An action in word processing, spreadsheet, or presentation programs which allows a user to duplicate the last action taken.
A newer feature of the Microsoft Office program interfaces, located just below the title bar, that replaces menus and toolbars.
A series of cells which run horizontally from left to right on a spreadsheet. Rows are identified by numbers.
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.
A function that adds numbers in a selected range.
A single page of a presentation.
A process used in a spreadsheet or database to get information arranged systematically in groups.
An action in word processing, spreadsheets, and presentations used to check the spelling of data. Also commonly called Spelling Checker, or just Spell Check.
A software application which arranges data in rows and columns. Data can be manipulated and used to make calculations.
A set of rules which is used for analysis.
A table is very similar to a spreadsheet. It is an object which organizes data in rows and columns.
A set of predesigned formats and layouts applied to a document for a specific purpose.
An action in word processing, spreadsheet, or presentation programs which allows a user to cancel out actions taken.
A software application used to format, store, and manipulate text.
A spreadsheet file which contains worksheets.
A single page in a spreadsheet program such as Excel.
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.
A tool which allows the user to view close-up details of a document.