Excel Flashcards Preview

IT > Excel > Flashcards

Flashcards in Excel Deck (14):
1

What is the keyboard shortcut to enter =SUM() in the current cell?

Alt+=

2

What does F2 do in Excel?

F2 alone: edit the active cell and put the insertion point at the end of its contents.
Or, if editing is turned off for the cell, move the insertion point into the formula bar.
If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference.
Shift+F2: adds or edits a cell comment.

3

What does Alt+Enter do when entering text into a cell in Excel?

While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell.

4

What does Ctrl+F3 do in Excel?

Opens the Name Manager dialog box.

5

What does Shift+F3 do in Excel?

Opens the Insert Function dialog box.

6

What does F5 do in Excel?

Opens the Go To dialog box.

7

What does Shift+F5 do in Excel?

Opens the Find and Replace dialog box.

8

What does Ctrl+1 do in Excel?

Opens the Format Cells dialog box.

9

What does F4 do in Excel?

Repeats the last action.

10

What does F7 do in Excel?

Spell checks the selected text or document.

11

What does F11 do in Excel?

Creats a chart from the selected data.

12

What does Ctrl+; do in Excel?

Enters the current date.

13

What does Ctrl+Shift+; do in Excel?

Enters the current time.

14

What does Ctrl+S do in Excel?

Save the open worksheet.