Term
|
Definition
| has no specific characteristics--what you type is what gets displayed, except there will be no trailing zeroes to the right of the decimal point |
|
|
Term
|
Definition
| what data displayed in a cell is referred to as |
|
|
Term
|
Definition
| What data displayed in the formula bar is referred to as |
|
|
Term
|
Definition
| The displayed value depends on the _____ of a column. |
|
|
Term
|
Definition
| procedure in which you determine which digit at the right of the number will be the last digit displayed and then increase it by one if the next digit to its right is 5 or greater. |
|
|
Term
|
Definition
| If a cell is too narrow to display all of the numbers, what will you see instead? |
|
|
Term
|
Definition
|
|
Term
|
Definition
| pre-written formula that takes one or more values, performs an operation, and then returns a value or values |
|
|
Term
|
Definition
| What do all formulas begin with? |
|
|
Term
|
Definition
| What should you always view to know the exact content of a cell? |
|
|
Term
|
Definition
| T or F: A displayed number may actually be a formula |
|
|
Term
|
Definition
| The keyboard shortcut for Sum |
|
|
Term
|
Definition
| an Excel function that is a prewritten formula for addition |
|
|
Term
|
Definition
| a cell reference base on the relative position of the cell that contains the formula and the cells referred to |
|
|
Term
|
Definition
| process of specifying the appearance of cells and the overall layout of a worksheet |
|
|
Term
|
Definition
The General format will display what you've typed except:
a) extremely long numbers will be shortened to scientific notation
b) trailing zeros will not be displayed
c) a decimal fraction entered without a number to the left of the decimal point will display with a zero
d) all of the above
e) all but a |
|
|
Term
|
Definition
| usedfor the general display of non-currency numbers |
|
|
Term
|
Definition
| format used for general monetary values, the US dollar sign being the default symbol |
|
|
Term
| Accounting displays the dollar sign at the left side of the cell rather than flushed against the first number, and it adds a blank space on the right side of positive values |
|
Definition
| What are two differences between the Accounting and Currency formats? |
|
|
Term
|
Definition
| In the Date and Time formats, those that begin with an ______ symbol are subject ot change by regional date and time settings specified in the Control Panel. |
|
|
Term
|
Definition
| multiplies the cell value by 100 and displays the result with a percent sign |
|
|
Term
|
Definition
| format that displays amounts as actual fractions rather than as decimal values |
|
|
Term
|
Definition
| format that displays numbers in scientific notation |
|
|
Term
|
Definition
| format that treats a number like it is text |
|
|
Term
|
Definition
| format used primarily with database functions such as postal codes, telephone numbers, and taxpayer ID numbers |
|
|
Term
|
Definition
| format used to create your own number format |
|
|
Term
|
Definition
| inserts thousand comma separators where appropriate and applies two decimal places |
|
|
Term
|
Definition
| tool to copy the formatting of one cell to other cells |
|
|
Term
|
Definition
| displays a list of potential results |
|
|
Term
|
Definition
| a predefined set of colors, fonts, lines, and fill effects that look good together and that can be applied to your entire workbook or to specific items |
|
|
