Test your basic knowledge |

Microsoft Excel Functions Formulas Shortcuts

Subject : it-skills

Instructions:

Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can study here.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.

1. Paste Link
Relative Ranges
Alt + E + S + L
=
=OR

2. Jump Back to Original Cell
Alt + W + M + R
Ctrl + ~ + =
F4
F5 + Enter

3. Select From List
Alt + T + O + F
ALT + R + G
=INDEX
=CHOOSE

4. View Macros
Alt + W + M + V
F5
Alt + E + S + R
=COUNT

5. Trace immediate precedents
F9
F5
ALT + M + P
=SUMPRODUCT

6. Displays the average of the range identified in the argument. For example - =AVERAGE(E4:E9) displays the average of the numbers contained in the range E4:E9.
Alt + T + U + D
AVERAGE
=OR
FV

7. Show Formulas
Ctrl + }
Alt + D + P
Alt + W + M + U
Ctrl + ~ + =

8. Displays the minimum or smallest of the range identified in the argument. For example - =MIN(E4:E9) displays the minimum or smallest of the numbers contained in the range E4:E9.
Ctrl + {
DATE
Absolute Ranges
MIN

9. Erase Traces
ALT + M + P
=COUNTIF
Alt + T + U + A
=OFFSET

10. Find Item's Position
=MATCH
Alt + D + P
Stimulation Model
=COUNTIF

11. Displays the variance for the numbers contained in the range of the argument.
Alt + E + A + M
Alt + S + C
=IF
VAR

12. Average
ALT + R + G
Alt + T + U + D
=IF
=AVERAGE

13. Conditional Sum
=SUMIF
NOW
Mathematical Models
Alt + E + S + R

14. Go to Formulas
Alt + D + F + A
Alt + T + O + F
=OR
SUM

15. Displays the maximum or largest of the range identified in the argument. For example - =MAX(E4:E9) displays the maximum or largest of the numbers contained in the range E4:E9.
Two Variable data table
MAX
Alt + W + M + U
VAR

16. Enter Formula
COUNT
=
Alt + T + U + D
Alt + D + F + A

17. Recalculate all workbooks
F9
Stimulation Model
Shift + Ctrl + }
AVERAGE

18. Add/Edit Comment
=VLOOKUP
Ctrl + D
Shift + F2
Alt + T + O + F

19. Conditional
Shift + Ctrl + }
=IF
Ctrl + R
=MINIMUM

20. Advanced Data Filter
Shift + F3
CTRL + ]
Alt + D + F + A
Alt + T + O + F

21. Maximum
=MATCH
=MAXIMUM
DATE
PV

22. Specify one input cell and any number of result cells - often used to explore how altering one value can impact several result cell
=MAXIMUM
PMT
One Variable data table
=HLOOKUP

23. Highlight Precedents
F5 + Enter
SHIFT + CTRL + " (quote)
=INDEX
Ctrl + {

24. Copy value from above cell
SHIFT + CTRL + " (quote)
FV
Alt + D + T
PV

25. Find Item
Ctrl + R
F9
=INDEX
=COUNTIF

26. Copy Formula Right
Shift + F3
Mathematical Models
Ctrl + R
Alt + T + U + A

27. Move # of Rows/Columns
=OFFSET
=AVERAGE
PV
Ctrl + D

28. A model used to investigate dynamic behavior
=HLOOKUP
=
Stimulation Model
Alt + E + S + L

29. Go to Constants
ALT + W + G
F5
=OR
Shift + Ctrl + }

30. Zoom to selection
CTRL + ]
Alt + E + S + L
ALT + R + G
ALT + W + G

31. Show all Dependents
PV
Shift + Ctrl + }
Alt + D + L
STDE

32. Copy Formula Down
Ctrl + D
=OFFSET
Alt + T + O + F
DATE

33. Anchor Cell
SHIFT + CTRL + " (quote)
ALT + M + V
ALT + W + G
F4

34. Displays the future value of a series of equal payments at a fixed rate for a specified number of periods.
Ctrl + D
FV
Absolute Ranges
=MINIMUM

35. Displays the standard deviation of the numbers contained in the range of the argument.
=MINIMUM
Mathematical Models
STDE
AVERAGE

36. Enter Built-In Formula
Shift + F3
Ctrl + ~ + =
COUNT
DATE

37. Refresh Worksheet / Calculate Formulas
F9
=SUMPRODUCT
Alt + D + L
Alt + T + U + T

38. Conditional Count
F4
SHIFT + CTRL + {
=COUNTIF
Alt + W + M + U

39. Insert AutoSum formula
ALT + "="
Alt + D + P
CTRL + ]
Alt + T + U + T

40. Go to precedent cells
ALT + W + G
CTRL + [
=COUNT
Alt + W + M + R

41. A quantitative representation - or approximation - of a real object or system. Analytical models - statistical models - financial model.
One Variable data table
Mathematical Models
Alt + W + M + V
MIN

42. Create Data Table
Alt + D + T
Relative Ranges
F9
=ABS

43. Track changes
ALT + M + P
=SUMPRODUCT
ALT + R + G
ALT + M + A + A

44. Record Macros
Alt + W + M + R
Stimulation Model
Ctrl + }
=OR

45. Show all Precedents
CTRL + ~
Shift + Ctrl + {
Two Variable data table
=Sum

46. Paste Formats & Formulas
=MATCH
Shift + F2
Alt + E + S + R
VAR

47. Trace all dependents (indirect)
One Variable data table
Relative Ranges
SHIFT + CTRL + }
CTRL + ~

48. Find Based on Column
=VLOOKUP
SHIFT + CTRL + " (quote)
Alt + E + S + L
=ABS

49. Displays the sum of cells with numerical values in the argument range. For example - =SUM(D6:D21) displays the total added together if all the cells are filled.
ALT + M + P
SUM
Mathematical Models
Formulas

50. Displays the present value of a series of equal payments at a fixed rate for a specified number of payments.
Alt + E + S + R
CTRL + ' (apostrophe)
PV
=COUNT