Term
|
Definition
| a prewritten formula that is built into Excel. |
|
|
Term
|
Definition
as follows: first negation, then all percentages, then all exponentiations, then all multiplications and divisions, and finally, all additions and subtractions. |
|
|
Term
|
Definition
| allows you to select cells for use in a formula by using the mouse. |
|
|
Term
|
Definition
dates, financial symbols, people’s names, and more. |
|
|
Term
|
Definition
|
|
Term
|
Definition
the values you use with the function. |
|
|
Term
|
Definition
sum the numbers in the specified range and then divides the sum by the number of nonzero cells in the range. |
|
|
Term
|
Definition
| displays the highest value in a range. |
|
|
Term
|
Definition
| determines the lowest or the minium number in the range. |
|
|
Term
|
Definition
| a predefined set ofcolors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire worksheet. |
|
|
Term
|
Definition
adds a dollars sign to the left of the number, inserts a comma every three positions to the left of the decimal point, and displays the numbers to the nearest cent. |
|
|
Term
|
Definition
added to the far left in the cell, often with spaces in between it and the first digit. |
|
|
Term
|
Definition
appears immediately to the left of the first digit with no spaces, use the Currency Style in the Format Cells dialog box. |
|
|
Term
|
Definition
this 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. |
|
|
Term
|
Definition
| lets you apply formatting that appears only when the value jina cell meets the conditions that you specify. |
|
|
Term
|
Definition
1. is made up of two values and a relational operator, is true or false. 2. if the condition is true, then Excel applies the formatting. 3. if the condition is false, then Excel supesses the formatting. |
|
|
Term
|
Definition
| a dot on the screen that contains a color. |
|
|
Term
|
Definition
| the width of the colomn will be increased or decreased so the widest entry will fit in the column. |
|
|
Term
|
Definition
| you can use this to check the worksheet for spelling errors. |
|
|
Term
|
Definition
| allows you to create or modify a worksheet while viewing how it would look in a printed format. |
|
|
Term
|
Definition
| is the defut view that you have worked in |
|
|
Term
|
Definition
seeing exactly how it will look without generating a printout. |
|
|
Term
|
Definition
| shows the results of the formuals you have entered, rather than the actual formulas. |
|
|
Term
|
Definition
| shows the actual formulas you have entered, rather than the resulting values. |
|
|
Term
|
Definition
| the processs of finding and correcting errors in the worksheet. |
|
|
Term
|
Definition
| excel imports the external data in the form of a worksheet. |
|
|
Term
|
Definition
electronic transmission of messages and files to annd from other computers using the Internet. |
|
|
