Across
- 3. The vertical spaces within a spreadsheet; labeled ABC
- 4. Counts the number of cells within a range that meet the given condition
- 5. Any built-in formula for performing calculations. Examples: SUM, AVE, MIN, MAX
- 7. The horizontal spaces within a spreadsheet; labeled 123
- 9. cells containing text that informs what data is contained in the rest of the cells in that row
- 12. The small square in the lower right corner of a selected cell. It shows crosshairs when selected
- 16. stops the topmost row(s) or leftmost column(s) from moving as the user scrolls through the document
- 17. begin a list with a Z or the highest number
- 18. counts the total number of values in a range
- 19. Number formatting, text formatting, text alignment, text rotation are some of the option found within the _____ tab.
- 21. The selected set of data in a table; two cell names separated by a colon
- 23. returns the minimum value in a range
- 26. Where rows and columns intersect (it's the address of the cell)
- 27. The ____ option allows you to emphasize cells or cell ranges using thick lines.
- 30. An effect to keep your eyes from skipping when reading data across a row
- 32. adds all the numbers in a range to provide a total
- 34. prevents changing cell content and formulas accidentally
- 35. This option (accessed by right-clicking a column letter) allows you to create a new column and push existing columns either left or right
- 36. content that repeats in a consistent way
Down
- 1. the formatting characteristics of a data set changes when user-specified conditions are met. For example, setting a red fill color for all cells containing a value of less than 60%.
- 2. A layout of calculated information arranged in rows & columns
- 5. a series of values and operators put together to perform calculations
- 6. Visual representations of numerical data within a spreadsheet
- 8. rearrange the order of a range of cells or the rows based on ABC or 123 order
- 10. This option allows you to properly sort the data contained in a spreadsheet table (range) by a column heading. It's accessed by clicking Data -> Sort Range -> then clicking _______.
- 11. Accessing the content of another cell (in either a formula or a function) is called a ___________.
- 13. This option (accessed by right-clicking a row number) allows you to create a new row and push existing rows either up or down
- 14. boxes created where the columns and rows meet
- 15. cells containing text that informs what data is contained in the rest of the cells in that column
- 16. The option to keep cells within view when scrolling
- 18. Double-clicking on a chart will open the _______
- 20. to repeat, to copy, or to duplicate data or a formula
- 22. begin a list with an A or a 1
- 24. Uploading data to your Google Sheet from another type of spreadsheet software is accessed by the ____ option
- 25. copy data to adjacent cells
- 28. return the maximum value in a range
- 29. adds all the numbers in a range, & then divides the total by the total number of values
- 31. changing the appearance of a cell or cells.
- 33. combine two or more cells within a single rectangular area into a merged cell
- 37. When referring to multiple adjacent cells