In this class we started of talking about how you can freeze certain columns. You can freeze certain columns by going tothe view pane on the toolbar and go to freeze pane. We also discovered how you can use the NOW formula, that gives you the date and time that is on your computer system. The What-If analysis was also introduced. It allows you to make assumptions, and it includes greater-than and less-than formulas. By right clicking onthe cell and going to format cells and clicking on alignment, you can change the direction of your words. Three types of cell referneces were introduced in this chapter of excel. Absolute cell reference, mixed reference, and relative cell reference are the three. The if statements are introduced as well. In order to use them, use must know the logic of the statement, and the comparison operators (=,<,>,<>,>=,<=). The first part of an if statement is the logical test, then you also must know the value (true or false). A nested if function is if the if statement includes yet another if function.
No comments:
Post a Comment