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. Paste Formats & Formulas
Alt + T + U + A
SQRT
Alt + S + C
Alt + E + S + R
2. Conditional Count
=COUNTIF
SHIFT + CTRL + " (quote)
DATE
F9
3. Select From List
F5 + Enter
Alt + T + U + D
=CHOOSE
=MATCH
4. Displays the payment per period needed to repay a loan at a specified interest rate for a specified number of periods.
SUM
=SUMPRODUCT
PMT
=OFFSET
5. Go to precedent cells
=
=COUNTIF
CTRL + [
F9
6. Conditional Sum
CTRL + ~
=SUMIF
ALT + M + D
Alt + T + O + F
7. Minimum
=MINIMUM
=COUNTIF
=VLOOKUP
Absolute Ranges
8. Paste Link
ALT + R + G
Alt + E + S + L
LN
=AVERAGE
9. Go to Constants
SHIFT + CTRL + }
F5
Alt + E + S + R
=
10. Displays the variance for the numbers contained in the range of the argument.
Relative Ranges
PV
VAR
CTRL + ' (apostrophe)
11. At Least 1 Must Be True
=OR
Alt + D + T
Absolute Ranges
Shift + Ctrl + }
12. Recalculate all workbooks
F5 + Enter
=VLOOKUP
F9
ALT + M + V
13. Trace all dependents (indirect)
DATE
Alt + W + M + V
SHIFT + CTRL + }
=SUMPRODUCT
14. Show all Precedents
ALT + M + V
Shift + F2
CTRL + ' (apostrophe)
Shift + Ctrl + {
15. Displays the date in a variety of formats.
Relative Ranges
MIN
CTRL + [
DATE
16. Count Number of Entries
SUM
=COUNT
=AND
Alt + =
17. Trace Precedents
F5
Alt + T + U + T
ALT + R + G
SHIFT + CTRL + {
18. Sum Adjacent Cells
Alt + D + F + A
=ABS
Absolute Ranges
Alt + =
19. A model used to investigate dynamic behavior
ALT + W + G
FV
=Sum
Stimulation Model
20. Erase Traces
Alt + T + U + A
Alt + E + S + L
Alt + W + M + U
ALT + "="
21. Trace immediate dependents
=COUNT
F5 + Enter
Alt + T + O + F
ALT + M + D
22. Displays the natural logarithm of a number. For example - =LN(50) will display 1.69897.
COUNT
=
=OR
LN
23. Average
Alt + W + M + R
Alt + T + U + A
Shift + Ctrl + {
=AVERAGE
24. Insert AutoSum formula
ALT + "="
VAR
CTRL + [
F5
25. Anchor Cell
Alt + E + S + L
F4
SUM
STDE
26. Validate Data
AVERAGE
Alt + D + L
CTRL + ~
=MINIMUM
27. Record Macros
F9
Alt + W + M + R
ALT + R + G
Shift + F2
28. 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
FV
F5
Two Variable data table
SHIFT + CTRL + }
29. Trace all precedents (indirect)
F5
Alt + E + S + L
SHIFT + CTRL + {
Alt + T + U + D
30. Conditional
=IF
SQRT
Ctrl + {
Alt + D + P
31. Show all Dependents
Alt + E + S + L
DATE
MAX
Shift + Ctrl + }
32. Copy formula from above cell
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
33. Show formulas/values
F4
=SUMIF
MAX
CTRL + ~
34. Create Data Table
Alt + D + T
CTRL + ~
LN
SHIFT + CTRL + }
35. 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
DATE
Relative Ranges
Alt + E + S + L
36. Advanced Data Filter
COUNT
Ctrl + D
Alt + D + F + A
AVERAGE
37. Used for basic calculations - stored by the excel document within specific cells or across different ranges of cells
SUM
ALT + "="
MIN
Formulas
38. Go to Formulas
=IF
Shift + Ctrl + }
F5
One Variable data table
39. All Must Be True
=IF
Shift + F2
SHIFT + CTRL + }
=AND
40. Remove tracing arrows
F5 + Enter
ALT + M + A + A
=IF
MIN
41. Go to dependent cells
Alt + T + U + D
CTRL + ]
=Sum
CTRL + ~
42. Trace immediate precedents
One Variable data table
ALT + M + P
Alt + E + A + M
F9
43. Specify one input cell and any number of result cells - often used to explore how altering one value can impact several result cell
=MATCH
One Variable data table
Ctrl + R
=OR
44. Trace Dependents
Alt + T + U + D
CTRL + ' (apostrophe)
PMT
Mathematical Models
45. Displays the standard deviation of the numbers contained in the range of the argument.
STDE
CTRL + [
ALT + M + V
=COUNT
46. Find Item
SQRT
ALT + M + A + A
Ctrl + R
=INDEX
47. Copy Formula Down
=MAXIMUM
=MATCH
Ctrl + D
ALT + M + D
48. Zoom to selection
ALT + W + G
ALT + M + D
Shift + Ctrl + {
Alt + W + M + R
49. Displays the current date or time based on the computer's clock.
Ctrl + }
SUM
CTRL + ~
NOW
50. Track changes
ALT + R + G
Alt + D + T
FV
Alt + E + A + M