Java Games: Flashcards, matching, concentration, and word search.

Excel Lessons 1-5 Key Vocabulary Review

absolute cell referenceA reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. Uses a dollar sign in front of the column and row markers in a cell address.
active cellA cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell.
alignArrange in a line or bring into alignment.
attributeA formatting characteristic, such as bold, italic, or underlined text.
Auto FillAn Excel feature that automatically fill cells with data, formatting, or both.
AutoCompleteAn Excel feature that automatically enters the remaining characters of an entry when the first few typed characters match an entry made previously.
AVERAGE functionA function that calculates the arithmetic mean of the specified cell range.
Backstage viewA view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files.
calculation operatorOperators that specify the calculations to be performed.
cellA box on the grid identified by the intersection of a column and a row.
cell referenceA reference that identifies a cell’s location in the worksheet based on its row number and column letter.
columnCells that run from top to bottom in a worksheet and are identified by letters.
column headingThe identifying letter of a column.
column widthThe left-to-right measurement of a column.
command groupTask-specific groups divided among the command tabs appropriate to the work a user currently performs.
command tabsTask-oriented tabs that are organized on the ribbon.
constantA number or text value entered directly into a formula.
copyTo duplicate data from a worksheet to the Clipboard.
copy pointerA mouse pointer, resembling an arrow with a plus sign, that allows users to drag a cell or range of cells to a new location.
CutTo remove data from a worksheet. Cut data may be pasted into a new location or locations in a worksheet.
default settingsPre-set settings that determine how Excel behaves when performing an action.
Dialog Box LauncherAn arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.
external referenceA cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
FILE tabIn Office 2013, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
fill handleA small square in the lower, right corner of a selected cell or range of cells. Used mainly to copy data to adjacent cells.
Flash FillA new feature in Excel that is similar to AutoFill. When Excel recognizes a pattern based on other information in your workbook, it uses the pattern to enter data into several cells at once.
fontA set of text properties that affects the typeface, size, and similar aspects of text.
footerLines of text that appear at the bottom of each page.
FormulaAn equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a
formula barA bar located between the ribbon and the worksheet in which users can edit the contents of a cell.
freezeTo prevent portions of a worksheet from moving on the screen. When you freeze panes, such as a row of column headings, the column headings remain visible as you scroll down the worksheet or change magnification.
functionA predefined formula that performs a calculation.
groupCommands on the default ribbon tabs that are related in functionality.
groupingOrganizing data so it can be viewed as a collapsible and expandable outline.
handleA small box on the side and/or corner of the graphic that you click and pull to increase or decrease the size of a graphic.
headerA line of text that appears at the top of each page of a printed worksheet.
Help systemA system in Excel that is rich in information, illustrations, and tips that can help you complete any task as you create worksheets and workbooks.
hotkeyAnother name for KeyTip.
KeyTipSmall “badges” displaying keyboard shortcuts for specific tabs and commands on the ribbon and Quick Access Toolbar. Also referred to as hotkeys.
keywordA word assigned to a document’s properties that makes it easier to organize and find documents.
labelText entered in a worksheet that identifies numeric data and is the most common type of text entered in a worksheet. Labels are also used to sort and group data.
MAX functionA function that returns the largest value in a set of values.
MIN functionA function that determines the minimum value in a range of cells.
mixed cell referenceA cell reference that uses an absolute column or row reference, but not both.
move pointerA mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.
Name BoxLocated below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell.
named rangeA group of cells, and occasionally a single cell, with a designated name.
natural seriesA formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
navigation paneA pane found on the left side of Backstageview. It provides you access to workbook and file-related commands through a series of tabs.
operandAn element that identifies the values to be used in a calculation.
order of operationsThe rules Excel follows to calculate any formula that contains two or more operators.
orientationThe position of the content in a worksheet, so that it prints either vertically or horizontally on a page.
Page Break PreviewAn Excel view in which you can quickly adjust automatic page breaks to achieve a more desirable printed document.
pasteTo insert data from the Clipboard to a new location in a worksheet.
print optionsSeveral settings that enable you to change how a document prints.
Print PreviewAn Excel view that enables you to see what your document will look like before sending it to the printer.
Quick Access ToolbarA toolbar that gives you fast and easy access to the tools you use most often in Excel.
rangeA group of adjacent cells you select to perform operations on all of the selected cells.
relative cell referenceA cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
ribbonA broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface. The ribbon was introduced in Office 2007.
rowA line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
row headingThe identifying letter of a row.
row heightThe top-to-bottom measurement of a row.
ScreenTipA small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
selecting textHighlighting text that is to be changed.
SUM functionA function that totals all of the cells in a range.
tabAn area on the ribbon that contains groups of related commands. See command tab. Or an area of the Backstage navigation pane that contains groups of related commands.
templateA file that includes formatting and formulas complete with designs, tools, and specific data types.
valueA number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
variableA symbol or name that represents something else; it can be a cell address, a range of cells, and so on.
workbookA collection of worksheets in a single file.
workbook propertiesItems you directly change, such as keywords.
worksheetA page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations.
wrapTo automatically display data on the next line when it is too long to display within the cell’s width. Wrapping automatically increases a cell’s height.

CTE Business Education Teacher
Kingswood School
Winston-Salem , NC

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities