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. Show all Dependents
F4
Shift + Ctrl + }
Ctrl + {
CTRL + ~
2. Show Formulas
SHIFT + CTRL + }
Ctrl + ~ + =
=COUNTIF
Alt + D + T
3. Average
=AVERAGE
SQRT
Alt + T + U + A
Shift + F2
4. Zoom to selection
DATE
ALT + W + G
Ctrl + {
=COUNTIF
5. Conditional Count
CTRL + ~
AVERAGE
=COUNTIF
Stimulation Model
6. Jump Back to Original Cell
DATE
Alt + D + T
SHIFT + CTRL + {
F5 + Enter
7. Go to Formulas
=SUMPRODUCT
Two Variable data table
SHIFT + CTRL + " (quote)
Alt + T + O + F
8. Displays the date in a variety of formats.
=MATCH
Shift + F3
ALT + M + P
DATE
9. 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
=COUNT
ALT + W + G
Two Variable data table
PV
10. Go to Constants
F5
Shift + Ctrl + }
Shift + Ctrl + {
AVERAGE
11. 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.
=IF
STDE
AVERAGE
F9
12. Record Macros
Alt + W + M + R
ALT + M + P
AVERAGE
Alt + D + P
13. Copy value from above cell
Stimulation Model
Alt + W + M + R
SHIFT + CTRL + " (quote)
Alt + S + C
14. Paste Link
DATE
ALT + M + D
ALT + W + G
Alt + E + S + L
15. Delete Comment
SHIFT + CTRL + {
FV
Alt + E + A + M
Alt + D + T
16. Validate Data
=MATCH
Alt + D + L
Alt + E + A + M
Alt + W + M + R
17. Displays the natural logarithm of a number. For example - =LN(50) will display 1.69897.
LN
COUNT
Alt + E + S + L
SHIFT + CTRL + {
18. Specify one input cell and any number of result cells - often used to explore how altering one value can impact several result cell
=AND
SQRT
=OR
One Variable data table
19. Find Item
Alt + T + U + A
Alt + D + T
CTRL + ]
=INDEX
20. View Macros
=HLOOKUP
=SUMIF
Alt + W + M + V
SHIFT + CTRL + " (quote)
21. Highlight Dependents
CTRL + ' (apostrophe)
=MINIMUM
Two Variable data table
Ctrl + }
22. Used for basic calculations - stored by the excel document within specific cells or across different ranges of cells
Alt + E + S + L
=OFFSET
Formulas
=INDEX
23. Trace immediate dependents
ALT + M + D
=MINIMUM
LN
Mathematical Models
24. Maximum
=MAXIMUM
Alt + T + O + F
F5 + Enter
Alt + E + S + L
25. 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
MAX
=SUMIF
=
26. A quantitative representation - or approximation - of a real object or system. Analytical models - statistical models - financial model.
Mathematical Models
Alt + E + A + M
CTRL + [
ALT + W + G
27. Highlight Precedents
COUNT
CTRL + ]
Alt + W + M + V
Ctrl + {
28. Go to dependent cells
MAX
Relative Ranges
CTRL + ]
SHIFT + CTRL + }
29. Create Data Table
Alt + D + T
=AND
Alt + E + A + M
STDE
30. Erase Traces
Stimulation Model
=IF
CTRL + ]
Alt + T + U + A
31. Ranges that do not have a $ before the column portion of the reference.
Alt + T + U + D
Two Variable data table
Relative Ranges
SHIFT + CTRL + " (quote)
32. All Must Be True
F5 + Enter
Alt + E + A + M
=AND
Alt + D + P
33. Enter Built-In Formula
Two Variable data table
Shift + F3
Ctrl + ~ + =
F4
34. Create Pivot Table
Alt + D + P
SQRT
=OFFSET
Alt + E + A + M
35. Copy Formula Right
Ctrl + R
Ctrl + }
=VLOOKUP
ALT + R + G
36. Minimum
ALT + R + G
F5 + Enter
Absolute Ranges
=MINIMUM
37. Enter Formula
Alt + W + M + U
=COUNTIF
=HLOOKUP
=
38. Go to Formulas
AVERAGE
STDE
Alt + T + U + D
F5
39. Conditional Sum
F9
CTRL + [
=SUMIF
STDE
40. Evaluate formula
Alt + W + M + V
ALT + M + V
F4
=OFFSET
41. Track changes
NOW
DATE
ALT + R + G
PMT
42. Find Based on Row
Stimulation Model
=HLOOKUP
Mathematical Models
ALT + "="
43. A model used to investigate dynamic behavior
Alt + =
STDE
PMT
Stimulation Model
44. Copy Formula Down
=VLOOKUP
F4
Ctrl + D
Alt + E + S + R
45. 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.
F5
=Sum
MIN
=INDEX
46. Recalculate all workbooks
ALT + M + D
NOW
=IF
F9
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. Trace immediate precedents
=HLOOKUP
=INDEX
VAR
ALT + M + P
49. Use Relative References
Alt + W + M + U
Ctrl + }
Ctrl + {
=AND
50. Highlight Comments
F9
Alt + S + C
Alt + D + T
PV