From agb at metrolabel.com Wed Jun 20 06:46:53 2007 From: agb at metrolabel.com (Frank T.Crockett) Date: Wed, 20 Jun 2007 01:46:53 -0300 Subject: [Memorack] beard Message-ID: <4678B13D.7060108@emergis.com> OTCPicks.com Picks SREA As The Stock to Watch. UP 272% In 7 Days! Score One Inc. SREA $0.30 UP 20% Today Up another 20% today and over 272% in the last 7 days, OTCPICKS.com puts SREA on their watch list. Read up and get on SREA first thing Wed! To find out the specifics of about this function read the article on Excel's COUNTA Function. These features offer a quick and easy way to check on data and, if necessary, to correct errors in a spreadsheet. In general, a logical function only gives you a true or false answer. If not, a False statement is returned. So if you need to know how many cells contain numbers or dates in an Excel spreadsheet the COUNT function will do the job for you. Since I store my marks in an Excel spreadsheet, I am continually using this function to calculate things like student marks and class averages. Two formatting options available in Excel to help do this are borders and shading. To find out the specifics of about this function read the article on Excel's COUNTA Function. It can automatically sort, count, and total spreadsheet data and then create a second table to display the summarized data. Comments stay hidden until you want to read them. To find out the details about using this function in a spreadsheet, read the article on the Excel COUNT Function. It will ignore cells containing text or numbers. Average temperature, average price, and average speed are just some of the values that are calculated in a spreadsheet. To find out about inserting comments into a Microsoft Excel spreadsheet, watch the video on how to - How to Add Comments in Excel. Comments can also be added by more than one person, so co-workers can use them to share ideas and information with others while a spreadsheet is being created. Therefore, it seems appropriate to mention the AVERAGE function. Since I store my marks in an Excel spreadsheet, I am continually using this function to calculate things like student marks and class averages. What the COUNTBLANK function does is total all of the empty cells in a specified range. They are a great way to summarize your data, and they allow you to draw attention to data trends and patterns in a spreadsheet that might otherwise be difficult to see. What the COUNTBLANK function does is total all of the empty cells in a specified range. To find out the details about using this function in a spreadsheet, read the article on the Excel COUNT Function. To find out more about this handy tool, watch the video on how to Create Excel Pivot Tables. Comments stay hidden until you want to read them. By combining this feature with the Replace option, you can change that number for a different one. If not, a False statement is returned.