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. Erase Traces






2. Trace Precedents






3. Minimum






4. Conditional Sum






5. All Must Be True






6. Conditional Count






7. Refresh Worksheet / Calculate Formulas






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






9. Zoom to selection






10. Sum Numbers






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






12. Select From List






13. Absolute Value






14. Anchor Cell






15. Show all Precedents






16. Go to dependent cells






17. Remove tracing arrows






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






19. Trace Dependents






20. Copy Formula Right






21. Sum Adjacent Cells






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






23. Find Item






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






25. Multiply/Sum Range






26. Validate Data






27. Displays the date in a variety of formats.






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






29. A model used to investigate dynamic behavior






30. Show formulas/values






31. Find Based on Row






32. Copy Formula Down






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






34. Maximum






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






36. Go to Constants






37. Move # of Rows/Columns






38. Highlight Precedents






39. Trace all dependents (indirect)






40. Show Formulas






41. Find Item's Position






42. Show all Dependents






43. Go to Formulas






44. Delete Comment






45. Highlight Comments






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






47. Trace immediate dependents






48. Evaluate formula






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






50. Create Data Table