MIS 302F Study Guide - Final Guide: Ampersand, Summary Statistics, Standard Deviation

• School: UT-Austin
• Department: Management Information Systems
• Course: MIS 302F
• Professor: Provost

Document Summary

All students will be provided with a copy of this reference sheet during exam 2. Mis 302f exam 2 excel reference sheet. Logical operators: =, , <=, >=, <> Syntax for logical functions: all text must be in quotes (but not numerical values or logical operators) Syntax rules for if family : all non-numeric criteria (no longer just text) must be in quotes . Use ampersand (&) to connect references to cells containing numerical values. Count of cells in a1:a10 equal to 100. Count of cells in a1:a10 greater than 32. Count of cells in a1:a10 containing the text win . Count of cells in a1:a10 containing a numerical value less than the numerical value in b1. Count of cells in a1:a10 that are greater than or equal to the average of numerical values in a1:a10. Count of cells in a1:a10 that are not empty. Built-in summary statistics: sum, count, average, max, min, product, standard deviation, variance.