# Shared Flashcard Set

## Details

Microsoft Excel 2007 Set 4
Concepts and Vocabulary of Microsoft Excel
30
Computer Science
Not Applicable
04/18/2011

Term
 general format
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
 displayed value
Definition
 what data displayed in a cell is referred to as
Term
 underlying value
Definition
 What data displayed in the formula bar is referred to as
Term
 width
Definition
 The displayed value depends on the _____ of a column.
Term
 rounding
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
 series of pound signs
Definition
 If a cell is too narrow to display all of the numbers, what will you see instead?
Term
 pound sign
Definition
 What is this: #?
Term
 function
Definition
 pre-written formula that takes one or more values, performs an operation, and then returns a value or values
Term
 equal sign
Definition
 What do all formulas begin with?
Term
 Formula bar
Definition
 What should you always view to know the exact content of a cell?
Term
 True
Definition
 T or F:  A displayed number may actually be a formula
Term
 Alt + =
Definition
 The keyboard shortcut for Sum
Term
 Sum
Definition
 an Excel function that is a prewritten formula for addition
Term
 relative cell reference
Definition
 a cell reference base on the relative position of the cell that contains the formula and the cells referred to
Term
 formatting
Definition
 process of specifying the appearance of cells and the overall layout of a worksheet
Term
 d
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
 Number format
Definition
 usedfor the general display of non-currency numbers
Term
 Currency format
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
 asterisk
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
 Percentage format
Definition
 multiplies the cell value by 100 and displays the result with a percent sign
Term
 fraction format
Definition
 format that displays amounts as actual fractions rather than as decimal values
Term
 Scientific format
Definition
 format that displays numbers in scientific notation
Term
 Text format
Definition
 format that treats a number like it is text
Term
 Special format
Definition
 format used primarily with database functions such as postal codes, telephone numbers, and taxpayer ID numbers
Term
 Custom format
Definition
 format used to create your own number format
Term
 Comma style
Definition
 inserts thousand comma separators where appropriate and applies two decimal places
Term
 Format Painter
Definition
 tool to copy the formatting of one cell to other cells
Term
 gallery
Definition
 displays a list of potential results
Term
 theme
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
Supporting users have an ad free experience!