The cell in the worksheet in which you can type data. (EX 6)
The worksheet that is displayed in the work area. (EX 10)
All cells touch each other and form a rectangle. (EX 10)
The intersection of a row and a column. (EX 6)
Identifies the cell, and is formed by combining the cell’s column letter and row number. (EX 6)
Appears vertically and is identified by letters at the top of the worksheet window. (EX 6)
An equation that calculates a new value from values currently in a worksheet. (EX 6)
Appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value. (EX 6)
A page turned so that its longer side is at top. (EX 18)
The spreadsheet program in Microsoft Office 2010. (EX 4)
Cell reference area located below the Ribbon, displays the cell reference of the active cell. (EX 6)
Includes two or more adjacent ranges and selected cells. (EX 11)
A page turned so that its shorter side is at top. (EX 18)
A group of selected cells. (EX 10)
How the range is identified; made up of the cell in its upper-left corner and the cell in its lower-left corner, separated by a colon. (EX 10)
Appears horizontally and is identified by numbers on the left side of the worksheet window. (EX 6)
Tab at the bottom of the worksheet window that displays the name of the worksheet. (EX 6)
A grid of rows and columns in which you enter text, numbers, and the results of calculations. (EX 4)
The file used to store worksheets. (EX 4)
A computerized spreadsheet. (EX 4)
A cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell.
Cells that run from top to bottom in a worksheet and are identified by letters.
Task-specific groups divided among the command tabs appropriate to the work a user currently performs.
A view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files.
Task-oriented tabs that are organized on the ribbon.
An arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.
In Office 2013, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
A system in Excel that is rich in information, illustrations, and tips that can help you complete any task as you create worksheets and workbooks.
Small “badges” displaying keyboard shortcuts for specific tabs and commands on the ribbon and Quick Access Toolbar. Also referred to as hotkeys.
Located 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.
A toolbar that gives you fast and easy access to the tools you use most often in Excel.
A 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.
A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
A collection of worksheets in a single file.
A 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.
Both letter of the Column and Number of row
The cells All going vertically
Solid Square in the lower right corner of a selected cell
Displays active cells Contents
All the cells going Horizontally
Refers to the Row or column the information was copied to
Used to Display a worksheet
An application used to store and analyze data
Selection of two or more cells
An Excel File
Doesn't change when copied because there is a dollar sign in front of the information
Performs a Calculation that results in a single value
Function that calculates the periodic payment for an installment loan
Function that adds the values in a range of cells then divides the result by the number of cells in the range
Function that adds the values in a range of cells
Used to Make two Different cells into one.
A function that automatically identifies and adds ranges of cells in your worksheet
The name of the cell is determined by the name of the row and the column intersecting, such as A8
When you move the mouse while holding down the mouse button (usually the left) to select a range cells
The identifying name that reflects the information contained in a column or row in a worksheet, such as name or date
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet
The rectangular shaped area on a worksheet that is created by the intersection of columns and rows
A drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet
In a worksheet, the vertical spaces with headings A,B,C and so on
The identifying letters and numbers for columns and rows. Columns are identified with letters, rows with numbers.
Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so.
An Excel file that contains individual worksheets. Also called spreadsheet file.
gives you fast and easy access to the tools you use most often in
small badges displaying keyboard shortcuts for specific tabs and commands
shows you behind-the-scenes options to manage files such as opening, saving,
takes you to Backstage view, with its navigation
indicates the current cell you are in as well it gives you the opportunity to name the cell or range
in Excel 2013 is rich in information, illustrations, and tips that can help
takes the information from one location
puts information into another location
options that automatically fill cells with data and/or formatting
is a group of adjacent cells that you select to perform operations on all of the selected cells
are a series of settings that allow you to change how a
commands on the default ribbon tabs are related in functionality
files that already include formatting and formulas complete with designs, tools, and specific data types
this can be a number, a cell address, a date, text, or Boolean data, but is usually a number or cell address in terms of formulas
identifies a cell’s location in the worksheet, based on its column letter and row number
adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell
refers to a specific cell or range of cells regardless of where the formula is located in the worksheet
a cell reference that uses an absolute column or row reference, but not both
is a group of cells, and occasionally a single cell, with a designated name
its used to edit information in a worksheet, you can make changes directly in the cell or edit the contents of a cell in the...
you highlight the text that is to be changed
are used to identify numeric data and are the most common type of text entered in a worksheet
feature works only for entries that contain text or a combination of text and numbers
is a small green square in the lower-right corner of a selected cell or range of cells
The intersection of a column and a row in a table or worksheet.
The cell in the worksheet in which you can type.
A vertical stack of cells in a table or worksheet.
An equation that calculates a new value from values currently in a worksheet.
Microsoft Word 2007
The horizontal placement of cells in a table or worksheet.
A computerized spreadsheet.
Text stored in a cell that cannot be used in calculations
A intersection between a row and a column on a spreadsheet that starts with A1.
Is a toolbar at the top of Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts,
A name that represents a cell, range of cells, formula, or constant value.
A range or data that is brought into a worksheet but that originates outside Excel such in a database or text file.
horizontal reference in a spreadsheet; identified by a number
a formula that automatically adds up a column of number
intersection of column and row
a group of cells
program used to perform calculations and present data
many worksheet in a spreadsheet
horizontal and vertical lines in a spreadsheet ( 2 words)
identified by letters that appear at the top of the spreadsheet (vertical)
a tab that identifies a worksheet (2 words)
to join one or more to become one cell
drag a formula down or across to other cells
Tools used for excel that displays across the top of the window.
Starts at the top of the worksheet and goes to the bottom of the worksheet. (A, B ,C)
A column on the worksheet.
Where you enter information.
Commands on the default ribbon tab, and adds commands within a group.
Make changes directly in the cell.
A cell in excel spreadsheet that is currently selected by clicking mouse pointer or keyboard keys.
Where you can manage your files.
Consists of a column indicator and a row number.
to keep and store files for future use.
A spreadsheet program included in Microsoft office.
run vertically in the worksheet and are identified by letters at the top of the worksheet
the way the page is turned - either portrait or landscape
a group of cells
the intersection of row and a column
Microsoft Office Spreadsheet Program
specifics where data is lined up within a cell
is the cell in the worksheet in which you can type or edit data
combines multiple cells into one cell
displays the cell reference of the active cell
a graphical representation of data
a collection of worksheets
every function begins with this sign
New document. Like a notebook, contains sheets on which data is entered.
allows you to enter, calculate, manipulate, and analyze data such as numbers and text inside a workbook.
pictorially represent data.
is drawn on the same worksheet as the data
cell in which data is currently being entered; has a heavy border and is in the Name box.
identified by column letter then row number (A1, A2, B2, C1, etc.)
displays active cell; located immediately above column A. Used to select a cell
displays data being entered in a cell
a box that is made when each column and row meets.
horizontal, identified with numbers
vertical, identified by letters
a feature of Excel which allows you to change several characteristics of a cell, such as font type, font size, & font color, all at once.
The number format that causes the cells to display with two decimal places.
horizontal and vertical lines
bottom right corner of a cell, allows you to copy formulas or cell contents
a series of two or more adjacent cells in a column, row, or rectangle.
Starts every formula.
A prewritten formula (Average, Sum, etc.
the values you use with a function
displays the highest value in a range
displays the lowest value in a range
a number, such as a whole number, a fraction, or a decimal
displays the formulas instead of values. Pres ctrl~ to display.
a predefined set of colors, fonts, chart styles, cell styles and fill effects
displays the worksheet as it will appear when printed.
The worksheet that is displayed in the work area
A page turned so that its shorter side is at the top
The intersection of a row and a column
The file used to store worksheets
A grid of rows and columns in which you enter text, numbers, and the results of calculations
Tab at the bottom of the worksheet window that displays the name of the worksheet
All cells touch each other and form a rectangle
Identifies the cell, and is formed by combining the cell's column letter and row number
Appears vertically and is identified by letters at the top of the worksheet window
The cell in the worksheet in which you can type data
A page turned so that its longer side is at the top
The spreadsheet program in Microsoft Office 2016
An equation that calculates a new value from values currently in a worksheet
Appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value
A group of selected cells
A computerized spreadsheet
Appears horizontally and is identified by numbers on the left side of the worksheet window
Includes 2 or more adjacent ranges and selected cells
Cell reference area located below the Ribbon; displays the cell reference of the active cell