Introduction to Spreadsheet Formulas

So you are studying Information Technology and have started using spreadsheet formulas. You have seen the terms formulas and functions used interchangeably, and you have begun to wonder whether they are the same thing. Well, they are not. While formulas and functions can be used to complete the same task, they are indeed different. In … Read more

What is Absolute and Relative Cell Reference: How to Use Them

Absolute and relative cell reference refers to the way you use cell names or range names in formulas and functions. Absolute and relative addressing allows you to copy a formula or function to a new cell. However, these two do not behave the same way when copied. Keep reading to learn: In the introduction to … Read more

Excel Conditional Functions

Excel conditional functions allow us to make calculations on part of the data by setting limits. So if you have a large volume of information on your customers, but you need to count the persons living in Trinidad, spreadsheets allow you to do this in a few seconds without having to move the data around. … Read more

What is a Spreadsheet Function

If you are new to spreadsheets or Microsoft Excel, you may now be learning what a spreadsheet function or formula is. This article is an introduction to spreadsheet functions and will clarify the following: If you are interested in other spreadsheet functions, visit Excel conditional functions to learn about the IF, COUNTIF, and SUMIF functions. … Read more