BUS-K 201 Lecture Notes - Lecture 1: Down Payment, Interest Rate
Document Summary
The whole excel document is called a workbook. The numbers displayed on the left side of a sheet. The alphabet displayed on the top of a sheet. A space in the sheet referred by the row and column (i. e. b4) How to center the title across multiple cells. Round function: =round( your cell here , # of decimals you want ) Will round the number either up . How to find the maximum unit in a table: max function: =max(range, returns the highest value in the input range. How to find the minimum unit in a table: max function: =min(range, returns the lowest value in the input range. How to find the average unit in a table: max function: =average(range, returns the average value across the range. Value_if_true: if the logical test is true, then excel will display this expression. Value_if_false: if the logical test is false, then excel will display this expression.