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. Move # of Rows/Columns






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






3. Use Relative References






4. Erase Traces






5. View Macros






6. Show all Precedents






7. Find Based on Column






8. Displays the present value of a series of equal payments at a fixed rate for a specified number of payments.






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






10. Insert AutoSum formula






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






12. Conditional






13. Copy Formula Down






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.






15. Validate Data






16. Anchor Cell






17. Select From List






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






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






20. Track changes






21. Jump Back to Original Cell






22. Displays the variance for the numbers contained in the range of the argument.






23. Trace immediate precedents






24. Sum Adjacent Cells






25. Highlight Dependents






26. Zoom to selection






27. Advanced Data Filter






28. Trace immediate dependents






29. At Least 1 Must Be True






30. Evaluate formula






31. Find Based on Row






32. Sum Numbers






33. Paste Formats & Formulas






34. Average






35. Conditional Count






36. All Must Be True






37. Trace Dependents






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






39. Count Number of Entries






40. Absolute Value






41. Displays the natural logarithm of a number. For example - =LN(50) will display 1.69897.






42. Highlight Precedents






43. Show formulas/values






44. Find Item






45. A model used to investigate dynamic behavior






46. Copy Formula Right






47. Add/Edit Comment






48. A quantitative representation - or approximation - of a real object or system. Analytical models - statistical models - financial model.






49. Highlight Comments






50. Trace all precedents (indirect)