Create an account
a number at the far-left side of a row that can be clicked to select the entire row of cells
the small black square in the lower right corner of a selected cell, lets you copy cell contents or continue a series of data into a range of selected cells
generates and extends a series of values into adjacent cells based on hte value of other cells
point and click method
Allows you to point and click each cell in a formula rather than typing cell references
a procedure that determines which digit at the right of the number will be the last digit displayed and then increases it by one if the next to its right is 5-9
relative cell reference
a cell reference based on the relative position of the cell that contains the formula and the cells refered to
a defined set of formatting characteristics, such as font, font size, font color, cell borders and cell shading
Accounting number format
applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis when negative numbers are present
ways you can display data in a way that is meaningful to the reader; e.g. column charts, pie charts, and line charts
labels that display along the bottom of the chart to identify the category of data; category axis or the x-axis
on the left of the chart, excel includes a numerical scale on which the charted data is based; y-axis
on the right, identifies the tterns or colors that are assigned to the categories in the chart
a column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point
a combination of chart elements, which can include a title, legend, labels for the columns, and the table of charted cells
the overall visual look of the chart in terms of its colors, backgrounds and graphic effects such as flat or beveled columns
maximizes the number of cells visible on your screen and keeps the column letters and row numbers closer
shrinks the width (or height) of the printed worksheet to fit a maximum number of pages, and is convient for printing formulas
the referenced cells are displayed in color and bordered with the same color; useful for verifying formulas because it visually indicates which workbook cells are included in a formula calculation
a function that automatically adds the values in the cells directly above or to the left of the active cell
symbols with which you can specify the type of calculation you want to perform in a formula
sheet tab scrolling buttons
display sheet tabs that are not in view when there are numerous sheet tabs
displays the current cell mode, page number, worksheet information, view and zoom buttons, and for numerical data, common calculations such as Sum and Average
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