Quiz › Shortcuts › What does the key do?

What does the key do?: Excel Quiz

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

A1:A10 has numbers. You click A11 and press Alt + =. What does Excel write?
- A. =A1:A10
- B. =COUNT(A1:A10)
- C. =AVERAGE(A1:A10)
- D. =SUM(A1:A10)
Show the answer
D — =SUM(A1:A10). Alt + = is AutoSum. Excel writes the SUM formula for you.
A1 has 100. You select A2 and press Ctrl + D. What does A2 show?
- A. 100
- B. Nothing
- C. 101
- D. 0
Show the answer
A — 100. Ctrl + D copies the cell above. It does not add 1.
You typed =A1 in a formula and press F4 once. What does it become?
- A. =A$1
- B. =A1$
- C. =$A$1
- D. =$A1
Show the answer
C — =$A$1. One press of F4 locks the column and the row: $A$1.
You press Ctrl + ; in an empty cell. What does Excel type?
- A. Today's date
- B. A semicolon
- C. The time now
- D. Yesterday's date
Show the answer
A — Today's date. Ctrl + ; types today's date. Ctrl + Shift + ; types the time.
A1 has 5. You select A1 and B1 together and press Ctrl + R. What does B1 show?
- A. 5
- B. 0
- C. 6
- D. Nothing
Show the answer
A — 5. Ctrl + R copies the cell on the left into the cells on the right.