{"panels":[{"content":{"params":{"text":"

A feature that allows you to filter records in a worksheet by specifying filter criteria. See Filter.<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"0b54cf74-263b-4361-b53e-f1ff7e5d94bb"},"title":"AutoFilter"},{"content":{"params":{"text":"

Pre-programmed formulas used to perform specific calculations. You can either type these functiojns in or use the Insert Function wizard to assist in creating the function. See Insert Function.<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"750096d5-5c69-4802-a37b-c8cc8715fa7a"},"title":"Built-in Functions"},{"content":{"params":{"text":"

Simple formulas that use math operators such as add (+), subtract (-), multiply (*), and divide (\/) that you can insert into a pivot table to create new data based on existing data. See Pivot Table.<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"d24349da-7bff-4f0d-9c23-cbd690fca617"},"title":"Calculated Fields"},{"content":{"params":{"text":"

A feature that helps you set up validation checks in cells; for example, numbers only, list of inventory items available only, and so on.<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"561c1622-0ef2-4b62-bf57-1aa4cd99ab93"},"title":"Data Validation"},{"content":{"params":{"text":"

Buttons you can click to filter the data in a table or pivot table.<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"9294ceea-ffb3-457b-af2f-19d606620aec"},"title":"Data Slicers"},{"content":{"params":{"text":"

An auditing tool used to assist in checking any errors that may exist in the formulas. Any errors, are marked with a dark green triangle in the upper left corner of a cell.<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"2177c9a3-0639-4b67-8a35-1e99f8e5ea2f"},"title":"Error Checking"},{"content":{"params":{"text":"

The process of temporarily hiding data rows and\/or columns that do not meet the filter criteria.<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"90f0c43d-73ba-431b-8eb5-e22ebdcaaf90"},"title":"Filter"},{"content":{"params":{"text":"

A feature you can use to simplify a large table or pivot table by condensing data into logical groups (for example, grouping data values by month, quarter, or year).<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"0eef1da9-23b3-4194-bbb1-f9f484e73d19"},"title":"Grouping"},{"content":{"params":{"text":"

The feature that Excel provides to help you select the desired function to perform calculations.<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"6d25d679-fc37-4230-847f-3c50a17de35a"},"title":"Insert Function"},{"content":{"params":{"text":"

A chart that displays the data in a pivot table. See Pivot Table.<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"48601e7d-d7a9-46d0-8b7d-62158fd3b9e6"},"title":"Pivot Chart"},{"content":{"params":{"text":"

A table that summarizes or cross-tabulates large amounts of data by selecting fields for rows and columns and performing a summary function on the intersections of the row and column fields.<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"4d5c503a-edf8-4289-88e7-990e75a61893"},"title":"Pivot Table"},{"content":{"params":{"text":"

An audit tool that draws arrows to help you find or trace formula errors in cells that are precedents or dependents of the current cell.<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"ab9c83c1-4a99-48e9-b10e-b95f66132666"},"title":"Tracing Tool"}],"hTag":"h3"}

COMP126 Week 6 Excel 2019 Key Terms

Kerri Shields