March 2009
Creating Split Worksheet Views In Microsoft Excel
by 1 otherThe Split command can be found in the View Tab of the Excel Ribbon. It allows you to split an Excel spreadsheet window into either two or four individual panes and is particularly useful for comparing data in different parts of a large worksheet.
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...
Microsoft Excel 2007 Functions: COUNT, COUNTA And COUNTBLANK
by 1 otherExcel boasts a huge range of functions which are conveniently arranged into categories. The COUNT function is found under the statistical category. There are actually five COUNT functions; COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS. We will look a...
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...
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...
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...
Customising Text Alignment Microsoft Excel 2007
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...
December 2008
Excel 2007 Number, Currency And Accounting Formats
Often, when you enter numbers into a spreadsheet, you need to ensure that the number format is consistent. For example, if these numbers are prices, you may want to display the currency symbol or you may simply want to specify that the number of decima...
1
(9 marks)