Excel

Question 1

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

Answer 1

Alt+=

Question 2

What does F2 do in Excel?

Answer 2

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.

Question 3

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

Answer 3

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

Question 4

What does Ctrl+F3 do in Excel?

Answer 4

Opens the Name Manager dialog box.

Question 5

What does Shift+F3 do in Excel?

Answer 5

Opens the Insert Function dialog box.

Question 6

What does F5 do in Excel?

Answer 6

Opens the Go To dialog box.

Question 7

What does Shift+F5 do in Excel?

Answer 7

Opens the Find and Replace dialog box.

Question 8

What does Ctrl+1 do in Excel?

Answer 8

Opens the Format Cells dialog box.

Question 9

What does F4 do in Excel?

Answer 9

Repeats the last action.

Question 10

What does F7 do in Excel?

Answer 10

Spell checks the selected text or document.

Question 11

What does F11 do in Excel?

Answer 11

Creats a chart from the selected data.

Question 12

What does Ctrl+; do in Excel?

Answer 12

Enters the current date.

Question 13

What does Ctrl+Shift+; do in Excel?

Answer 13

Enters the current time.

Question 14

What does Ctrl+S do in Excel?

Answer 14

Save the open worksheet.