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. Remove tracing arrows
ALT + W + G
Formulas
LN
ALT + M + A + A
2. Trace all precedents (indirect)
Ctrl + D
SHIFT + CTRL + {
Ctrl + R
Two Variable data table
3. 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.
Two Variable data table
Ctrl + D
MIN
=COUNT
4. Go to Formulas
=ABS
Alt + T + O + F
Alt + W + M + V
Formulas
5. Copy Formula Down
Absolute Ranges
Alt + W + M + R
Ctrl + {
Ctrl + D
6. Move # of Rows/Columns
SHIFT + CTRL + }
MIN
=SUMPRODUCT
=OFFSET
7. Erase Traces
=MAXIMUM
MAX
Alt + T + U + A
CTRL + ' (apostrophe)
8. Ranges that do not have a $ before the column portion of the reference.
Relative Ranges
=VLOOKUP
=MAXIMUM
Ctrl + ~ + =
9. Displays the payment per period needed to repay a loan at a specified interest rate for a specified number of periods.
CTRL + ~
Alt + =
CTRL + ' (apostrophe)
PMT
10. Highlight Precedents
Ctrl + {
LN
=IF
=OR
11. Show formulas/values
CTRL + ~
=MINIMUM
=
Alt + W + M + U
12. Copy value from above cell
=HLOOKUP
SHIFT + CTRL + }
SHIFT + CTRL + " (quote)
Alt + W + M + R
13. Find Item
F5
Shift + Ctrl + }
=INDEX
Alt + D + L
14. 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.
ALT + M + V
=AVERAGE
=COUNT
SQRT
15. Displays the natural logarithm of a number. For example - =LN(50) will display 1.69897.
F9
F5
Formulas
LN
16. Displays the date in a variety of formats.
=MATCH
Alt + T + U + A
=AND
DATE
17. 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.
Alt + T + U + D
LN
AVERAGE
Shift + Ctrl + }
18. Recalculate all workbooks
Alt + T + O + F
=HLOOKUP
F9
=AVERAGE
19. Trace all dependents (indirect)
SHIFT + CTRL + }
=OR
Alt + D + T
ALT + "="
20. 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
Stimulation Model
F5
Two Variable data table
CTRL + [
21. Highlight Dependents
Shift + F3
FV
Alt + T + U + A
Ctrl + }
22. Find Based on Column
=VLOOKUP
=MINIMUM
Alt + E + S + L
AVERAGE
23. Conditional Count
F5
=COUNTIF
Alt + E + A + M
Relative Ranges
24. Displays the standard deviation of the numbers contained in the range of the argument.
STDE
=SUMIF
=Sum
PV
25. All Must Be True
=AND
Alt + E + A + M
Shift + Ctrl + {
Mathematical Models
26. Enter Built-In Formula
Ctrl + ~ + =
Formulas
F9
Shift + F3
27. Highlight Comments
Formulas
Alt + S + C
=HLOOKUP
=COUNTIF
28. At Least 1 Must Be True
=OR
=AVERAGE
STDE
AVERAGE
29. Paste Link
Alt + W + M + V
Alt + E + S + L
F9
Ctrl + D
30. Absolute Value
CTRL + ~
=INDEX
=COUNTIF
=ABS
31. Evaluate formula
ALT + M + D
Ctrl + ~ + =
ALT + M + V
Alt + T + U + T
32. Sum Adjacent Cells
Alt + E + A + M
F4
Alt + =
Alt + T + O + F
33. Go to precedent cells
Alt + W + M + U
F9
CTRL + [
ALT + R + G
34. Average
=AVERAGE
NOW
Alt + T + U + D
=INDEX
35. Select From List
LN
Relative Ranges
Alt + T + U + A
=CHOOSE
36. Maximum
=Sum
COUNT
=MAXIMUM
Ctrl + }
37. Displays the current date or time based on the computer's clock.
=HLOOKUP
SUM
Alt + T + O + F
NOW
38. Multiply/Sum Range
One Variable data table
F9
SHIFT + CTRL + {
=SUMPRODUCT
39. Create Data Table
PMT
DATE
Alt + D + T
SHIFT + CTRL + {
40. Trace immediate precedents
=AVERAGE
ALT + M + P
AVERAGE
MAX
41. Add/Edit Comment
Ctrl + D
Shift + F2
MAX
ALT + M + A + A
42. Use Relative References
F5 + Enter
=IF
ALT + R + G
Alt + W + M + U
43. Conditional
Alt + W + M + V
Shift + Ctrl + }
=SUMIF
=IF
44. Count Number of Entries
Shift + F3
=COUNT
Alt + =
Alt + D + P
45. Refresh Worksheet / Calculate Formulas
Alt + T + U + A
NOW
=IF
F9
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.
COUNT
Ctrl + R
Alt + D + L
ALT + R + G
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. Find Item's Position
=MATCH
ALT + M + A + A
F4
SHIFT + CTRL + }
49. Ranges that have a $ character before the column portion of the reference and/or the row portion of the reference.
=SUMPRODUCT
Ctrl + {
Ctrl + ~ + =
Absolute Ranges
50. Delete Comment
Alt + E + A + M
CTRL + ' (apostrophe)
Shift + F2
One Variable data table