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






2. Record Macros






3. Select From List






4. Count Number of Entries






5. Trace Dependents






6. Create Data Table






7. Multiply/Sum Range






8. All Must Be True






9. Erase Traces






10. Maximum






11. Refresh Worksheet / Calculate Formulas






12. Show formulas/values






13. At Least 1 Must Be True






14. Enter Formula






15. Delete Comment






16. Go to Constants






17. Go to Formulas






18. Highlight Precedents






19. Absolute Value






20. Displays the date in a variety of formats.






21. Conditional Sum






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






23. Find Based on Row






24. Find Item






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






26. Displays the standard deviation of the numbers contained in the range of the argument.






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






28. Trace Precedents






29. Track changes






30. Copy value from above cell






31. Copy Formula Right






32. Copy Formula Down






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






34. A model used to investigate dynamic behavior






35. Find Item's Position






36. Average






37. Go to precedent cells






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






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






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






41. Zoom to selection






42. Remove tracing arrows






43. Validate Data






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






45. Highlight Dependents






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






47. View Macros






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






49. Minimum






50. Sum Adjacent Cells