post challenge 4

I leared how to use Excel ,now I know how to crate formulas and how to add, substact, divide, multiply. I also learned that there are functions in Excel. 

I can sum automatically. It can help me a lot in doing different difficult things. 

When you start to use it, it can be difficult but it is only practice. This software program is very complete, you can do many things, for example (invent formulas,add, substract,divide,multiply,do spreadsheets,and more things. 

Here is a photo whith some tools from this software programe:

One thing that Excel has is that on the top of the spreassheet you have the menu bar  where you have letters and numbers and when you write something, you can see in which cell of the spreadsheet you are writing.  For example, you see that you are writing in the cell H3.

 What is a Spreadsheets?

A spreadsheet is primarily designed to provide a digital form of the paper-based worksheet. Spreadsheets work through spreadsheet application software. The rows and columns within the spreadsheet contain cells that are filled with data to create unique operations. A typical spreadsheet program can have multiple functions.

Instead of reaching for your calculator, use Microsoft Excel to do the math!

On a worksheet, you can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. You can also use the AutoSum feature to quickly total a series of values without having to enter any of them manually in a formula. Once you have created a formula, you can fill it into adjacent cells — no need to create the same formula over and over again.

When you become familiar with these simple formulas, you may want to learn more about how to create complex formulas and try some of the many functions that are available in Excel.

                                                                                                                                                                             

   How to use simple formulas

All formula entries start with an equal sign (=). For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use  — the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide. Then, press ENTER, and Excel instantly calculates and displays the result of the formula.

For example, when you type =12.99+16.99 in cell C5 and press ENTER, Excel calculates the result and displays 29.98 in that cell.( image)

What is a Spreadsheet?

Alternatively referred to as a worksheet, a spreadsheet is a file made of rowsand columns that help sort data, arrange data easily, and calculate numerical data. What makes a spreadsheet software program unique is its ability to calculate values using mathematical formulas and the data in cells. A good example of how a spreadsheet may be utilized is creating an overview of your bank's balance. Below is a basic example of what a Microsoft Excel spreadsheet looks like, as well as all the important features of a spreadsheet highlighted.

Here is a video explaning how to use Spreadsheet:

From: Justina and Rosario

Concepts learned this week

Hi there! We are Joaquín Ozores and Francisco Gálvez and we are going to talk about the concepts learned this week using Excel. Excel can be a difficult program to use, but we are writing this post to help you to manage this extremely useful program called Excel. Here´s a quick description of what Excel is: Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of Microsoft Office. So, after this description let´s begin explaining the concepts learned this weeek.

What is a spreadsheet?

A spreadsheet is a file made of rows and columns that help sort data,arrange data easily,and calculate numerical data.What makes a spreadsheet software unique is its ability to calculate values using mathematical formulas and the data in cells.Below is a basic example about a microsoft excel spreadsheet looks like,as well as all the important features of a spreadsheet highlighted.

How to do simple calculations?

Formulas are expressions that are used to perform calculations or processing of values,producing a new value  that will be assingned 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).

Blogger didn´t let me change the letter size,I knew i had to do it in the normal size but it didn´t let me.

The post challenge

What is a spreadsheet?

A spreadsheet is an interactive computer app for organization, analysis and storage of data in tabular form. 





FOR EXAMPLE:


You can use this option named "SPREADSHEET" to calculate operations, sort columns, handle different sheets within each file, manage files. 
If you want to make a operation you only must to select it.

FOR EXAMPLE:

THE CELL:
They are usually rectangular and are formed at the intersection of a row and a column and are identified by a name, such as C4 (C is the name of the column and 4 of the row).




If you put a NUMBER in a CELL the number will  slide to the right, but if you want, you can chance that option.
In this photo there are three different positions for text. In the first option the text will slide to the left, in the second option the text will slide to the center and in the last option the text will slide to the right.




Here it is a Video explaining how to use a spreadsheet

Simple Calculations with spreadsheets

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:

Spreadsheet

A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form. Spreadsheets are developed as computerized simulations of paper accounting worksheets.The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. A spreadsheet may also refer to one such electronic document. Spreadsheet users can adjust any stored value and observe the effects on calculated values. 

A formula is an expression telling the computer what mathematical operation to perform upon a specific value. When referring to computer software, formulas are most often used in spreadsheet programs, such as Microsoft Excel. A function is a rule which relates the values of one variable quantity to the values of another variable quantity, and does so in such a way that the value of the second variable quantity is uniquely determined by the value of the first variable quantity.

By: Lucas and Thomas