Across
- 3. The tab used to apply cell styles
- 4. The horizontal sections in a spreadsheet
- 5. The function used to change text to uppercase
- 7. A formula that returns the average of a range
- 12. A feature that fills data based on recognized patterns
- 13. The cell reference type that doesn't change when copied
- 15. The shortcut to switch between worksheets
- 19. A shortcut to create a new workbook
- 20. The tab that allows you to apply conditional formatting
- 22. A shortcut to redo an action
- 26. The tab used for adjusting page layout and printing options
- 28. The feature that adjusts column width automatically
- 29. A shortcut to undo an action
- 30. A function that checks if a condition is met
- 32. The function used to add up a range based on criteria
- 33. The function used to join two or more text strings
- 34. A formula that finds the sum of a selected range
- 38. A tool used to apply different formatting styles based on rules
- 41. The key that allows you to move to the next cell in a row
- 42. The Excel function that removes extra spaces from text
- 43. The key used to enter data in a selected cell
- 44. The function used to count numbers in a range
- 46. The file format for an Excel workbook
- 47. A tool used to record and run a series of steps automatically
Down
- 1. The name for pre-designed spreadsheets with formatting
- 2. The command used to freeze panes in a spreadsheet
- 6. A type of chart that represents percentages
- 8. The feature used to combine multiple cells into one
- 9. The bar at the top where you can see and edit cell contents
- 10. The small square at the bottom-right of a cell for dragging formulas
- 11. A tool for visualizing a subset of data interactively
- 14. A formula that returns the current date
- 16. A function that returns the number of characters in a text string
- 17. A shortcut to save a workbook
- 18. A function that looks up values from a table
- 21. The tab where you find options to create charts
- 23. A function used to return the highest number in a range
- 24. The shortcut to select an entire column
- 25. A tool used to visually represent data in bars or lines
- 27. The feature that lets you filter data in columns
- 30. The tab used to insert headers and footers
- 31. The function used to return the lowest number in a range
- 32. A tool used to arrange data in ascending or descending order
- 35. A built-in Excel feature used for quickly analyzing data trends
- 36. A tool used to summarize large datasets
- 37. The name for vertical sections in a spreadsheet
- 39. The default number of worksheets in a new Excel workbook
- 40. The feature that allows inserting comments in cells
- 44. The default font in Excel 2016
- 45. The extension for macro-enabled workbooks
