Across
- 4. an excel feature that enables you to specify how cells that meet one or more given conditions should be displayed
- 6. a tool that enables you to set the order of multiple rules, fine-tune rule settings, and more
- 8. a formatting characteristic, such as bold, italic, or underlined text
- 10. the parameters of a function
- 11. two or more cells combined into a single cell
- 14. returns today's date and the current time, in the default format of mm/dd/yyyy hh:mm
- 15. arrange in a line or bring into alignment
- 16. a formatting tool that appears above or below the shortcut menu when you right-click a cell and that displays the most commonly used formatting commands
- 17. a set of formatting attributes that you can apply to a cell or range of cells more easily than by setting each attribute individually
- 18. a formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the sum function in its formula
- 19. function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the AVG function in its formula
- 21. function that determines how many cells in a range contain a number
- 23. to automatically display data on the next line when it is too long to display within the cells width.
- 24. requires a series of inputs regarding interest rate, loan amount (principal), and loan duration, and then calculates the resulting loan payment
- 25. a set of text properties that affects the typeface, size, and similar aspects of text
Down
- 1. an arrow that shows the relationship between formulas and the cells they refer to in order to resolve a formula error
- 2. a tool that enables you to control specifically what you want to paste after using the copy or cut commands, such as cell content, formulas, values, formatting and much more
- 3. Determinesthe minimum value in a range of cells
- 5. returns a subtotal for a list
- 7. a shortcut that enables you to navigate to a web page or a location in another file in just one click of the mouse
- 9. totals all of the cells in a range
- 12. function that returns the number of cells in the selected range that contain text or vales, but not blank cells
- 13. function that returns the largest value in a set of values
- 20. returns the current date in a worksheet
- 22. a feature found in most office applications that allows you to quickly copy formatting attributes that you have already applied and paint those attributes onto other text, shapes, pictures, pictures, and worksheet cells