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

A built-in set of filtering capabilities.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"3fd3588f-5222-435e-a9cf-c027c75df1c8","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"AutoFilter"},{"content":{"params":{"text":"

A formula in which the result is determined by the precence or absence of a particular condition.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"ecf7ca7f-979c-46c8-854b-711b2589ff6e","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Conditional Formula"},{"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":"7d278cf6-ce0a-4c6f-8d15-7207cf0ca1db","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Database"},{"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":"80aaad46-e4ca-4eb8-ae06-10faa38e1e68","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Data File"},{"content":{"params":{"text":"

Text that provides additional information about a data marker on a chart, which represents a single data point or value that originates from a worksheet cell.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"cbe3b4d8-114f-4780-823d-d6aac22e8cac","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Data Label"},{"content":{"params":{"text":"

A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that orginates from a worksheet cell.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"b18a6a92-a3c2-40a2-a9c7-9ad3287e6042","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Data Marker"},{"content":{"params":{"text":"

A character that separates data entries from one another.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"80fce23f-37d4-4665-babf-827ba0312a81","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Delimeter"},{"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":"7b1287b7-a323-4f48-b10e-2b5eb5707fa7","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":"d94e5d47-17c1-4307-b02e-36f979a9cc9e","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Macro"},{"content":{"params":{"text":"

A set of data that describes or gives information about other data.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"dcbb5f2f-9fa4-4088-9be4-f694d598311b","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Metadata"},{"content":{"params":{"text":"

A PivotTable is a highly configurable table that condenses large amounts of data. A PivotTable is used to analyze and display numerical data in detail and to answer unforeseen questions about data.<\/p>\n\n

A PivotChart is a graphical representation of the data in a PivotTable.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"82f2bf11-138f-4918-a998-19bdf45157e2","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"PivotTable and PivotChart"},{"content":{"params":{"text":"

Predefined formatting in Excel that enables you to apply an elaborate format that makes a table look sleek and professional.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"d3782a90-9543-444f-9ef6-b4b9fd7d8d42","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Quick Format"},{"content":{"params":{"text":"

Changing from colour to black and white or greater or reduced levels of colour. Often applied to images.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"f46735eb-d0d2-4fd0-b1b4-a9bb62cbf2cb","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Saturation"},{"content":{"params":{"text":"

One of the ways to filter a table so that it shows only 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":"4ce6d8ce-4635-4c09-aed4-3ac9fae3dc9b","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Slicer"},{"content":{"params":{"text":"

Miniature graphs that summarize data; typically used to graphically describe trends in data.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"7a10b332-e7b9-4f06-baae-2a00649c02bd","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Sparklines"},{"content":{"params":{"text":"

A feature that marks and records chagnes made to a workbook. This is helpful when multiple users are working together on the same workbook.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"d6d64587-bc40-4bbf-8a84-36e0cc8b515a","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Track Changes"},{"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":"d3a90b5b-cdc9-48f1-8864-ebb0649cea20","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Validation"}],"hTag":"h3"}

COMP126 Week 8 Key Terms

Kerri Shields