Across
- 2. symbol which indicates the relationship between two values
- 6. displays the current date and time according to the formatting of the cell
- 11. recognized formats for date and time values
- 16. page is longer than its width
- 17. grid of rows and columns in which text and numbers are entered and results are calculated
- 20. text printed on the bottom margin of each page
- 22. points to a specific cell and does not change when copied and includes dollar signs in the reference name
- 24. sheets containing formulas, functions, values, text and graphics which make up a workbook
- 27. named operation which returns a value
- 29. creates a date value for the date represented by the year, month and day arguments
- 32. displays only data which meets certain criteria
- 33. tiny chart in the background of a cell
Down
- 1. range which contains the data selected to display in the chart
- 3. shortcuts to different locations
- 4. allows a user to specify where a page break is located in a worksheet
- 5. works with values which are either true or false
- 7. text printed in the top margin of each page
- 8. expression which returns a value
- 9. address of a cell range based on the relative position of the cell
- 10. applies formatting only when a cell’s value meets a specified criterion
- 12. page is wider than its length
- 13. shows how the worksheet will appear on the page or pages when they are printed
- 14. range of values which is plotted as a single unit on the chart
- 15. view of workbook contents which displays formulas instead of resulting values
- 18. displays the location of different page breaks within a worksheet
- 19. contains both relative and absolute references
- 21. file used to store worksheets
- 23. sort data by text, numbers, formatting and dates and times in one or more columns
- 25. shows the contents of the worksheet
- 26. address of a cell indicating its column and row location
- 28. places current date in a cell
- 30. numerical value which can be used in a mathematical calculation
- 31. combination of letters, numbers and some symbols which form words and sentences
