public marks

PUBLIC MARKS from smartestbiz with tags "EXCEL 2007" & software

09 March 2009

Excel 2007 COUNTIF AND COUNTIFS functions

by 1 other
The COUNTIF function enables us to count the number of cells in a given range which satisfy a condition. COUNTIFS does exactly the same. However, with COUNTIFS, we can specify multiple criteria. For instance, let's say we have a worksheet containing fo...

24 February 2009

Using Different Formatting In The Same Cell In Microsoft Excel

by 1 other
When changing the appearance of text within an Excel worksheet, you have the choice of working on the entire cell or at the text level. To work at the cell level you simply highlight one or more cells and choose your formats. The formats that you choos...

19 February 2009

Customising Text Alignment Microsoft Excel 2007

by 1 other
The alignment section of the Home Tab of the Excel ribbon contains a number of options relating to the way in which your data is position within the cell. Perhaps the most familiar and the most frequently used buttons in this section are the three rela...