Computer Science 1032A/B Study Guide - Boolean Expression, Boolean Data Type, Payment Card

• School: Western University
• Department: Computer Science
• Course: Computer Science 1032A/B
• Professor: Diane Goldstein

Document Summary

Automatic update of formulas during replication commands. Allows the user to enter the formulas once, then replicate them in other cells. Absolute reference: remains constant when copied. Relative reference: adjusts during a copy operation. Mixed reference: row or column is absolute and other is relative. Absolute - used when a cell reference must not change during replication (prefixed with $) Part of our decision making process we use: boolean variables, relational operators, boolean operators. There are two boolean values: true and false. Boolean variables: represent only one of these values. In the example i have my atm card is either true or false. There are six relational operators: equal to , not equal to = Commonly used boolean operators: not, and , or. Not complements results of a boolean expression. Not operator proceeds expression it is applied to.