|
 |
|
|
Basic Concepts Of Excel Spreadsheets
By Trevor Jurgenson
Basic Concepts Of Excel Spreadsheets
In Excel, a cell reference identifies the location of a cell or a group of cells in a spreadsheet, also known as a cell address. A cell address consists of the column letter and the row number that intersect at the cell's location. For example, the cell located in the upper-left corner of the worksheet is cell A1, meaning column A and row 1. An example of a single cell would be “A1”. An example of a group of cells would be “A1:A10” which is all the cells from A1 to A10. You can access any cell by simply clicking it with the mouse pointer. There are three basic types of data that can be entered into a cell: text, numbers and formulas. Text is any combination of entries from the keyboard, such as letters, numbers, symbols and spaces. Even though text can be used as cell data, they are more commonly used as headers or labels to identify a column or row’s purpose. Numbers are the numbers that are used to represent a quantity, an amount, a date or time. Excel can recognize the difference between text and numbers by what is typed. The biggest difference between text and numbers is numbers can be the basis for calculations while text cannot. The default format for cells containing a value is the “General” style. This style has no specific format and displays values as plain numbers – no dollar signs, commas etc. However numbers can be formatted in many different ways, such as currency, date, time, percentage and so on. Formulas are the combination of constants, cell references, arithmetic operations and/or functions displayed in a calculation. For Excel to recognize a formula, it must always start with an equals sign (=). An example of a very basic Excel function is =A1+B1. Excel formulas are one of the most useful features of the program. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, Excel does all the calculations for you.
|
Gib's Blog
excel 2007
PLEASE VISIT THE CONTRIBUTOR'S WEBSITE
No reactions yet.
Please login or sign up to rate this intel.
Please login or sign up to add a comment.
The copyright for this content entitled "Basic Concepts Of Excel Spreadsheets" has been specified by the contributor as:
Public Domain
The copyright for this content has been relinquished by the author. The content may be used freely by anyone.
|
 |
|
This intel was contributed by gibs
|
May, 2012
2008
January, February, March, April, May, June, July, August, September, October, November, December
2009
January, February, March, April, May, June, July, August, September, October, November, December
2010
January, February, March, April, May, June, July, August, September, October, November, December
2011
January, February, March, April, May, June, July, August, September, October, November, December
2012
January, February, March, April, May
|
|
Not a member yet?
Qondio is a powerful network for making it online. If you have a website to
promote, we can help.
Sign up and get in on the action.
|
|
Welcome to Qondio! Discover the awesome power this network can deliver by going to our About page. Or you could skip straight to the Sign Up form.
|
|
