## xl 2

##### Created by:

rayalextrujillo  on January 7, 2011

Pop out
No Messages

# xl 2

 Accounting Number Formatdisplays numbers with a dolla sign to the left of the number, inserts a comma every three positions to the left of the decimal point, an displays numbers to the nearest cent (hundredths place)
1/36
Preview our new flashcards mode!

Order by

#### Definitions

Accounting Number Format displays numbers with a dolla sign to the left of the number, inserts a comma every three positions to the left of the decimal point, an displays numbers to the nearest cent (hundredths place)
arguments the information necessary to calculate the answer
asterisk a star-shaped character * used in printing
AVERAGE function \ example: =Average(C4:C18) determines the average of the range of cells from C4 through C18
best fit means that the width of the column will be increased or decreased so the widest entry will fit in the column
blank cell a numerical value of zero
Comma style format can be assigned to a range of cells by clicking the Comma style button on the Ribbon, inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths
condition the procedure that is varied in order to estimate a variable's effect by comparison with a control condition
conditional formatting Highlights worksheet data by changing the look of cells that meet a specified condition (EX 136).
debugging fixing errors
e-mail (computer science) a system of world-wide electronic communication in which a computer user can compose a message at one terminal that is generated at the recipient's terminal when he logs in
equal sign a symbol that shows two amounts have the same value
fixed dollar sign places a dollar sign to the left of the cell leaving spaces between it and the cell numbers
floating dollar sign appears immediately to the left of the first digit with no spaces, use the Currency Style in the Format Cell dialog box
formula An equation that calculates a new value from values currently in a worksheet
formulas version shows the actual formulas you have entered, rather than the resulting values
function a set sequence of steps, part of larger computer program
hiding cells allows you to hide data in cells
landscape orientation page orientation in which data prints across the wider portion of the page
MAX function displays the highest (maximum) value in a range
MIN function determines the lowest (minimum) number in the range
Normal View the default view in a presentation, which contains the slide pane, the outline pane, the task pane, and the notes pane
Order of operations moving from left to right in a formula
Page Layout View View that displays the worksheet as a printed page.
pixel a dot on the screen that contains a color
Point mode *, allows you to select cells for use in a formula by using the mouse
portrait orientation Printout ,of a page,is printed across the width of a page
previewing the worksheet you can see exactly how it will look without generating a printout
Range Finder checks which cells are referenced in the formula assigned to the active cell
relative cell references is copied and pasted to other cells, the cell references in the formula or function change to reflect the function's new location.
smart tag indicator a small purple triangle in a cell that indicates that a smart tag is available
smart tags identifies certain actions to take on specitic data in workbooks
spell checker Checks for spelling errors
theme A predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook
values version shows the results of the formulas you have entered, rather than the actual formulas
Web query used to import data stored on a web site

### First Time Here?

Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.

### Set Champions

##### Scatter Champion

54.3 secs by Neal23