SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Microsoft Excel Functions Formulas Shortcuts
Start Test
Study First
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 Based on Column
Alt + W + M + R
Two Variable data table
=VLOOKUP
Formulas
2. Delete Comment
Shift + F2
Alt + E + A + M
F4
Stimulation Model
3. Copy formula from above cell
4. Paste Formats & Formulas
ALT + M + P
Formulas
Alt + E + S + R
Shift + F3
5. 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.
=HLOOKUP
CTRL + ~
MIN
ALT + "="
6. Jump Back to Original Cell
=VLOOKUP
F5 + Enter
Shift + F3
Ctrl + R
7. Create Pivot Table
ALT + M + A + A
Shift + Ctrl + }
Alt + D + P
ALT + M + D
8. Enter Formula
Shift + F3
F5 + Enter
=
ALT + M + V
9. Go to Formulas
PV
Alt + =
=AND
F5
10. Used for basic calculations - stored by the excel document within specific cells or across different ranges of cells
Formulas
Relative Ranges
Mathematical Models
=VLOOKUP
11. Displays the standard deviation of the numbers contained in the range of the argument.
=MATCH
MIN
SQRT
STDE
12. Trace immediate precedents
F5
ALT + R + G
ALT + M + P
Ctrl + }
13. Anchor Cell
Alt + T + U + T
Shift + Ctrl + {
FV
F4
14. Highlight Precedents
ALT + M + V
Ctrl + {
SHIFT + CTRL + {
One Variable data table
15. Sum Adjacent Cells
CTRL + [
Alt + =
ALT + M + P
Alt + T + U + A
16. Displays the variance for the numbers contained in the range of the argument.
VAR
Alt + S + C
Alt + D + P
ALT + "="
17. View Macros
SHIFT + CTRL + {
Alt + T + U + D
Alt + W + M + V
=OR
18. A model used to investigate dynamic behavior
CTRL + ~
Alt + E + A + M
Stimulation Model
NOW
19. Minimum
ALT + M + D
SHIFT + CTRL + }
=ABS
=MINIMUM
20. Maximum
ALT + M + V
=MAXIMUM
Ctrl + R
AVERAGE
21. Absolute Value
Alt + W + M + V
SQRT
=ABS
Alt + D + P
22. 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
F5 + Enter
SHIFT + CTRL + }
SQRT
23. Enter Built-In Formula
Shift + F3
One Variable data table
ALT + R + G
MIN
24. Ranges that have a $ character before the column portion of the reference and/or the row portion of the reference.
Absolute Ranges
Ctrl + ~ + =
F4
Formulas
25. Show Formulas
Ctrl + ~ + =
Relative Ranges
ALT + M + A + A
CTRL + ~
26. Trace Precedents
=COUNTIF
SUM
=IF
Alt + T + U + T
27. Highlight Dependents
Ctrl + }
ALT + W + G
STDE
Alt + D + P
28. Advanced Data Filter
ALT + M + D
Alt + D + F + A
=HLOOKUP
=MAXIMUM
29. Move # of Rows/Columns
Alt + W + M + R
F5
=OFFSET
MAX
30. At Least 1 Must Be True
CTRL + ' (apostrophe)
ALT + W + G
=OR
=SUMPRODUCT
31. Copy Formula Down
Ctrl + D
=VLOOKUP
Stimulation Model
Ctrl + R
32. Go to precedent cells
CTRL + [
=INDEX
Alt + D + F + A
=IF
33. Recalculate all workbooks
F9
SHIFT + CTRL + {
Alt + S + C
Alt + T + U + A
34. Conditional
SHIFT + CTRL + {
=IF
=OFFSET
F5 + Enter
35. A quantitative representation - or approximation - of a real object or system. Analytical models - statistical models - financial model.
SHIFT + CTRL + " (quote)
Mathematical Models
Shift + Ctrl + }
=OR
36. Add/Edit Comment
=MATCH
Ctrl + {
CTRL + ~
Shift + F2
37. Trace all precedents (indirect)
ALT + R + G
=Sum
=HLOOKUP
SHIFT + CTRL + {
38. Conditional Sum
Stimulation Model
PMT
ALT + W + G
=SUMIF
39. Specify one input cell and any number of result cells - often used to explore how altering one value can impact several result cell
Ctrl + }
Alt + T + O + F
SHIFT + CTRL + " (quote)
One Variable data table
40. Displays the future value of a series of equal payments at a fixed rate for a specified number of periods.
SHIFT + CTRL + {
FV
SHIFT + CTRL + " (quote)
Ctrl + ~ + =
41. Record Macros
AVERAGE
CTRL + ' (apostrophe)
Alt + W + M + R
=SUMIF
42. 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.
=SUMPRODUCT
SQRT
=MINIMUM
Alt + W + M + U
43. Trace all dependents (indirect)
=MINIMUM
Alt + E + A + M
SHIFT + CTRL + }
SUM
44. Use Relative References
Alt + W + M + U
=COUNT
Ctrl + D
CTRL + ]
45. Copy value from above cell
=AVERAGE
Two Variable data table
SHIFT + CTRL + " (quote)
ALT + R + G
46. All Must Be True
F4
Alt + W + M + R
=AND
LN
47. Displays the natural logarithm of a number. For example - =LN(50) will display 1.69897.
Shift + Ctrl + {
LN
=MINIMUM
Alt + W + M + V
48. Erase Traces
LN
=COUNT
Alt + T + U + A
SUM
49. Select From List
Alt + =
ALT + R + G
SHIFT + CTRL + }
=CHOOSE
50. Show formulas/values
Alt + T + U + D
CTRL + ~
Absolute Ranges
Stimulation Model