0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
Do you need to select the cells for the chart before using the chart wizard?
No. While running the Chart Wizard, you can select the cells you want.
What keys on the key board select adjacent cells?
The Ctrl key can do it, when used in conjunction with the mouse. You can also use the F8 key to select cells, and using combinations with shift, you can select non-adjacent cells.
What allows cells to be selected?
Cells can be selected by the mouse or the keyboard. Pressing and hold the left mouse button and dragging across cells will select them. Pressing and holding the shift hey and then using the cursor keys can select cells. The F8 key can also be used to select cells.
What are the disadvantages of the auto sum function in Excel?
It does not always select the cells you want to sum when you use it. This can lead to mistakes being made if the person using it does not select the correct cells. The user has to select the correct cells themselves if the Autosum doesn't do it. Sometimes it is as quick to type in the cells you want.
How do pigs rid their body of toxin?
they get rid of the toxin using their liver and their kidneys
Does Point mode allow you to select cells for use in a formula by using the keyboard?
Yes it does. Cells can be selected with the mouse or the keyboard by using the arrow keys to move to the cells you want to use in the formula.
What key do you use to select noadjacent cells?
The simplest way is to press and hold the Ctrl key and then click on the other cells you want. As long as you keep the Ctrl key held, any cells you select will remain selected. It can also be done using the F8 key to turn the selection and extend modes on and off, but that is far more awkward, so just use the Ctrl key and the mouse.
When using a function to perform a calculation how would you select the range of numbers to use?
Drag the cursor through the set of cells.
How can you select nonadjacent ranges of cells?
Select your first range in the normal way. Then press and hold the Ctrl key and with the mouse select the next area. The original area will remain selected. If you do this you can select cells that are non adjacent. A less common way to do it is using the F8 key. Put the cursor in the first cell. Press the F8 key. To select several adjacent cells use the arrow keys. To stop the selection press F8 again. To stop the selection but retain the selected cell and move to a non-adjacent cell to select again, press and hold the Shift key and then press F8. Go to the cell you want using the cursor keys and then press the F8 key when you want to start selecting again. You could also just drag the mouse over different areas of the worksheet having pressed Shift and F8, in the same way as you can with the Ctrl key. Within a formula cells that are not adjacent can be specified by listing them with a comma in between them. Ranges are specified with colons. It is possible to use both: =SUM(A1:A20,B16,C45,D11:D13)
How do you select cells that are not next to each other in Excel?
Keep hold of the Ctrl key when you are selecting separate cells with the mouse. You can also press the F8 key and using the cursor keys select some cells. The press Shift-F8 and it will stop selecting and then using the cursor keys you can move to another part of the worksheet and press F8 again and start selecting with the cursor keys and the initial selection will remain selected. Press F8 again to stop completely.
What key to used in Excel for a range of cells?
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
Is it true that you can select cells using the keyboarding by pressing and holding the control key and using the arrow keys to extend the selection?
No it is not true. You would use the Shift key, not the Ctrl key to do it.
