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. Find Item's Position
Formulas
Two Variable data table
F4
=MATCH

2. Paste Link
Ctrl + }
Alt + E + S + L
DATE
Ctrl + D

3. Minimum
Alt + D + T
Alt + D + F + A
=MINIMUM
Ctrl + {

4. Track changes
ALT + W + G
ALT + R + G
=CHOOSE
Alt + D + L

5. Displays the variance for the numbers contained in the range of the argument.
=MAXIMUM
=SUMIF
VAR
COUNT

6. Copy value from above cell
SHIFT + CTRL + " (quote)
Alt + =
Alt + T + U + T
NOW

7. Create Data Table
Shift + Ctrl + {
Alt + D + T
ALT + M + V
SHIFT + CTRL + {

8. Record Macros
Alt + W + M + R
Ctrl + }
Alt + E + S + R
Shift + Ctrl + }

9. Move # of Rows/Columns
=OFFSET
=SUMPRODUCT
SQRT
DATE

10. Trace immediate precedents
ALT + M + P
CTRL + ' (apostrophe)
Stimulation Model
=AVERAGE

11. Trace all dependents (indirect)
SHIFT + CTRL + }
VAR
Alt + D + P
Shift + F2

12. Ranges that have a $ character before the column portion of the reference and/or the row portion of the reference.
LN
F5 + Enter
Absolute Ranges
SUM

13. A model used to investigate dynamic behavior
Alt + S + C
SHIFT + CTRL + " (quote)
Alt + W + M + V
Stimulation Model

14. At Least 1 Must Be True
=SUMPRODUCT
Alt + W + M + R
SHIFT + CTRL + " (quote)
=OR

15. Insert AutoSum formula
Alt + D + L
CTRL + [
=MINIMUM
ALT + "="

16. Sum Numbers
DATE
=Sum
Alt + W + M + V
=HLOOKUP

17. Copy Formula Right
One Variable data table
Ctrl + R
PV
=SUMIF

18. Use Relative References
Alt + D + T
FV
Alt + W + M + U
Alt + T + U + A

19. A quantitative representation - or approximation - of a real object or system. Analytical models - statistical models - financial model.
Mathematical Models
=VLOOKUP
F9
STDE

20. Displays the standard deviation of the numbers contained in the range of the argument.
Ctrl + }
Alt + D + L
STDE
F5

21. Delete Comment
Relative Ranges
Alt + T + U + D
Alt + E + A + M
=SUMPRODUCT

22. Advanced Data Filter
Alt + D + F + A
Alt + T + O + F
Ctrl + R
MAX

23. Show all Precedents
Shift + F2
Shift + Ctrl + {
PV
=IF

24. Go to Constants
F5
Ctrl + ~ + =
=Sum
Alt + D + P

25. Displays the number of cells with numerical values in the argument range. For example - =COUNT(D6:D21) displays 16 if all the cells are filled.
Shift + F2
ALT + M + V
SHIFT + CTRL + }
COUNT

26. Find Based on Row
=HLOOKUP
CTRL + ]
Alt + S + C
Ctrl + ~ + =

27. Uses two input cells - but only the value of a single result cell can be displayed. Used to explore the impact of changing two values on a single result
=MAXIMUM
Two Variable data table
CTRL + ]
=

28. Go to Formulas
F5
Ctrl + }
=MINIMUM
=IF

29. Conditional
Shift + Ctrl + {
=COUNT
=IF
CTRL + ~

30. Show Formulas
One Variable data table
Ctrl + ~ + =
Two Variable data table
Alt + D + T

31. Anchor Cell
F4
Alt + W + M + U
=AND
CTRL + ]

32. Copy formula from above cell

33. Recalculate all workbooks
F9
ALT + M + P
Formulas
=COUNT

34. Highlight Dependents
ALT + R + G
Ctrl + }
ALT + W + G
Alt + E + S + L

35. Conditional Sum
Alt + E + S + L
LN
PMT
=SUMIF

36. Highlight Comments
Alt + T + O + F
CTRL + ~
Alt + S + C
CTRL + ' (apostrophe)

37. Sum Adjacent Cells
ALT + M + P
=CHOOSE
Alt + =
CTRL + ]

38. Count Number of Entries
Alt + E + S + R
=COUNT
Alt + E + A + M
=MINIMUM

39. Highlight Precedents
Absolute Ranges
Ctrl + {
=IF
SUM

40. Used for basic calculations - stored by the excel document within specific cells or across different ranges of cells
Alt + W + M + U
Formulas
=OFFSET
=INDEX

41. Find Item
ALT + R + G
Alt + E + A + M
=INDEX
Alt + D + L

42. Absolute Value
=ABS
F9
CTRL + ]
VAR

43. Erase Traces
Alt + T + U + A
AVERAGE
=VLOOKUP
=MATCH

44. Remove tracing arrows
Alt + E + S + R
ALT + W + G
Ctrl + {
ALT + M + A + A

45. Paste Formats & Formulas
=INDEX
Alt + E + S + R
CTRL + ]
ALT + M + V

46. Evaluate formula
F4
One Variable data table
ALT + M + V
STDE

47. Copy Formula Down
Ctrl + D
ALT + "="
=AND
Alt + T + U + T

48. View Macros
SHIFT + CTRL + }
=COUNTIF
=CHOOSE
Alt + W + M + V

49. Displays the date in a variety of formats.
Alt + E + A + M
DATE
Shift + F2
Alt + =

50. Jump Back to Original Cell
Ctrl + D
CTRL + [
F5
F5 + Enter