In this space I invite you to participate in a series of math activities using the Excel program.
This program is very useful and easy to use, just need to know some basics. The following image
the names to locate rows, columns, cells, and the formula bar.
To refer to a cell type first letter of the column and then the number of the row that is the cell. In the example in cell C1 multiply the values \u200b\u200bin cells A1 x B1. In the formula bar is operating.
math in Excel all begins with the sign = operation followed ex: if we multiplier data contained in cells A1 and write B1 in cell C1 following: = A1 * B1 then click ENTER and will result in cell C1
For multiplication use the * sign, division sign / , For the sum + and subtraction -
Remember that every mathematical operation in Excel starts with the =
I propose an activity to solve using the 4 basic operations
In a supermarket periodically change the money for large denominations, for example, if gathered $ 1,560 was exchanged for 15 tickets $ 100, 1 ticket for $ 50 and 1 ticket for $ 10 .
This activity involves designing a table in which by entering the amount collected automatically calculate the amount of high denomination banknotes.
As one of the operations to be used is the division, so that the result is an integer (whole numbers) will need to use the following formula: = INT (A1/B1) points A1 and B1 indicate the cells containing data to divide, as the return address to design these cells have other letters and numbers.
Here you can see a list with the possible format to use.
If the spreadsheet is working properly, by changing the amount of money $ 1,596 shall automatically change the values \u200b\u200bin other columns indicate the correct values, which alone will not change is the notes column to indicate the denomination of each bill or coin. At the end of the column test must show the amount that entered the beginning.
If they make the spreadsheet or have any questions write your comments may also send the forms to design the following e-mail: matematicaconexcel@yahoo.com.ar
Hope you like the challenge of using the talent to reach this activity.
Good luck, I hope your answers Greetings. Rodolfo
03/10/1906 Return activity
resolved: "Change for large denominations"
