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. A model used to investigate dynamic behavior
Ctrl + R
=VLOOKUP
Stimulation Model
Alt + E + A + M
2. 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
=SUMPRODUCT
Alt + E + S + R
3. Enter Formula
=
=COUNT
=COUNTIF
F9
4. Insert AutoSum formula
=SUMPRODUCT
Ctrl + }
ALT + M + A + A
ALT + "="
5. Displays the standard deviation of the numbers contained in the range of the argument.
STDE
=AVERAGE
Alt + T + U + D
Ctrl + R
6. Trace immediate precedents
NOW
ALT + M + V
=MATCH
ALT + M + P
7. Displays the variance for the numbers contained in the range of the argument.
=
ALT + M + D
F5
VAR
8. Advanced Data Filter
F5 + Enter
=COUNT
Alt + D + F + A
=
9. Absolute Value
=ABS
ALT + W + G
SUM
Alt + S + C
10. All Must Be True
Shift + F2
Alt + T + U + T
ALT + M + A + A
=AND
11. Refresh Worksheet / Calculate Formulas
ALT + M + A + A
Alt + D + T
F9
=CHOOSE
12. Used for basic calculations - stored by the excel document within specific cells or across different ranges of cells
Ctrl + {
MAX
Formulas
SHIFT + CTRL + {
13. Displays the current date or time based on the computer's clock.
PMT
Ctrl + D
NOW
Shift + F3
14. Ranges that do not have a $ before the column portion of the reference.
Alt + E + S + L
Absolute Ranges
=INDEX
Relative Ranges
15. Show all Dependents
One Variable data table
Alt + E + S + R
Shift + Ctrl + }
Alt + W + M + R
16. Conditional
=IF
Stimulation Model
=MINIMUM
Alt + D + T
17. Trace all dependents (indirect)
Alt + T + U + D
Ctrl + }
=AND
SHIFT + CTRL + }
18. 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.
F9
Alt + D + T
Ctrl + }
AVERAGE
19. Copy Formula Down
SHIFT + CTRL + {
Alt + D + T
Ctrl + D
=CHOOSE
20. Enter Built-In Formula
=MATCH
ALT + W + G
AVERAGE
Shift + F3
21. Displays the future value of a series of equal payments at a fixed rate for a specified number of periods.
F5
=MATCH
Ctrl + {
FV
22. Zoom to selection
Ctrl + D
ALT + M + V
ALT + W + G
Alt + T + O + F
23. Specify one input cell and any number of result cells - often used to explore how altering one value can impact several result cell
One Variable data table
Alt + W + M + R
Ctrl + ~ + =
F9
24. Add/Edit Comment
Shift + F2
SHIFT + CTRL + }
NOW
Alt + E + A + M
25. Go to precedent cells
ALT + "="
ALT + M + P
CTRL + [
=AVERAGE
26. 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.
MIN
Ctrl + }
F5
ALT + M + D
27. Delete Comment
LN
Formulas
Alt + E + A + M
AVERAGE
28. Track changes
SHIFT + CTRL + {
MIN
ALT + R + G
Alt + W + M + V
29. Find Item
Shift + F2
=CHOOSE
Alt + D + T
=INDEX
30. Find Based on Row
=HLOOKUP
SHIFT + CTRL + {
SHIFT + CTRL + " (quote)
COUNT
31. At Least 1 Must Be True
F9
=AVERAGE
=OR
=MINIMUM
32. Use Relative References
Shift + Ctrl + {
Alt + W + M + U
Mathematical Models
ALT + "="
33. Sum Adjacent Cells
Shift + F3
Alt + =
=MATCH
Alt + T + U + T
34. Ranges that have a $ character before the column portion of the reference and/or the row portion of the reference.
Ctrl + ~ + =
=SUMIF
Absolute Ranges
Stimulation Model
35. Count Number of Entries
=CHOOSE
=COUNT
MAX
F5 + Enter
36. View Macros
Alt + W + M + V
CTRL + ' (apostrophe)
Alt + S + C
=OFFSET
37. Conditional Sum
=IF
=SUMIF
Alt + T + U + D
Two Variable data table
38. Anchor Cell
=IF
Alt + W + M + U
=MATCH
F4
39. Maximum
Alt + S + C
=MAXIMUM
=AND
One Variable data table
40. Trace all precedents (indirect)
=SUMIF
Alt + W + M + V
=
SHIFT + CTRL + {
41. 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.
Alt + E + S + L
Alt + W + M + V
=IF
SUM
42. Record Macros
=AND
Alt + W + M + R
=Sum
CTRL + ]
43. Create Data Table
ALT + M + D
=MAXIMUM
Alt + D + T
=INDEX
44. Trace Precedents
Shift + F2
ALT + "="
=INDEX
Alt + T + U + T
45. Displays the natural logarithm of a number. For example - =LN(50) will display 1.69897.
LN
=ABS
Alt + T + O + F
SHIFT + CTRL + {
46. Go to Formulas
Ctrl + }
=COUNT
F4
Alt + T + O + F
47. Copy formula from above cell
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
48. Go to Constants
=OR
F5
F4
Alt + E + S + R
49. Highlight Dependents
Ctrl + }
=INDEX
PMT
Shift + Ctrl + {
50. Copy Formula Right
Ctrl + R
MIN
=HLOOKUP
=MINIMUM