Study Guides (238,098)
Canada (114,918)
CS 100 (27)
T As (1)

Excel Functions for final

5 Pages
Unlock Document

University of Waterloo
Computer Science
CS 100
T As

SOME USEFUL EXCEL FUNCTIONSFunction Description Example MATH FUNCTIONS PRODUCT Multiplies all the numbers given as A1 A2 A3arguments and returns the product You 2 4 6can also perform this operation by using the multiplyoperatorPRODUCT A1A3 SyntaxPRODUCT number 1 number2 evaluates to 48 246 SUM Adds the numbers specified as the A1 A2 A3arguments You can also perform this 2 4 6operation by using the addoperatorSUM A1A3 Syntax SUM number 1 number2 evaluates to 12 246 SUMIF Adds the cells specified by a given criteria A1 A2 A3 2 4 6SUMIF A1A3 2 A1A3 Syntax SUMIF range criteria sumrange evaluates to 10 46 SUMPRODUCT Multiplies corresponding components inA Bthe given arrays and returns the sum of 1 4 9these products 2 6 8 3 4 6 SUMPRODUCT A1A3 B1B3 evaluates to 108 4968Syntax SUMPRODUCT array1 array2 64
More Less

Related notes for CS 100

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.