Computer

2. chart-This type of chart provides a visual aid for pivot tables.
3. area- is a point on the worksheet where you would drag a Pivot Table field in order to reorganize how a report is
6. that you can employ to decide which rows in a worksheet to display.
8. table-This is a data summarization tool most commonly used to sort, average to sum up data automatically.
10. data-It can either exist within the worksheet or from and an external database.
12. Box Launcher-By clicking this arrow explore more options about the concerned group.
13. Control-it allows you to zoom out by 10% and zoom up to 400%.
14. a formatted workbook or worksheet designed to help users fulfill a specific need in Exce
16. Code-This appears if Excel finds a problem with a provided formula.
18. enables you to effortless copy data to more than one cell.
19. sequence inside a cell that is used to produce a value
20. validation-This feature helps to prevent incorrect data from being entered into your worksheet.

1. is an automated format application to cells that match pre-determined criteria.
4. are symbols or signs that indicate which calculation must be made in an expression.
5. panes-allows you to select specific columns and/or rows to remain visible on the worksheet, even if you are scrolling, such as head
7. formatting-Formatting is applied only when the cell meets determined criteria such as duplicate values or values above or below a thresh.
9. are sub-categories of fields in your pivot table. If you have a field that is marked State, the items could be Alabama,
11. feature will add up the numbers you have entered in your sheet and displays the total in a cell of your choosing.
15. Formatting-This is the act of changing the in which cell data is displayed in the spreadsheet.
17. area-It can either exist within the worksheet or from and an external database.