Advertisement
Guest User

Untitled

a guest
Feb 28th, 2020
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. 1. Assumptions (EX 130) Values in cells that can be changed to determine new values for formulas.
  2.  
  3. 2. #REF (EX 146) It's used as a error message to indicate a cell reference error
  4.  
  5. 3. Format Symbols (EX 147) "Symbols which assign a format to numbers as they're entered.'
  6.  
  7. 4. NOW Function (EX 148) Is one of the twenty-four date and time functions that can be used in Excel.
  8.  
  9. 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."
  10.  
  11. 6. Relative Cell Reference (EX 151)
  12.  
  13. 7. Mixed Cell Reference (EX 151) A decision-making process used to compare two values, and assign entries in the appropriate cells.
  14.  
  15. 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."
  16.  
  17. 9. Sparkline Chart (EX 160) It provides a simple way to show trends and variations in a range of data within a single cell
  18.  
  19. 10. Clustered Column Chart (EX 170) A "clustered" column chart is used to compare values side by side, broken down by category
  20.  
  21. 11. Category Names (EX 170) Entries used for identifying major groups for a chart.
  22.  
  23. 12. Data Series (EX 170) Entries used for determining the individual columns in a chart.
  24.  
  25. 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.
  26.  
  27. 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