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

A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"8b4db45f-e227-4026-8be5-af63fb52d23d","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"AutoSum"},{"content":{"params":{"text":"

A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"d6985571-7e07-4454-8319-adb53f54278d","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"AVERAGE function"},{"content":{"params":{"text":"

A function that determines how many cells in a range contain a number.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"5f0c51b7-4ab0-4d68-a4fa-fc7a2fd27af6","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"COUNT function"},{"content":{"params":{"text":"

A function that returns the number of cells in the selected range that contain text or values, but not blank cells.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"12bb72cd-cfc4-41bf-bba9-26d4fecbd519","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"COUNTA function"},{"content":{"params":{"text":"

An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"ddaffcfe-4276-48d1-8461-1bea00886c51","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Conditional Formatting"},{"content":{"params":{"text":"

A function that counts the number of blank cells in a range.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"edb54cc1-bbb3-4be0-9f9e-92ba0cfc3636","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"COUNTBLANK function"},{"content":{"params":{"text":"

A function that returns the largest value in a set of values.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"5c7d01f5-176c-46e6-88b7-87a216ee3567","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"MAX function"},{"content":{"params":{"text":"

A formatting tool that appears above or below the shortcut menu when you right-click a cell and that displays the most commonly used formatting commands.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"b0eddd63-37fe-4198-8385-b4d8e31db42e","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Mini Toolbar"},{"content":{"params":{"text":"

A tool that enables you to control specifically what you want to paste after using the Copy or Cut commands, such as cell content, formulas, values, formatting, and much more.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"0760b067-1bc7-4590-89fb-47bac81438a5","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Paste Special"}],"hTag":"h3"}

COMP126 Week 3 Key Terms

Kerri Shields