18 terms

Excel Chapter 2

wrap text
display text on multiple lines within a cell
number format
a specific wat that excel displays numbers
general format
whatever you type in a cell will display except trailing zeros to the right of a decimal point
Office Themes
specify a combination of colors, fonts, and graphic effects that look good together
arithmetic operators
symbols with which you can specify the type of mathmatical operation you want to perform in a formula
Formula autoComplete
assist in inserting functions
point and click method
type formulas or construct them by pointing and clicking
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 both the right and left edges of the cell to accommodate parentheses for negative numbers.
Comma style
adds appropriate thousand comma separators and also applies the Accounting Number Format-two decimal places and space for parentheses in the event of a negative number-but without a dollar sign.
Absolute cell references
A cell reference that refers to cells by their fixed position in a worksheet, and that remains the same when the formula is copied.
range finder
outlines cells in color to indicate which cells are used in a formula; useful for verifying which cells are referenced in a formula or for quickly positioning the insertion point within the cell to perform editing directly in the cell
F4 shortcut
inserts dollar signs
Part of a whole expressed in hundredths. Photo album A presentation composed of pictures.
Percent style
A command that formats the selected cell as a percentage rounded to the nearest hundredth.
chart sheet
A workbook sheet that contains only a chart
Gross profit margin
In accounting, the sales revenue minus the cost of sales
Software from Microsoft that provides a website on which employees in an organization can upload and share information.
Office live workspace
Software from Microsoft that enables individuals to save and access Office documents on the Internet.