CGS 2060 Lecture 6: 6.1 Notes

2 Pages
Unlock Document

Computer General Studies
CGS 2060
Jill Weiss

3D reference a reference to the same cell or range in multiple worksheets in the same workbook worksheet group collection of two or more selected worksheets summary worksheet uses 3d reference to summarize data from 4 worksheets =sheetname!cellrange syntax to reference a cell or range =Quarter1!D10 reference cell D10 in quarter 1 if function evaluates and returs one value if condition is true and diff value if false and returns true value if all conditions are true and false value of any or all are not true or returns true value if any conditions are true and false if none are true calculated column formula is entered an excel table formula is atomically copied to all cells in that column. this column is called... nestedif
More Less

Related notes for CGS 2060

Log In


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.