12 March 2009
Using The COUNTIF Function in Microsoft Excel 2007
by 1 otherThe COUNTIF function is used to calculate the number of cells in a given range which satisfy a condition. COUNTIFS does pretty much the same. However, this time, we can specify multiple criteria. By way of illustration, let's say we have a worksheet co...
24 February 2009
Changing Formats In The Same Cell In Microsoft Excel
by 1 otherWhen 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...
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...
Microsoft Excel 2007 Text Alignment Options
by 1 otherThe alignment section of the Home Tab of the Excel 2007 ribbon is home to a number of options relating to the way in which your data is position within the cell. The most familiar and most frequently used icons in this section are the three relating to...
1
(5 marks)
