- Use your mouse to move your insertion point anywhere within the document. …
- Use your arrow keys to move your insertion point up, down, left, or right. …
- Hold the Control key and press the up or down arrow keys to jump up or down a paragraph at a time.
Which of the following keys should be used when you want to move one cell to the right?
| Press This . . . To Move . . . | Arrow keys One cell in the direction of the arrow | Tab One cell to the right | Shift+Tab One cell to the left | Ctrl+any arrow key To the edge of the current data region in a worksheet (the first or last cell that isn't empty) |
|---|
Which of the following keys move the insertion point to the end of data in a cell?
| Question Answer | Which of the following keys moves the insertion point to the end of the data in the cell? END | The _______ button allows you to erase recent cell entries. undo | Excel remembers the last _______ actions you have completed. 100 | Press _____ to select the entire worksheet. CTRL+A |
|---|
When using the SUM function How can you enter the correct range by typing?
| Data | Formula Description Result | =SUM(3, 2) Adds 3 and 2. 5 |
|---|
Which key is used to move the cursor while entering data into the cells?
| Press To | Shift+Enter Complete cell entry and move cell cursor up one row | Ctrl+Enter Complete cell entry in all cells in selected range | Alt+Enter Begin a new line in a cell entry | Tab Complete cell entry and move cell cursor right one column |
|---|
Which key is used to move the insertion point to a new line?
Arrow keys
: You can also use the arrow keys on your keyboard to move the insertion point. The left and right arrow keys will move between adjacent characters on the same line, while the up and down arrows will move between paragraph lines. You can also press Ctrl+Left or Ctrl+Right to quickly move between entire words.
Which key is used to move insertion point to the next cell?
| Key Moves the insertion point … | Ctrl+↑ Up one paragraph | Ctrl+↓ Down one paragraph | Tab One cell to the right of a table | Shift+Tab One cell to the left of a table |
|---|
What is Ctrl page down?
Ctrl+Page Down and Ctrl+Page Up
move the cursor up and down one page at a time
. In Excel, Ctrl+Arrow key performs the same function as the End-Arrow keys.
What is a pie chart with one or more slices offset called?
| Term If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series. Definition C. decrement, increment | Term A Pie chart with one or more slices offset is called a(n) ____. Definition B. exploded pie chart |
|---|
Which key is used in the table to move between different cells?
You can move to each cell that is selected by using Excel hot keys. To move to the next selected cell, press TAB or ENTER. To move to the previous selected cell, press
SHIFT + TAB or SHIFT + ENTER
.
What do you call the cell that do not change?
Absolute Cell Reference
: An absolute cell reference is one that does not change when it is copied. To make a cell reference absolute, you must include a $ before the reference (ex: $C$4). The other type of reference is a Relative Reference..
Which format for a cell name is correct?
The first character
must be a letter, an underscore, or a backslash
. No spaces are allowed in a range name. The range name should not be the same as a cell address. For example, you can't name a range U2 or UB40, but BLINK182 and ABBA are just fine.
What formula would be used to add two cells?
Combine data with the Ampersand symbol (&)
Type = and select the first cell you want to combine. Type & and use quotation marks with a space enclosed. Select the next cell you want to combine and press enter. An example formula might be
=A2&” “&B2.
How does excel align labels in a cell?
top left of a cell top right of a cell bottom left of a cell bottom right of a cell 3
.
How do I move my cursor to another page?
Ctrl + Page Down and Ctrl + Page Up
move the cursor up and down one page at a time.
How do you move the insertion point to the end of a document?
To the beginning or end of a document: Move the insertion point quickly to the beginning of the document by using the command Ctrl + Home. Use the
command Ctrl + End
to quickly move to the end of the document.
