Thursday, November 13, 2008
Ch.8--"Charts in Excel"
There are so many different kinds of charts because in reality there are many different ways to display data. There is not just one or two ways to illustrate something; there is a bunch of different ways to illustrate something. You would use these charts for finding a relationship between two things, looking at percentages and/or to compare different rates. You would use these options in a job where you have to prepare presentations for your boss or for a statistics class in college. At some point in your life you will probably need to make a chart of some data and Excel helps you get it done – and done fast.
Friday, November 7, 2008
Ch.7--"Worksheets and Workbooks"
When you open Microsoft Excel you have a spreadsheet in front of you and in the lower left-hand corner there are other sheets called worksheets. A workbook is a collection of all those worksheets. To transfer from one worksheet to another all you have to do is click on the worksheet you want to work on. To help identify which worksheet is which you can change its name by double clicking on it and typing what you wish to call it and you can change its color by going into Format then Sheet then Tab Color. You are able to link things from different cells of one worksheet to another. First you have the cell selected enter = then click on the worksheet you wish to link to that spot. Now that worksheet is opened. Finally to link you click the cell in that sheet to your first sheet you just click on it and hit enter. Excel transfers it. You can add cells from different sheets using the same technique except you need an addition sign. Working with different worksheets is made simple in Excel.
Monday, November 3, 2008
Ch.6--"Graphics in Microsoft Excel"
Just like Microsoft Word you can access graphics in Excel from the Insert menu then Picture and you can choose from file or clip art. If you choose from file you can search within your files for a picture. If you click clip art Excel will find graphics that are accessible from the internet. You type what you want in the search bar. To put it into the spreadsheet point your cursor over it and hit the arrow that appears and click insert. People will add graphics into the spreadsheet to change the appearance of the worksheet. These pictures are even sometimes added to illustrate data in the worksheet. An example is that some companies like to put their corporate logo at the top of the sheet to show who they are.
Subscribe to:
Posts (Atom)