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. Add/Edit Comment
=OR
Alt + T + U + A
Shift + F2
F5

2. Delete Comment
=SUMIF
Alt + E + A + M
Alt + W + M + V
COUNT

3. Record Macros
Alt + E + A + M
=AND
FV
Alt + W + M + R

4. Copy formula from above cell

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183

5. Count Number of Entries
ALT + M + A + A
F5
Alt + S + C
=COUNT

6. Paste Formats & Formulas
=ABS
Alt + E + S + R
=OFFSET
Ctrl + }

7. Average
SHIFT + CTRL + }
=AVERAGE
PV
NOW

8. Highlight Comments
ALT + M + V
Alt + E + S + L
Alt + S + C
Alt + T + O + F

9. Create Data Table
Alt + D + T
ALT + M + V
Ctrl + ~ + =
Alt + W + M + U

10. Select From List
=OR
=CHOOSE
F9
Alt + E + S + R

11. Evaluate formula
Alt + S + C
ALT + M + V
Ctrl + R
=SUMIF

12. Displays the date in a variety of formats.
PV
=CHOOSE
DATE
Stimulation Model

13. Trace immediate precedents
ALT + M + P
Ctrl + }
Alt + T + U + D
Stimulation Model

14. 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.
AVERAGE
ALT + M + V
FV
ALT + M + P

15. Maximum
Ctrl + R
SUM
=MAXIMUM
AVERAGE

16. Conditional
=IF
PMT
Alt + W + M + V
ALT + "="

17. Trace all dependents (indirect)
SQRT
=SUMIF
SHIFT + CTRL + }
Mathematical Models

18. Trace all precedents (indirect)
Alt + D + P
STDE
Two Variable data table
SHIFT + CTRL + {

19. Displays the variance for the numbers contained in the range of the argument.
ALT + W + G
VAR
Alt + T + U + T
MIN

20. Conditional Count
STDE
=COUNTIF
NOW
Alt + T + U + A

21. Ranges that do not have a $ before the column portion of the reference.
COUNT
Relative Ranges
=SUMPRODUCT
Mathematical Models

22. Displays the present value of a series of equal payments at a fixed rate for a specified number of payments.
NOW
Alt + W + M + U
PV
One Variable data table

23. 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.
AVERAGE
SHIFT + CTRL + }
Relative Ranges
SUM

24. Trace Precedents
Alt + T + U + T
=Sum
CTRL + [
Alt + W + M + R

25. Conditional Sum
=SUMIF
Alt + E + S + L
F4
Alt + T + O + F

26. Multiply/Sum Range
=SUMPRODUCT
FV
Alt + D + P
Shift + F2

27. Displays the square root of the number identified in the argument. For example =SQRT(C4) will display the square root of the value in C4.
Alt + D + T
SQRT
ALT + M + D
Ctrl + R

28. Erase Traces
Alt + T + U + A
Alt + W + M + R
PMT
ALT + M + D

29. 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.
SHIFT + CTRL + }
Ctrl + {
MIN
F5

30. Enter Formula
=
Alt + T + U + A
Ctrl + {
=MATCH

31. A model used to investigate dynamic behavior
Alt + W + M + R
Two Variable data table
Ctrl + }
Stimulation Model

32. Go to precedent cells
=MAXIMUM
CTRL + [
ALT + M + D
CTRL + ~

33. Specify one input cell and any number of result cells - often used to explore how altering one value can impact several result cell
Shift + F2
One Variable data table
F5
Alt + =

34. Find Item's Position
Ctrl + R
DATE
=MATCH
=COUNT

35. Displays the natural logarithm of a number. For example - =LN(50) will display 1.69897.
LN
Alt + E + S + L
COUNT
Absolute Ranges

36. Sum Adjacent Cells
Alt + =
Alt + T + U + D
Alt + E + S + L
Alt + E + A + M

37. Copy Formula Down
Shift + F2
=SUMPRODUCT
F4
Ctrl + D

38. Go to Constants
Ctrl + R
SHIFT + CTRL + " (quote)
Ctrl + D
F5

39. Go to Formulas
Ctrl + D
=
ALT + M + P
F5

40. Track changes
ALT + R + G
LN
Alt + W + M + U
Ctrl + }

41. Highlight Precedents
ALT + W + G
=MINIMUM
Ctrl + {
Alt + E + A + M

42. Advanced Data Filter
CTRL + [
ALT + "="
Alt + D + F + A
CTRL + ~

43. At Least 1 Must Be True
=VLOOKUP
Ctrl + D
=OR
=ABS

44. Show all Precedents
Shift + Ctrl + {
Alt + T + U + T
Ctrl + ~ + =
ALT + M + A + A

45. 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
ALT + M + D
Two Variable data table
DATE
PMT

46. Show formulas/values
FV
NOW
CTRL + ~
=MAXIMUM

47. Paste Link
Absolute Ranges
NOW
Alt + E + S + L
=ABS

48. View Macros
VAR
=Sum
Two Variable data table
Alt + W + M + V

49. Ranges that have a $ character before the column portion of the reference and/or the row portion of the reference.
Alt + D + T
Absolute Ranges
F9
Formulas

50. Refresh Worksheet / Calculate Formulas
ALT + R + G
ALT + M + D
F9
Alt + T + O + F