09 March 2009
Excel 2007 COUNTIF AND COUNTIFS functions
by 1 otherThe 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 otherWhen 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 otherThe 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...
1
(3 marks)
