1	2					3
							4								5			6
						7									8
			9			10														11
		12										13		14											15
										16
			17
																18
19
										20														21
								22				23
24		25				26
																			27
										28
				29
																		30						31
													32
																33						34
			35																		36
																37
38
																	39
						40

Across 1. finds how many cells have a value entered 7. returns the number of cells in a range that contain numbers 8. an enhanced version of the pie chart 10. used for subcategories 11. instruct the software to perform calculations 12. used in a graph to clarify data categories or values 16. an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information 17. this function returns one value if a condition you specify evaluates to True and returns another value if the condition evaluates to False 18. used to fill a column or row with consecutive data such as numerical numbers 19. data that contains text, symbols, dates, or numbers not used in calculations 21. a validated _____ limits data entry to specific choices programmed into the function 23. all formulas begin with an 24. makes comparisons and generalizations about groups of data 28. allows the rows and/or column titles to remain stationary on the screen while you scroll 30. indicates the relationship of one component or data element to the whole data series such as the percentage of product sales to total sales 33. the bottom horizontal side of the graph 35. used to add identifying information to a spreadsheet 36. default justification for labels 37. this type of chart appears on the same sheet as the spreadsheet it represents 38. analyzing statistical or scientific data to determine a correlation 39. this type of chart may be used to immediately reflect up-to-date changes made to a spreadsheet 40. applied to cells that require more space when a row or column size is adjusted

Down 2. math procedure of calculating formulas used in spreadsheets 3. usually contains the numerical data 4. returns the number of cells in a range that contain any value/label 5. used to combine adjacent cells or cell ranges 6. the area bound by the values (y) and the categories (x) axes 9. a horizontal or vertical line that extends across the plot area of a graph 13. used to validate how data is represented on paper before printing 14. data that contains numbers that may be used in calculations 15. describes the horizontal data labels 18. square located at the bottom right of a cell used to create the continuation of a data series when dragged 20. used to calculate a 30 day due date for a record of spreadsheet invoices 22. used in a graph to indicate data values 24. this chart component is the main heading which describes the purpose and content of the chart 25. used to compare a cell value to an array of cells and return a value that matches the location of the value in the array 26. justification for titles and column headings 27. describes the vertical data labels 29. compares the contribution of the individual items to the whole 31. default justification for values 32. compares trends such as the sales trends of 3 departments over a period of time 34. thes object explains the symbols, colors, or patterns used to differentiate the data