public marks

PUBLIC MARKS from smartestbiz with tags tutorial & "computer software"

31 March 2009

Using Microsoft Excel 2007's Freeze Panes Command

by 1 other
Many of the worksheets that are created Excel contain headings in the top row of the sheet. Normally, when we scroll down the sheet, any headings at the top will disappear. Similarly, if we scroll to the right, any headings on the left will disappear. ...

09 March 2009

COUNTIF AND COUNTIFS functions In Microsoft Excel 2007

by 1 other
The COUNTIF function is used to count the number of cells in a given range which satisfy a condition. COUNTIFS does the same. However, here, we can specify multiple criteria. For example, let's say we have a worksheet containing four columns: the date,...

24 February 2009

Changing Formats In The Same Cell In Microsoft Excel

by 1 other
When formatting text within an Excel worksheet, you have the choice of working at the cell level or at the text level. If you wish to work at the cell level you simply highlight one or more cells and choose your format settings. Any formatting that you...