BUS-K 201 Lecture Notes - Lecture 1: Down Payment, Interest Rate

63 views4 pages
School
Department
Course
Professor

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.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents