Quiz › Shortcuts › Time savers

Time savers: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

Column A has full names. You type the first name in B1, then press Ctrl + E in B2. What does Excel do?
- A. Deletes column B
- B. Makes a chart
- C. Sorts the names
- D. Fills the first names down
Show the answer
D — Fills the first names down. Ctrl + E is Flash Fill. It copies your pattern down the column.
You are in A1. The data runs down to A500 with no gaps. You press Ctrl + Down arrow. Where do you land?
- A. A500
- B. A2
- C. A100
- D. A1048576
Show the answer
A — A500. Ctrl + an arrow jumps to the edge of the data.
You press Ctrl + ` (the key under Esc). What changes?
- A. The sheet is printed
- B. The file is saved
- C. All cells turn bold
- D. Cells show their formulas
Show the answer
D — Cells show their formulas. Ctrl + ` shows formulas in place of results. Press again to go back.
You are typing in a cell and press Alt + Enter. What happens?
- A. The file is saved
- B. A new line in the same cell
- C. The cell is cleared
- D. You move to the next cell
Show the answer
B — A new line in the same cell. Alt + Enter breaks the line and keeps you in the cell.
A1 has 1234.5. You select it and press Ctrl + Shift + 1. What does it show?
- A. 1,234.50
- B. 1234.5
- C. 1234
- D. 123450%
Show the answer
A — 1,234.50. Ctrl + Shift + 1 applies the Number format: a comma and 2 decimals.