the area for entering and calculating data made up of columns and rows separated by gridlines (light gray lines),); also called a spreadsheet
as you enter data into a cell, it simultaneously appears in the formula bar, which is located above the worksheet. Formula will still be visible in this after after formula results appear in the cell
the location of a cell in a worksheet as identified by its column letter and row number, also known as the cell address or cell name
text in the first row or column of a worksheet that identifies the type of data contained there
a list of sequential numbers, dates, times, or text that is generated when data is copied to adjacent cells
sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range
cross-shaped pointer that appears inside the outlined cell when the mouse is over the cell.
appears vertically in a worksheet and is identified by letters at the top of the worksheet window
Find and Replace
a feature that scans a document, searches for occurrences of specific text, symbols or formatting, and allows a user to replace it with new text, symbols or formatting
Predefined spreadsheet formulas built into the software that enable you to perform simple calculations, as well as, complex calculations easily.
The orientation of a page where the width is greater than the height; printing a document where it is wider than it is tall,.
symbols used in mathematical operations: + for addition, - for subtraction, * for multiplication, / for division, and ^ for exponentation
Refers to the position in which a page is arranged either vertically or horizontally
Relative Cell Reference
The ability of a spreadsheet to change a cell or range reference to automatically adjust to the new location in a worksheet when the formula is copied
In a spreadsheet the row is the horizontal group of cells. Rows are named with numbers, i.e. 1,2,3.
To arrange a list of data alphabetically (text) or numerically (numbers), in ascending or descending order
A computer application that produces worksheets arranged in columns and rows and performs mathematical calculations