IOE 373 Study Guide - Final Guide: Odds Ratio, Collaborative Filtering, Stepwise Regression

• School: U of M
• Department: Industrial And Operations Engineering
• Course: IOE 373
• Professor: Luis Garcia- Guzman

Document Summary

Combobox: drop-down list, one item at an item, can enter value not on list. Frame: enclose other controls, aesthetic or grouping if many optionbuttons. Multipage: create tabbed dialog boxes like formatcells, default = 2 pages. Optionbutton: select only one item from group, if multiple, each group must be uniquely named or grouped in frame. Refedit: to select range, accepts typed or selected range, returns text string represented range address, Spinbutton: select value by clicking 2 arrows, often with textbox or label to display values, horizontal or vertical. Tabstrip: like multipage, not as easy, can"t be a container for other objects. Pivotcaches: a collection of pivotcache objects in a workbook object (the data used by a pivot table is stored in a pivot cache). Pivottables: a collection of pivottable objects in a worksheet object. Pivotfields: a collection of fields in a pivottable object. Pivotitems: a collection of individual data items within a field category.