CPSC-2200 Lecture Notes - Lecture 4: Office Open Xml, Xml, Data Validation
20 Nov 2017
School
Department
Course
Professor
Document Summary
Worksheet group a collection of two or more selected worksheets that when grouped, everything you do to the active worksheet also affects the other worksheets in the group. Other worksheet reference worksheet name, an exclamation mark, and then the cell range reference. If the worksheet name contains spaces you must enclose in single quotes. 3-d reference reference of a range of worksheets (first worksheet name, a colon, and the last worksheet name), an exclamation mark, and then the cell range reference . External reference references a range of cells in another workbook . Workspace an excel file that saves information about all currently opened workbooks. Hyperlink or link a reference to another file or web page. Template a workbook that contains labels, formats, and formulas already built in with cells for the user to enter data. Templates have an xltx extension and are created using save as template. If function - if(logical_test, value_if_true, value_if_false) ex: if(cid:894)c(cid:1009)= yes ,(cid:1005)(cid:1004),(cid:1004)(cid:895)
