CS100 Study Guide - Final Guide: American Recovery And Reinvestment Act Of 2009, Amay

• School: University of Waterloo
• Department: Computer Science
• Course: CS100
• Professor: T As

Document Summary

Multiplies all the numbers given as arguments and returns the product. You can also perform this operation by using the multiply (*) operator. =product (a1:a3) evaluates to 48 (2*4*6) Adds the numbers specified as the arguments. You can also perform this operation by using the add (+) operator. =sum (a1:a3) evaluates to 12 (2+4+6) Adds the cells specified by a given criteria. =sumif (a1:a3, >2 , a1:a3) evaluates to 10 (4+6) Multiplies corresponding components in the given arrays, and returns the sum of these products. =sumproduct( a1:a3, b1:b3) evaluates to 108 ((4*9) + (6*8) + (6*4)) Returns the reference specified by a text string. References are immediately evaluated to display their contents. =indirect (a2) returns yes (value in cell b2) Vlookup (lookup_value, table_array, col_index_num, [range_lookup]) =vlookup(36, a1:b3, 2, false) returns production. Returns one value if a condition you specify evaluates to true, and a second value if that condition evaluates to. If (logical_test, [value if true], [value if false]