{"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","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"d046a4e8-9768-4932-b7b9-0151b558f35b"},"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","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"d3d798c2-8517-4f1d-bd60-2a48c226e410"},"title":"Auto Fill"},{"content":{"params":{"text":"

Pre-programmed formulas used to perform specific calculations. You can either type these functions in or use the Insert Function wizard to assist.<\/p>\n"},"library":"H5P.AdvancedText 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"4af466c8-7b2f-4381-9695-f5e40690290b"},"title":"Built-in Functions"},{"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","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"502460f9-dd00-421e-b49d-4cc38577478d"},"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","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"4e631244-3349-4825-b83b-4efa055ea449"},"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","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"27faa5a1-89e0-4cb2-bbcb-28fffe09b833"},"title":"Mixed Cell Reference"},{"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","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"4cfe581b-bcd0-421b-80d0-a7131c80655f"},"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","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"b521b001-ce1b-41c5-9f89-ba84187433a2"},"title":"Relative Cell Reference"}],"hTag":"h3"}

COMP701 Week 5 Key Terms

Kerri Shields