CSE 2111 Study Guide - Final Guide: Encase, Sorting

• School: Ohio State University
• Department: Computer Science & Engineering
• Course: CSE 2111
• Professor: Clair Farris

Document Summary

Worksheet names are the names listed on tabs of the workbook. When to use: worksheet names do not need to be listed in the formula when referencing cells within the same worksheet. Formulas should be set up in such a way as to facilitate creating formulas that can be copied instead of having to be rewritten over and over. They should be created using cell referencing: worksheet names are needed when referencing cells in different worksheets. Na(cid:373)e (cid:373)ust (cid:271)e e(cid:374)(cid:272)ased i(cid:374) (cid:858) (cid:858) when worksheet names include one or more spaces: ="wo(cid:396)ksheet na(cid:373)e(cid:859)!cells. Also, helps with remembering the purpose of the formula. E(cid:374)(cid:272)ase i(cid:374) (cid:862) (cid:862: no quotes for: and, or, not, true or false. Functions (sumif(s), countif(s), and averageif(s: cell reference, greater than: (cid:862)>(cid:863)&a(cid:1006, greater than or equal to: (cid:862)>=(cid:863)&a(cid:1006, hard coded, g(cid:396)eate(cid:396) tha(cid:374): (cid:862)>2(cid:863, g(cid:396)eate(cid:396) tha(cid:374) o(cid:396) e(cid:395)ual to: (cid:862)>=2(cid:863) Formulas: greater than: >a2, greater than or equal to: >=a2. Functions (sumif(s), countif(s), and averageif(s: cell reference.