BU275 Lecture Notes - Lecture 1: Spreadsheet, Dialog Box, Conserved Sequence
Document Summary
Cell shading and borders can be added by using the borders button and the fill color button in the font group of the home tab. Range name is a descriptive name given to a cell or range of cells that immediately identifies what is there. Choose apply names from the define name menu on the formulas tab to update formulas throughout the spreadsheet to incorporate a newly defined range name. Changing cells are cells containing the decisions to be made. Output cells are cells that provide output depending on the changing cells. Sumproduct will sum up the product of each of the individual terms in two different ranges of cells when the two ranges have the same number of rows and the same number of columns. Relative reference is the relative position to the cell containing the formula. Absolute reference does not change when they are filled into other cells but instead always refer to the same absolute cell locations.