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

A method of copying data and formulas or creating data series by dragging the lower right corner of a cell or range.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"8a48efc1-e4d1-4dd3-be2f-efd9be88395e","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Autofill"},{"content":{"params":{"text":"

A feature that allows you to filter records in a worksheet by specifying filter critera. See Filter.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"b558e512-6c7d-438e-b5e9-f47b54896ff5","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"AutoFilter"},{"content":{"params":{"text":"

Simple formulas that use math operators such as add (+), subtract (-), multiply (*), and divide (\/) that you can insert into a pivot table or cerate new data based on existing data. See Pivot Table.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"996648da-d34f-406e-ba57-358cece090b5","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Calculated Fields"},{"content":{"params":{"text":"

A type of function used in situations in which you want to perform one or two different calculations, depending on which value is in one or more cells other than the ones in which the logical functions are located.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"853250be-06a1-4c0c-94d8-b7105d092b08","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Conditional Logic"},{"content":{"params":{"text":"

Buttons you can click to filter the data in a table or pivot table.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"6beb3012-0b1d-43cc-b393-2499e57e4600","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Data Slicers"},{"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","subContentId":"882ee3ef-4993-4cc2-8a8c-fd3adc6662f9","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Data Validation"},{"content":{"params":{"text":"

A feature that will extract, combine, and\/or re-sequence cell contents from one or more cells to create new values.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"608fa6c3-cdc0-42af-8ed7-6015e647f969","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Flash Fill"},{"content":{"params":{"text":"

Embedding one function inside of another one to yield a value that is the result of multiple calculations.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"66568874-387a-49e9-a7c0-06c4db55c9bf","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Goal Seek"},{"content":{"params":{"text":"

Embedding one function inside of another one to yield a value that is the result of multiple calculations.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"2c600d0d-2537-460b-a86d-72bb64aa7a0c","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Nesting"},{"content":{"params":{"text":"

A feature that enables you to quickly expand all or selected groups of data and collapse them again.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"cd9ceb07-b936-49db-bfa1-6e8d70681e59","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Outline"},{"content":{"params":{"text":"

A chart that displays the data in a pivot table. See Pivot Table.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"1ef346ed-21b2-40a7-abe1-61a8aece9cc3","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"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 intersection of the row or column fields.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"848416d3-cf6a-4a24-b705-f77990dff4c6","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Pivot Table"},{"content":{"params":{"text":"

A tool that enables you to determine the impact on calculations of changing values without changing the actual data. You can store a set of values as a result of multiple scenarios and compare them.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"3a6aabd3-1446-4176-9353-4354addd8dea","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Scenario Manager"},{"content":{"params":{"text":"

The secondary Y-axis appears on the far right of a chart. In a chart with dual axes, you can tie some of the data series to the primary axis on the left, and the remaining series to the secondary asix on the right.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"f7827cda-a013-4eb9-b0a8-ae4d9670337f","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Secondary Y-Axis"},{"content":{"params":{"text":"

An audit tool that draws to help you find or trace formula errors in cells tat are precedents (come before) or dependents (come after) of the current cell.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"34779b11-053b-438b-8140-947b570a54b0","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Tracing Tool"},{"content":{"params":{"text":"

A feature that enables you to edit macros by making changes to the macro code, which is written in the Visual Basic programming language.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"c541d6da-5506-4385-86df-d76d1eea6692","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Visual Basic Editor"},{"content":{"params":{"text":"

A small pop-up window that displays the current value of selected worksheet cells. It is useful when working with large worksheets; the watch window displays these cell values regardless of what part of the worksheet you have currently displayed on the screen.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"7987d4b2-1b68-4a35-921f-28325d109ad5","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Watch Window"},{"content":{"params":{"text":"

A process that involves repeating the calculation of a set of formulas many times using different numbers. It is a trial-and-error method that asks: \"If I change this number, how does that affect the result?\"<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"9ab689ca-17ce-4894-b959-1990ec05accb","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"What-if Analysis"}],"hTag":"h3"}

COMP126 Week 8 Excel 2019 Key Terms

Kerri Shields