SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
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. Validate Data
=CHOOSE
ALT + M + V
Shift + F3
Alt + D + L
2. A model used to investigate dynamic behavior
=MATCH
Ctrl + R
F9
Stimulation Model
3. Go to Constants
One Variable data table
Ctrl + }
Alt + W + M + V
F5
4. Delete Comment
Alt + E + A + M
Shift + Ctrl + }
CTRL + ' (apostrophe)
Alt + D + L
5. Enter Formula
=
PMT
AVERAGE
Ctrl + }
6. Add/Edit Comment
=AND
=MINIMUM
Shift + F2
=COUNT
7. 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
Shift + Ctrl + {
ALT + M + P
=MATCH
Two Variable data table
8. Show formulas/values
CTRL + ~
PV
Alt + D + F + A
=CHOOSE
9. Count Number of Entries
=COUNT
=ABS
Alt + =
PMT
10. Minimum
SHIFT + CTRL + " (quote)
=MINIMUM
PV
=IF
11. Insert AutoSum formula
AVERAGE
Stimulation Model
ALT + "="
DATE
12. Jump Back to Original Cell
F5 + Enter
STDE
CTRL + [
F5
13. Record Macros
=HLOOKUP
=AND
SUM
Alt + W + M + R
14. Displays the payment per period needed to repay a loan at a specified interest rate for a specified number of periods.
Alt + W + M + R
Formulas
PMT
Ctrl + D
15. Ranges that have a $ character before the column portion of the reference and/or the row portion of the reference.
Absolute Ranges
Alt + T + O + F
Formulas
=HLOOKUP
16. Track changes
=AVERAGE
SHIFT + CTRL + }
=Sum
ALT + R + G
17. Conditional Count
=COUNTIF
Absolute Ranges
Ctrl + {
MAX
18. 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 + {
MAX
Alt + E + A + M
COUNT
19. Highlight Dependents
AVERAGE
Ctrl + ~ + =
NOW
Ctrl + }
20. Multiply/Sum Range
=SUMPRODUCT
=ABS
F5
VAR
21. Trace all dependents (indirect)
=HLOOKUP
F4
ALT + M + V
SHIFT + CTRL + }
22. Erase Traces
Absolute Ranges
=ABS
ALT + M + P
Alt + T + U + A
23. View Macros
SHIFT + CTRL + " (quote)
Alt + W + M + V
Relative Ranges
ALT + M + V
24. Displays the current date or time based on the computer's clock.
Alt + T + O + F
CTRL + ~
NOW
Relative Ranges
25. Displays the future value of a series of equal payments at a fixed rate for a specified number of periods.
SQRT
FV
F9
Two Variable data table
26. Trace Precedents
Alt + W + M + V
Shift + Ctrl + }
Alt + T + U + T
F4
27. A quantitative representation - or approximation - of a real object or system. Analytical models - statistical models - financial model.
Mathematical Models
Ctrl + {
Alt + D + L
Alt + D + T
28. Go to Formulas
COUNT
Alt + T + O + F
AVERAGE
CTRL + ' (apostrophe)
29. Create Data Table
Alt + D + T
=IF
Alt + S + C
LN
30. 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.
SUM
AVERAGE
LN
Alt + E + A + M
31. Show all Precedents
Shift + Ctrl + {
Alt + =
Ctrl + D
=CHOOSE
32. All Must Be True
=IF
Shift + Ctrl + {
ALT + M + P
=AND
33. Displays the variance for the numbers contained in the range of the argument.
F4
VAR
Ctrl + D
SHIFT + CTRL + {
34. Displays the present value of a series of equal payments at a fixed rate for a specified number of payments.
CTRL + ~
PV
ALT + M + D
SUM
35. Evaluate formula
ALT + M + V
Shift + Ctrl + {
Stimulation Model
Alt + E + S + R
36. Show all Dependents
F5
Shift + Ctrl + }
SUM
Alt + T + U + T
37. Move # of Rows/Columns
Ctrl + D
=SUMPRODUCT
=COUNT
=OFFSET
38. Trace immediate precedents
ALT + M + A + A
CTRL + ' (apostrophe)
ALT + M + P
=VLOOKUP
39. 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.
F5
ALT + R + G
AVERAGE
MAX
40. At Least 1 Must Be True
=HLOOKUP
=OR
Alt + T + U + T
Alt + =
41. Go to dependent cells
Two Variable data table
Shift + F2
CTRL + ]
STDE
42. Copy value from above cell
SHIFT + CTRL + " (quote)
ALT + M + D
=ABS
F9
43. Select From List
F9
=Sum
=CHOOSE
Two Variable data table
44. Advanced Data Filter
SHIFT + CTRL + {
=MINIMUM
Alt + D + F + A
Ctrl + {
45. Displays the date in a variety of formats.
Alt + D + T
DATE
Ctrl + D
=MINIMUM
46. Trace all precedents (indirect)
SHIFT + CTRL + {
Alt + W + M + R
Mathematical Models
Ctrl + R
47. Ranges that do not have a $ before the column portion of the reference.
CTRL + ~
Alt + D + F + A
SHIFT + CTRL + {
Relative Ranges
48. 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 + F3
MIN
Alt + W + M + V
F5 + Enter
49. Paste Link
Shift + F2
Shift + F3
Alt + D + L
Alt + E + S + L
50. Displays the standard deviation of the numbers contained in the range of the argument.
ALT + M + D
Alt + E + S + R
STDE
F5 + Enter