Shared Flashcard Set

Details

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

Additional Computer Science Flashcards

 


 

Cards

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!