Test your basic knowledge |

Microsoft Excel Functions Formulas Shortcuts

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. Displays the natural logarithm of a number. For example - =LN(50) will display 1.69897.






2. Displays the payment per period needed to repay a loan at a specified interest rate for a specified number of periods.






3. Trace all precedents (indirect)






4. Absolute Value






5. A model used to investigate dynamic behavior






6. 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.






7. Specify one input cell and any number of result cells - often used to explore how altering one value can impact several result cell






8. Find Item's Position






9. Trace Dependents






10. Trace Precedents






11. Insert AutoSum formula






12. Track changes






13. Trace immediate dependents






14. Erase Traces






15. Ranges that do not have a $ before the column portion of the reference.






16. Advanced Data Filter






17. Copy Formula Right






18. All Must Be True






19. Move # of Rows/Columns






20. Highlight Precedents






21. Go to dependent cells






22. View Macros






23. Use Relative References






24. Find Based on Column






25. Add/Edit Comment






26. Record Macros






27. Used for basic calculations - stored by the excel document within specific cells or across different ranges of cells






28. Anchor Cell






29. Multiply/Sum Range






30. Displays the date in a variety of formats.






31. Refresh Worksheet / Calculate Formulas






32. Conditional






33. Ranges that have a $ character before the column portion of the reference and/or the row portion of the reference.






34. Copy value from above cell






35. 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.






36. Enter Built-In Formula






37. Copy formula from above cell


38. At Least 1 Must Be True






39. Show all Dependents






40. Displays the current date or time based on the computer's clock.






41. Count Number of Entries






42. Go to Formulas






43. Average






44. Sum Numbers






45. 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






46. Select From List






47. Delete Comment






48. Jump Back to Original Cell






49. Find Based on Row






50. Trace all dependents (indirect)