Appears directly below the toolbar in the worksheet; displays a formula when the cell of a worksheet contains a calculated value.
displays information about the current document
displays the active cell address
an excel file with one or more worksheets
the workspace made up of columns and rows where you enter data to create an electronic spreadsheet
The intersection of a row and a column
the background of the cell
color that the text appears in in a cell
a line that indicates a boundary of a cell or range
appears vertically in a worksheet and is identified by letters at the top of the worksheet window
a column letter above the grid that identifies each column
appears horizontally in a worksheet and is identified by numbers on the left side of the worksheet window
a number at the far-left side of a row that can be clicked to select the entire row of cells
ability to use name box to name a range of cells/cell
what is typed into a cell-contained with in
Allows someone to change a cell's appearance; alignment, font, border, patterns, etc. as well as its numerical type; number, text, currency, percentage, etc.
Takes two or more cells and combines them into one.
Placing a new, blank row or column in the spreadsheet.
the position in which text is placed within a cell
a predictable list of sequential numbers, dates, times, or text
this is the name of the small black square that displays in the bottom right corner of the active cell
thick white cross
used to place a selection in a new location
a function that automatically adds selected cells
a condition that data must meet to be included in a selection - a way of limiting data in a list
To arrange data in alphabetical or numerical order.
The column letter and the row number. Example: B12
An adjustable/changeable cell reference
cell refernence that points to a specific cell and does not change when copied ($B$4)
A toolbar button that displays functions by category that will assist you in writing the formula.
a graphic representation of values used to identify trends and contrasts in data
A visual representation of data to help readers better understand relationships among data
allows the user to select specific rows or columns that remain visible when scrolling in the worksheet
Page Break Preview
displays the location of the different page breaks within the worksheet
describes the direction of the page or the paper you will print on (landscape or portrait)
Taking the content from one sheet and pasting it to multiple sheets at one time.
Statements in a formula that can be evaluated as true or false, and then return an appropriate value if true, and another value if false.
Parameters added to a function that help in evaluating data, or performing calculations
Highlighted worksheet cell that is ready for data entry
change the size of
to choose or highlight a row, column, cell or range
Unhide Row Tool
Highlight an entire row
Highlight an entire column
Allows you to shrink the function dialogue box in order to choose cells for your function.
Allows you to expand the function dialogue box in order to adjust the arguments in your function.
Upgrade to remove ads