1 / 37

Freeze the panes

You can do this to the row and column titles to make larger worksheets easier to read. The titles will stay still while you scroll through the document. . Freeze the panes. Values in cells that you can change to determine new values for formulas. assumptions.

alec-terrell
Download Presentation

Freeze the panes

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. You can do this to the row and column titles to make larger worksheets easier to read. The titles will stay still while you scroll through the document. Freeze the panes

  2. Values in cells that you can change to determine new values for formulas. assumptions

  3. This feature allows you to check which cells are referenced in an active cell’s formula. Range finder

  4. How many spaces does the Increase Indent button move the cursor in each time you click it? 3

  5. A reserved place in the computer’s memory that allows you to collect text and graphic items to be pasted into any document. Office Clipboard

  6. Using the mouse to move or copy cells. (d & d) Drag and drop

  7. This clears the data from the cell, but the cells remain in the worksheet. clearing

  8. This erases all the data and the cell itself and the rows and columns adjust. delete

  9. What does #HREF! Indicate? A cell reference error

  10. This date function inserts the current date and time, following the system date set in your computer. NOW function

  11. What kind of cell reference is $B$20? (absolute or relative) absolute

  12. What does an absolute cell reference mean? If the cell is copied, the formula stays the same

  13. What does a relative cell reference mean? When you copy a formula, it automatically readjusts the formulas to different rows or columns

  14. Which function key can you hit to turn a relative cell reference into an absolute? F4

  15. Use this function when you want to assign a value to a cell based on a logical test. IF

  16. What does <> mean? Not equal to

  17. Which 2 keys do you hit to display the formula version of a worksheet? Ctrl and Accent mark

  18. #DIV/0! Error message: tried to divide by zero

  19. #NAME? Error message—formula uses a name that Excel does not recognize

  20. #N/A Error message—refers to a value not available

  21. #NULL! Error message—specifies an invalid intersection of two areas

  22. #NUM! Error message: uses a number incorrectly

  23. #REF Error message—refers to a cell that is not valid

  24. #VALUE Error message—uses an incorrect argument

  25. ############### Error message—cell is not wide enough to display the entire entry

  26. A function in which the action to be taken for the true or false case includes yet another IF function. Nested IF function

  27. How are negative numbers displayed? (in parentheses)

  28. What type of information does a Pie Chart show? Relationship of parts to a whole

  29. A curve that is applied to soften the appearance of a straight edge. bevel

  30. Exploding a slice of a pie chart to emphasize it. offsetting

  31. When you have a formula and some of the numbers change, the numbers automatically recalculate. What kind of analysis is this called? What-if

  32. When you know the result you want a formula to produce, you can use this function to determine the value of a cell on which the formula depends. Goal seeking

  33. What kind of dollar sign is this? (floating or fixed)$ 500.00 Fixed--it always stays in the left corner, regardless of length of number

  34. What kind of dollar sign is this?$500.00 floating

  35. Which of these is not a valid format symbol? ; % $ , ;

  36. What symbol do error messages always start with? #

  37. Good luck on your test!

More Related