Create an account
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
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together