Tuesday, May 18, 2010

Class 2: Functions, Formulas, Formatting and Web Queries


This chapter introduces how we are suppossed to use the order of operations while doing arithmetic in excel. During class I learned that pressing alt + enter, it allows me to stack my words inside one cell. Today in class, we made the spreadsheet for the Silver dollar Stock Club. While doing this, we used the fill handle tool to reach the initial cost for the entire column. It automatically multiplies two columns. It copies the previous equation used. The '=' sign must come first in your equation before you can trigger your formula. We also discussed how using Autosum, automatically sums up the total for an entire column. When an assignment uses 'highest', it really means MAX. We learned how to use the Merge and Center key, which centers the row that you choose. We also used the Cell Styles selection, which allows you to fromat a specific heading. To add some style to the spreadsheet, we learned how to use the fill button (which changes the background color). In this chapter we were also taught how to center a column by using the alignment feature, how to chnage the format of the date, by clicking on date, then more selections.



No comments:

Post a Comment