I really don't understand this. I have to do this for my Business Class. I understand that the letters and numbers are there to tell you where your things are located but why do I have to type up b7+b3? Is this algebra or what?
2007-01-30 04:41:01 · 6 answers · asked by xanga.com/the_skirt_girl 1 in Computers & Internet ➔ Programming & Design
Okay, I know that Excel does have a lot of algebra in it but how in the world do I do the problems? I'm lost. Help!
2007-01-30 04:43:53 · update #1
What is up with Excel????? I have to type up =(b3+b4+b5)/2
2007-01-30 04:50:04 · update #2
Okay, it's not that I need help with the b7 stuff it's just that I would like to know why I have to do this. It's a little complicated.
2007-01-30 04:55:23 · update #3
b7+b3 is simple arithmetic! One may argue that it is algebra because b7 and b3 represent variables. Meaning their sum is dependent on the values contained within those 2 cells.
What is the value in cell b7? What is the value in cell b3? All Excel is doing is adding these 2 values together. If b7= 10 and b3=5, when you add them together, you get 15. It's as simple as that.
2007-01-30 04:53:19 · answer #1 · answered by Scottee25 4 · 0⤊ 0⤋
its really simple. when you reference b3 you are saying grab the value stored there. So if in cell b3 there is a 5, and and in b4 there is a 7 and in b5 you have b3+b4 it will show 12. now if you change the values in b3 or b4 then the value in b5 will automatically change. for example if you change the value in b3 from 5 to 6 now b5 will how 13 instead of 12.
the main thing to remembing is you are just referencing what is in a particular cell when you list the cell number out.
2007-01-30 05:15:45 · answer #2 · answered by Wesley C 3 · 0⤊ 0⤋
in excel spreadsheet, content is entered in cells, a cell can contain values or formula, and content in each cell is referred by specifying the column and row number.
b7+b3
above basically is a calculation formula, it means :-
take the content in column 'b' row '7'
add it with content in column 'b' row '3'
and show the result in current cell (note that current cell content is actually the formula b7+b3, not the end calculation result)
Hope that helps explaining it. Perhaps it may be good to have a quick read through an excel fundamental book to have a better understanding of the concept of a spreadsheet.
2007-01-30 04:59:48 · answer #3 · answered by dotservant.com-foong 2 · 2⤊ 0⤋
Well compare Excel to the Milton Bradley game Battleship. You have to tell the computer what cell your talking about and what you want to do with it. Enter B4 and format it as what? do you want it to see input as text, numbers, dates, how about having a boarder, what color etc. Excel is a incredible program and fun to Master but you have to explore way beyond why I have to enter B4. Good luck and may the Gates be with you.
2007-01-30 04:47:53 · answer #4 · answered by postmasterfsx 3 · 0⤊ 0⤋
You don't have to type type them this way, use them like you type on a calculator
eg = (12 + 14 + 6)/2
If you get tired of all the typing of long lists of numbers that are constantly changing then it is better to type =(a1+b1+c1)/2 etc
2007-01-30 15:24:26 · answer #5 · answered by unnga 6 · 0⤊ 0⤋
Its referred to as His e book of life Are you in it? Rev 20:15 And whosoever became into no longer got here across written in the e book of life became into forged into the lake of hearth. --------------------------------------... Rev 21:27 And there shall in no clever enter into it any element that defileth, neither [by any potential] worketh abomination, or [maketh] a lie: yet they that are written in the Lamb's e book of life.
2016-12-17 05:52:12 · answer #6 · answered by gelman 3 · 0⤊ 0⤋