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. Move # of Rows/Columns
Alt + D + T
ALT + M + V
=OFFSET
SHIFT + CTRL + " (quote)

2. Maximum
=CHOOSE
=MAXIMUM
=MATCH
ALT + M + A + A

3. Displays the payment per period needed to repay a loan at a specified interest rate for a specified number of periods.
F5
PMT
ALT + M + A + A
MAX

4. Enter Formula
Alt + T + U + D
=
=COUNTIF
One Variable data table

5. Recalculate all workbooks
Alt + W + M + V
Alt + W + M + R
F9
Relative Ranges

6. 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.
SUM
=MATCH
Alt + E + A + M
ALT + M + P

7. Average
Relative Ranges
=AVERAGE
One Variable data table
=SUMPRODUCT

8. Highlight Precedents
STDE
Alt + D + T
Formulas
Ctrl + {

9. Find Based on Row
=HLOOKUP
ALT + M + P
=AVERAGE
SHIFT + CTRL + {

10. Jump Back to Original Cell
ALT + M + V
Ctrl + R
F5 + Enter
Ctrl + {

11. Find Item's Position
Alt + E + S + L
=MATCH
Alt + D + T
Ctrl + {

12. Show Formulas
SUM
Alt + D + P
=INDEX
Ctrl + ~ + =

13. 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.
Relative Ranges
Ctrl + R
SQRT
=ABS

14. Paste Formats & Formulas
Alt + D + T
=MATCH
Alt + E + S + R
=AND

15. Delete Comment
Alt + E + S + L
Formulas
Alt + E + A + M
CTRL + ]

16. Create Pivot Table
Alt + T + U + D
Alt + T + O + F
Alt + D + P
Ctrl + }

17. Evaluate formula
Two Variable data table
Formulas
ALT + M + V
ALT + R + G

18. Copy formula from above cell

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

19. Go to Constants
F5
=IF
SHIFT + CTRL + {
Alt + D + L

20. 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.
MAX
ALT + M + V
Alt + D + L
=COUNTIF

21. Paste Link
F9
Alt + E + S + L
ALT + "="
MAX

22. Find Item
=INDEX
F9
=HLOOKUP
SUM

23. Highlight Dependents
Alt + D + T
Alt + E + S + L
Ctrl + }
Alt + T + U + D

24. Used for basic calculations - stored by the excel document within specific cells or across different ranges of cells
Alt + D + F + A
=MINIMUM
=
Formulas

25. Sum Numbers
Ctrl + {
=AVERAGE
=Sum
VAR

26. Use Relative References
Formulas
=MATCH
Alt + W + M + U
ALT + M + D

27. A model used to investigate dynamic behavior
SHIFT + CTRL + }
Formulas
Relative Ranges
Stimulation Model

28. Show all Dependents
Alt + W + M + V
F5
Shift + Ctrl + }
=

29. Conditional
SHIFT + CTRL + }
=IF
Alt + W + M + U
Stimulation Model

30. Anchor Cell
F4
=OFFSET
=OR
ALT + W + G

31. Remove tracing arrows
ALT + M + A + A
Alt + S + C
Shift + Ctrl + {
CTRL + ' (apostrophe)

32. At Least 1 Must Be True
=SUMIF
Alt + D + F + A
=OR
SHIFT + CTRL + {

33. A quantitative representation - or approximation - of a real object or system. Analytical models - statistical models - financial model.
=COUNTIF
=VLOOKUP
Mathematical Models
One Variable data table

34. Ranges that have a $ character before the column portion of the reference and/or the row portion of the reference.
Alt + D + P
=SUMPRODUCT
Absolute Ranges
Alt + T + U + D

35. Zoom to selection
SHIFT + CTRL + {
PV
Shift + Ctrl + }
ALT + W + G

36. Displays the date in a variety of formats.
MIN
Two Variable data table
DATE
Alt + E + A + M

37. Count Number of Entries
CTRL + [
=COUNT
Alt + T + U + T
Shift + Ctrl + }

38. Show formulas/values
CTRL + ~
F5 + Enter
Ctrl + {
Ctrl + R

39. Find Based on Column
Stimulation Model
=VLOOKUP
=
Alt + T + O + F

40. Insert AutoSum formula
Alt + E + S + R
ALT + M + D
ALT + "="
Shift + Ctrl + }

41. Trace Precedents
CTRL + [
Alt + T + U + T
MAX
Alt + D + T

42. Displays the variance for the numbers contained in the range of the argument.
DATE
=MATCH
VAR
AVERAGE

43. Displays the standard deviation of the numbers contained in the range of the argument.
SQRT
=SUMIF
STDE
SHIFT + CTRL + " (quote)

44. 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
F5
Alt + D + P
Two Variable data table
Alt + T + O + F

45. Ranges that do not have a $ before the column portion of the reference.
Alt + W + M + U
=OR
Alt + S + C
Relative Ranges

46. 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 + CTRL + }
COUNT
=AVERAGE
Mathematical Models

47. Erase Traces
SUM
CTRL + ' (apostrophe)
ALT + M + P
Alt + T + U + A

48. Go to precedent cells
Alt + D + T
LN
Shift + F3
CTRL + [

49. Copy Formula Down
SHIFT + CTRL + " (quote)
Shift + F3
=CHOOSE
Ctrl + D

50. Enter Built-In Formula
ALT + M + A + A
Formulas
Shift + F2
Shift + F3