MIS 302F Study Guide - Midterm Guide: Hard Coding, Standard Deviation, Railways Act 1921

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

Document Summary

Exam 2 | mis 302f | november 6 2019. Mixed references (aka mixed addressing): , a, b:d, :. Be aware of the paste special feature and recognize its primary uses. Understand purpose and basic features of data validation and cell protection. Recognize primary features of excel tables: sorting, filtering (category, numerical), formatting with banded rows, Add total row, structured references, dynamic data source for charts and pivottables. Logical statements (with proper excel syntax) and logical values (true and false) Comparison operators: =, , <=, >=, <> Understand connection between logical values and conditional formatting. Evaluate logical statements in the context of creating conditional formatting rules. Understand purpose and application of logical functions: if, and, or, not. Be aware of the ifs function and its basic purpose but you will not have to apply on the exam. Nested if functions select among three or more possibilities when one if function uses another if as one of its three arguments.