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. Validate Data






2. A model used to investigate dynamic behavior






3. Go to Constants






4. Delete Comment






5. Enter Formula






6. Add/Edit Comment






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






8. Show formulas/values






9. Count Number of Entries






10. Minimum






11. Insert AutoSum formula






12. Jump Back to Original Cell






13. Record Macros






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






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






16. Track changes






17. Conditional Count






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






19. Highlight Dependents






20. Multiply/Sum Range






21. Trace all dependents (indirect)






22. Erase Traces






23. View Macros






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






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






26. Trace Precedents






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






28. Go to Formulas






29. Create Data Table






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






31. Show all Precedents






32. All Must Be True






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






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






35. Evaluate formula






36. Show all Dependents






37. Move # of Rows/Columns






38. Trace immediate precedents






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






40. At Least 1 Must Be True






41. Go to dependent cells






42. Copy value from above cell






43. Select From List






44. Advanced Data Filter






45. Displays the date in a variety of formats.






46. Trace all precedents (indirect)






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






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






49. Paste Link






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