BTM 200 Chapter Notes -Equals Sign, Circular Reference, Microsoft Office 2010

• School: Concordia University
• Department: Business Technology Management
• Course: BTM 200
• Professor: Rafaat Saade

Document Summary

Appchap: excel 2: formulas and functions: a formula in excel must begin with, a cell"s specific location, a cells relative location, both an absolute and a relative cell reference, an equals (=) sign. 4: the median function, displays the lowest value in a range, identifies the midpoint value in a set of values, identifies the highest value in a range, tallies the number of cells in a range that contain values. 5: the countblank function, tallies the number of blank cells in a range, displays the current date and time, displays the current date, tallies the number of cells in a range that are not empty. 9: the nper, is the total number of payment periods, is a word or a string of characters that represent one or more cells, the present value of the loan, a set of range names.