{"id":50485,"date":"2020-07-13T19:52:33","date_gmt":"2020-07-13T19:52:33","guid":{"rendered":"https:\/\/www.certificationanswers.com\/?p=50485"},"modified":"2020-07-23T09:00:47","modified_gmt":"2020-07-23T09:00:47","slug":"mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e","status":"publish","type":"post","link":"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/","title":{"rendered":"Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually?"},"content":{"rendered":"<p>Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually?<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Protect the sheets to keep an original copy of the data in case of errors or accidental deletion of data.<\/li>\n<li>Use the \u201cScan All\u201d function to locate specific values and student names.<\/li>\n<li><span style=\"color: #008000;\"><strong>Use filters to display required data and hide unwanted data.<\/strong><\/span><\/li>\n<li><span style=\"color: #008000;\"><strong>Use charts to visually represent student progress.<\/strong><\/span><\/li>\n<\/ul>\n<div class=\"code-block code-block-2\">\n<div id=\"PAds_post\" align=\"center\">\n<div id=\"div-gpt-ad-1587051306123-0\" data-google-query-id=\"CPD3oa6B4-oCFeHp5godpIILug\"><\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? &nbsp; Protect the sheets to keep an original copy of the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[313],"tags":[],"class_list":{"0":"post-50485","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-google-certified-educator-level-2-exam-answers","7":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u25b7\u2764\ufe0fMrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? - Certification Answers<\/title>\n<meta name=\"description\" content=\"Get the answer of \u23e9Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? \u2705\u25b7\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7\u2764\ufe0fMrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? - Certification Answers\" \/>\n<meta property=\"og:description\" content=\"Get the answer of \u23e9Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? \u2705\u25b7\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/\" \/>\n<meta property=\"og:site_name\" content=\"Certification Answers\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-13T19:52:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-23T09:00:47+00:00\" \/>\n<meta name=\"author\" content=\"CertificationAnswers\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CertificationAnswers\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/\"},\"author\":{\"name\":\"CertificationAnswers\",\"@id\":\"https:\/\/www.certificationanswers.com\/en\/#\/schema\/person\/0a9c7c94ef30c652c609d82ce40c0f22\"},\"headline\":\"Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually?\",\"datePublished\":\"2020-07-13T19:52:33+00:00\",\"dateModified\":\"2020-07-23T09:00:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/\"},\"wordCount\":140,\"articleSection\":[\"Google Educator Level 2 Certification Answers\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/\",\"url\":\"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/\",\"name\":\"\u25b7\u2764\ufe0fMrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? - Certification Answers\",\"isPartOf\":{\"@id\":\"https:\/\/www.certificationanswers.com\/en\/#website\"},\"datePublished\":\"2020-07-13T19:52:33+00:00\",\"dateModified\":\"2020-07-23T09:00:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.certificationanswers.com\/en\/#\/schema\/person\/0a9c7c94ef30c652c609d82ce40c0f22\"},\"description\":\"Get the answer of \u23e9Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? \u2705\u25b7\",\"breadcrumb\":{\"@id\":\"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.certificationanswers.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Educator Level 2 Certification Answers\",\"item\":\"https:\/\/www.certificationanswers.com\/en\/category\/google-certified-educator-level-2-exam-answers\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.certificationanswers.com\/en\/#website\",\"url\":\"https:\/\/www.certificationanswers.com\/en\/\",\"name\":\"Certification Answers\",\"description\":\"We help you to pass your exams\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.certificationanswers.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.certificationanswers.com\/en\/#\/schema\/person\/0a9c7c94ef30c652c609d82ce40c0f22\",\"name\":\"CertificationAnswers\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.certificationanswers.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/504682f79dcfd661f7d78a7b3ffbf7b900ae0b7897547f4e795ee7b622afe03a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/504682f79dcfd661f7d78a7b3ffbf7b900ae0b7897547f4e795ee7b622afe03a?s=96&d=mm&r=g\",\"caption\":\"CertificationAnswers\"},\"url\":\"https:\/\/www.certificationanswers.com\/en\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7\u2764\ufe0fMrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? - Certification Answers","description":"Get the answer of \u23e9Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? \u2705\u25b7","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/","og_locale":"en_US","og_type":"article","og_title":"\u25b7\u2764\ufe0fMrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? - Certification Answers","og_description":"Get the answer of \u23e9Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? \u2705\u25b7","og_url":"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/","og_site_name":"Certification Answers","article_published_time":"2020-07-13T19:52:33+00:00","article_modified_time":"2020-07-23T09:00:47+00:00","author":"CertificationAnswers","twitter_card":"summary_large_image","twitter_misc":{"Written by":"CertificationAnswers"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/#article","isPartOf":{"@id":"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/"},"author":{"name":"CertificationAnswers","@id":"https:\/\/www.certificationanswers.com\/en\/#\/schema\/person\/0a9c7c94ef30c652c609d82ce40c0f22"},"headline":"Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually?","datePublished":"2020-07-13T19:52:33+00:00","dateModified":"2020-07-23T09:00:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/"},"wordCount":140,"articleSection":["Google Educator Level 2 Certification Answers"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/","url":"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/","name":"\u25b7\u2764\ufe0fMrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? - Certification Answers","isPartOf":{"@id":"https:\/\/www.certificationanswers.com\/en\/#website"},"datePublished":"2020-07-13T19:52:33+00:00","dateModified":"2020-07-23T09:00:47+00:00","author":{"@id":"https:\/\/www.certificationanswers.com\/en\/#\/schema\/person\/0a9c7c94ef30c652c609d82ce40c0f22"},"description":"Get the answer of \u23e9Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually? \u2705\u25b7","breadcrumb":{"@id":"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.certificationanswers.com\/en\/mrs-wallace-is-a-department-head-in-a-high-school-and-is-looking-at-the-performance-grades-for-all-students-in-one-semester-what-features-can-she-use-in-google-sheets-to-help-analyze-the-data-e\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.certificationanswers.com\/en\/"},{"@type":"ListItem","position":2,"name":"Google Educator Level 2 Certification Answers","item":"https:\/\/www.certificationanswers.com\/en\/category\/google-certified-educator-level-2-exam-answers\/"},{"@type":"ListItem","position":3,"name":"Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data e\ufb03ciently without having to search through it manually?"}]},{"@type":"WebSite","@id":"https:\/\/www.certificationanswers.com\/en\/#website","url":"https:\/\/www.certificationanswers.com\/en\/","name":"Certification Answers","description":"We help you to pass your exams","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.certificationanswers.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.certificationanswers.com\/en\/#\/schema\/person\/0a9c7c94ef30c652c609d82ce40c0f22","name":"CertificationAnswers","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.certificationanswers.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/504682f79dcfd661f7d78a7b3ffbf7b900ae0b7897547f4e795ee7b622afe03a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/504682f79dcfd661f7d78a7b3ffbf7b900ae0b7897547f4e795ee7b622afe03a?s=96&d=mm&r=g","caption":"CertificationAnswers"},"url":"https:\/\/www.certificationanswers.com\/en\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.certificationanswers.com\/en\/wp-json\/wp\/v2\/posts\/50485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.certificationanswers.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.certificationanswers.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.certificationanswers.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.certificationanswers.com\/en\/wp-json\/wp\/v2\/comments?post=50485"}],"version-history":[{"count":0,"href":"https:\/\/www.certificationanswers.com\/en\/wp-json\/wp\/v2\/posts\/50485\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.certificationanswers.com\/en\/wp-json\/wp\/v2\/media?parent=50485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.certificationanswers.com\/en\/wp-json\/wp\/v2\/categories?post=50485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.certificationanswers.com\/en\/wp-json\/wp\/v2\/tags?post=50485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}