Across
- 3. What area displays and allows you to edit the contents of the active cell?
- 4. What number format displays values as monetary amounts?
- 5. What function returns the largest value in a range?
- 7. What Excel feature quickly inserts common functions such as SUM?
- 8. What line can be added around a cell or range of cells?
- 9. What tab contains tools such as Sort, Filter, and data validation?
- 12. What is a horizontal group of cells identified by numbers?
- 13. What is a predefined formula in Excel called?
- 16. What formatting changes the background appearance of a cell?
- 18. What is the box formed by the intersection of a row and column?
- 19. What feature temporarily displays only data that meets certain criteria?
- 20. What function adds a group of numbers together?
- 21. What part of a chart identifies what its colors or symbols represent?
- 22. What is a group of selected cells called?
- 24. What formatting controls the appearance of characters in a cell?
- 27. What is a group of related values displayed in a chart called?
- 30. What Excel feature organizes related data into formatted rows and columns?
- 33. What command arranges data in a specific order?
- 40. What small square can you drag to copy data or continue a series?
- 41. What feature can restrict what type of information users enter into a cell?
- 42. What type of cell reference stays fixed when a formula is copied?
- 43. What tab is commonly used to add charts, tables, pictures, and other objects?
- 44. What type of number uses a point to separate whole numbers from fractional values?
- 45. What chart element describes what the chart represents?
- 46. What number format displays a value as a percent?
Down
- 1. What identifies a cell by its column letter and row number?
- 2. What is a single spreadsheet page within an Excel workbook?
- 3. What is an equation entered into a cell to calculate a value?
- 5. What command combines multiple selected cells into one cell?
- 6. What function counts cells containing numbers?
- 7. What feature automatically copies data or continues a pattern into nearby cells?
- 10. What term describes the cell that is currently selected?
- 11. What tab contains Excel's function library and formula-related tools?
- 14. What visual representation of worksheet data can be created in Excel?
- 15. What command keeps selected rows or columns visible while scrolling?
- 17. What formatting determines where data is positioned within a cell?
- 23. What feature displays long cell contents on multiple lines within the same cell?
- 25. What area at the bottom of Excel can display information such as Sum, Average, and Count?
- 26. What do you click at the bottom of a workbook to switch between worksheets?
- 28. What chart element provides a scale or categories along the sides of a chart?
- 29. What type of list lets a user select a value from predefined choices in a cell?
- 31. What is an Excel file containing one or more worksheets?
- 32. What area at the top of Excel contains tabs and groups of commands?
- 34. What type of cell reference changes when a formula is copied?
- 35. What is a tiny chart displayed inside a single Excel cell?
- 36. What function calculates the arithmetic mean of a group of values?
- 37. What is a vertical group of cells identified by letters?
- 38. What box displays the cell reference or name of the active cell?
- 39. What function returns the smallest value in a range?