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

A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"bd22e17a-ba3d-4eb4-b012-9352a062a691","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Absolute Cell Reference"},{"content":{"params":{"text":"

An Excel feature that automatically fill cells with data, formatting, or both.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"e5d706d6-6e0e-42a4-b27d-88310fc815b1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Auto Fill"},{"content":{"params":{"text":"

Pre-set settings that determine how Excel behaves when performing an action.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"c9f9971d-a09e-40a1-a00d-66674a7023db","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Default Settings"},{"content":{"params":{"text":"

A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"15d7b7fd-b684-4254-b398-f3bf11e81e2f","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"External Reference"},{"content":{"params":{"text":"

An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"647a02ea-5a45-4e4e-ae58-5e4d361142bb","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Formula"},{"content":{"params":{"text":"

A bar located between the ribbon and the worksheet in which users can edit the contents of a cell.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"732ab09d-7b02-488b-b27d-4def35f77787","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Formula Bar"},{"content":{"params":{"text":"

A cell reference that uses an absolute column or row reference, but not both.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"3d7d53fb-a870-48da-950f-928d5bb6b8a8","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Mixed Cell Reference"},{"content":{"params":{"text":"

A group of cells, and occasionally a single cell, with a designated name.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"05564f93-ae2c-4a35-b219-338de49b63c5","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Named Range"},{"content":{"params":{"text":"

A location that collects and stores up to 24 copied or cut items that are then available to be used in the active workbook, in other workbooks, and in other Office programs.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"3c7d699c-2dc4-45fc-af8f-197c2d48d6d0","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Office Clipboard"},{"content":{"params":{"text":"

A group of adjacent cells you select to perform operations on all of the selected cells.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"4299b9d7-23f2-4a39-ba6a-14b368f35879","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Range"},{"content":{"params":{"text":"

A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"e0380fc1-1f45-4818-9c32-5925a8d2626a","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Relative Cell Reference"}],"hTag":"h3"}

COMP126 Week 2 Key Terms

Kerri Shields