In this post we are going to talk about Simple Calculations in Spreadsheets. We must explain what a spreadsheet is for you to understand better. With it you can perform most of the functions that leave the Spreadsheet Applications of Office Programs, such as performing operations between cells with different types of functions (mathematical, financial, etc...). Rows are the numbers (row number 1, 2, etc...) at the left of the spreadsheet; Columns are the letters (Column A, B, etc...) at the top of the spreadsheet; Cells are the rectangles that are produced when columns and rows cross each other(A1, B2, B1, etc...); and Ranges are a bunch of cells in a rectangular form, you name them by the first and last cell (Range B1:C2).
(Here you have an image to help you understand better)
So, as you may already know by the title, we are going to explain to you how to do simple calculations in spreadsheets. Now that you know the basics from spreadsheets, is time to begin with the main topic. Formulas are expressions that are used to perform calculations or processing of values, producing a new value that will be assigned to the cell in which the formula is entered.
Now that you know what a formula is, we can now proceed to the functions. A Function is a predefined Formula that performs calculations using specific values in a particular order. One of the main advantages is that they save time because you do not need to write it yourself. You have to write, fore example, if you want to add the cells A1 and B1 you have to write in the cell you want the result to go =SUM(A1;B1).
Here you have a video to clear things up a bit:
(Here you have an image to help you understand better)
So, as you may already know by the title, we are going to explain to you how to do simple calculations in spreadsheets. Now that you know the basics from spreadsheets, is time to begin with the main topic. Formulas are expressions that are used to perform calculations or processing of values, producing a new value that will be assigned to the cell in which the formula is entered.
Now that you know what a formula is, we can now proceed to the functions. A Function is a predefined Formula that performs calculations using specific values in a particular order. One of the main advantages is that they save time because you do not need to write it yourself. You have to write, fore example, if you want to add the cells A1 and B1 you have to write in the cell you want the result to go =SUM(A1;B1).
Here you have a video to clear things up a bit:
No comments:
Post a Comment