Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1. Assumptions (EX 130) Values in cells that can be changed to determine new values for formulas.
- 2. #REF (EX 146) It's used as a error message to indicate a cell reference error
- 3. Format Symbols (EX 147) "Symbols which assign a format to numbers as they're entered.'
- 4. NOW Function (EX 148) Is one of the twenty-four date and time functions that can be used in Excel.
- 5. Absolute Cell Reference (EX 151) "Both column and row references remain he same when you copy this cell, because the cell reference are absolute."
- 6. Relative Cell Reference (EX 151)
- 7. Mixed Cell Reference (EX 151) A decision-making process used to compare two values, and assign entries in the appropriate cells.
- 8. Nested IF Function (EX 159) "A nested IF function is one in which he action to be taken for the true or false case includes yet another IF function."
- 9. Sparkline Chart (EX 160) It provides a simple way to show trends and variations in a range of data within a single cell
- 10. Clustered Column Chart (EX 170) A "clustered" column chart is used to compare values side by side, broken down by category
- 11. Category Names (EX 170) Entries used for identifying major groups for a chart.
- 12. Data Series (EX 170) Entries used for determining the individual columns in a chart.
- 13. Freeze Columns and Rows (EX 185) When "freeze columns and rows" is used, Excel displays their content in Column A of the current worksheet.
- 14. What-If Analysis (EX 187) "Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell..."
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement