COMPSCI 1BA3 Study Guide - Final Guide: Vertical Bar, Century Gothic, Transmission Control Protocol
Document Summary
An excel table is a structured range of data that is managed independently from the rest of the data in a worksheet. You can replace the specific cell or range address with a structured reference, the actual table name or column header. Pivottables allow us to summarize data into categories using functions (detailed data is not shown) Values fields- the fields containing the data to be summarized. Category fields- the fields that the value fields will be grouped by. Evaluates whether a condition is true or false (called a logical test) and returns one value if the condition is true, and another value if the condition is false. If true then value a else value b : syntax: And function: allows you to test multiple conditions, returns either true or false, only returns true if all tested values are true, syntax: =and (logical1 [,logical2] : can nest in an if statement as the logical test remainer.