exam3review

exam3review - Cell Referencing Relative (A1), Mixed ($A1 or...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Cell Referencing Relative (A1), Mixed ($A1 or A$1), Absolute/Fixed ($A$1) Copy Command What happens to cell contents, especially formulas, when they are copied and pasted, or dragged, into another cell ? If the contents of cell D4 are =B$4*$C$4 and are copied into cell D5, what will the contents of D5 actually be? =B$4 * $C$4 Format Cells Command General, Number, Currency, Accounting, Special, Custom, Date (both explicit and implicit / automatic) PerCent (both explicit and implicit / automatic) Conditional formatting and other Conditional formatting allows you to change the both the color, face and style of the Font used to display contents in a cell based on an evaluation of those contents. If ($1125.00) is displayed in red in a cell and -1125 is in the formula bar for that cell, Either Currency or Custom formatting was applied Zip Code is an example of a Special format. Custom and Special formatting allow(s) you to change the font color used to display numeric contents based whether the number
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online