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

A feature that automatically groups selected rows in Excel.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"7f7a50d9-23be-476b-919c-ac13b3e42d83","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Auto-Outline"},{"content":{"params":{"text":"

A formula in which the result is determined by the presence or absence of a particular condition.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"338c97e8-7f11-4737-91f2-748b456ae3ad","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Conditional Formula"},{"content":{"params":{"text":"

A condition you specify to limit which records are returned when filtering data. The plural of criterion is criteria.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"a6a2e940-baa4-47ea-a7e5-4ac7ca542209","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Criterion"},{"content":{"params":{"text":"

An electronic file that stores a series of records in a relatively simple format.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"f6f3c3dc-472f-4091-b24e-d8b91e13ca75","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Data File"},{"content":{"params":{"text":"

A comparatively complex system that can store a large amount of related data, which requires a program to be able to assess and render that data.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"be9ef48c-50cf-4b15-827c-6ea9aa6378b7","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Database"},{"content":{"params":{"text":"

A character that separates data entries from one another.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"1549beb0-392e-4491-af20-3045f99f83e3","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Delimiter"},{"content":{"params":{"text":"

An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"ec0d56c7-3ccc-4dae-87ea-e66e0ece9a5e","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Lookup Functions"},{"content":{"params":{"text":"

A series of steps you record that you might want to repeat frequently to save time.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"0c02716d-c96e-489f-92a4-662197dfb78e","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Macro"},{"content":{"params":{"text":"

To separate into components. Also, to interpret character by character.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"e681ba8b-136a-4186-8c41-ec26e9d46fb5","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Parse"},{"content":{"params":{"text":"

One of the ways to filter a table so that it shows onlly records containing a certain object. A slicer is a selection panel that floats above a worksheet (the way a chart does).<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"12d7a0cb-a617-47ee-8409-da0254702883","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Slicer"},{"content":{"params":{"text":"

The sum of values that are grouped together.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"c59b8ac0-3eb3-49e7-afc8-4786cacda684","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Subtotal"},{"content":{"params":{"text":"

A feature in Excel that ensures data is entered correctly, before it is processed incorrectly.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"7f4dcf26-fd3f-43ec-9edb-4d2cf494e5c1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Validation"}],"hTag":"h3"}

COMP126 Week 6 Key Terms

Kerri Shields