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