0
You can do it in lots of ways. For example, you can use the arrow keys to do it, use the mouse to do it or even use the Goto function to do it, by pressing the F5 key and entering in the cell you want to go to. Using Goto would be a long winded way of moving just one cell, so the keyboard or mouse options are better.
What else can I help you with?
Which one of the following operations will move you from cell B7 to B8 of a worksheet?
You would use Cut and Paste to do that. There are many ways of doing that. You could also drag it.
Is there any shortcut function to match positive amount with Negative amount in Excel 2007?
=-b7 where b7 is an example cell reference. The result will be the negative of whatever is in b7.
What is the intersection of a row and column in a table called in word?
A cell as in B7.
How do you minus the number of one cell using the number in the other cell as the percentage you'd like to minus in Excel?
Say your initial value is in cell A7 and the cell you want to use as a percentage was in B7, then you could use the following formula: =A7-A7*B7/100 So, for example, if you had 150 in A7 and 30 in B7, then it would take 30% of 150 from itself, giving you 105 as a result.
What is the sum of the values stored in cells b4 b5 b6 and b7?
Use following function in any other cell to calculate sum: =sum(b4:b7)
What is the formula used to reference information on the first Excel spreadsheet to the second Excel spreadsheet?
To refer to another cell on another sheet, you precede the cell with the sheet name and an exclamation mark. So if you were on Sheet2 and wanted to refer to cell C6 on Sheet3 and add it to cell B7 on Sheet1 the formula would be: =Sheet3!C6 + Sheet1!B7
How can you use the IF function and absolute reference to calculate the amount to be placed in a cell?
There are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:=IF(B7
When formula A3 plus A4 in cell A5 copied to cell B7 What is the answere?
The formula will become: =B5+B6 What the actual total it shows will be, will depend on what is in B5 and B6.
How do you get to b10 from b7?
by sleeping with b7 so much that it's so happy it has to go up.
What size engine does the 2012 BMW Alpina-B7 have?
The 2012 BMW Alpina-B7 has a V8 engine.
How many valves does the 2012 BMW Alpina-B7 have?
The 2012 BMW Alpina-B7 has 32 valves.
What size engine does the 2008 BMW Alpina-B7 have?
The 2008 BMW Alpina-B7 has a V8 engine.
