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 future value of a series of equal payments at a fixed rate for a specified number of periods.






2. Trace Dependents






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






4. Trace immediate precedents






5. Sum Numbers






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






7. Use Relative References






8. Conditional Count






9. Add/Edit Comment






10. Highlight Precedents






11. Highlight Comments






12. Enter Formula






13. Validate Data






14. Refresh Worksheet / Calculate Formulas






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






16. Go to dependent cells






17. Trace Precedents






18. Find Item's Position






19. Show all Precedents






20. At Least 1 Must Be True






21. Displays the date in a variety of formats.






22. Show Formulas






23. Create Data Table






24. Copy Formula Down






25. Insert AutoSum formula






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






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






28. Displays the sum of cells with numerical values in the argument range. For example - =SUM(D6:D21) displays the total added together if all the cells are filled.






29. Evaluate formula






30. Absolute Value






31. Go to Formulas






32. Show all Dependents






33. Remove tracing arrows






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






35. Average






36. Zoom to selection






37. Copy value from above cell






38. Find Based on Row






39. Enter Built-In Formula






40. Track changes






41. Copy Formula Right






42. Erase Traces






43. Select From List






44. Move # of Rows/Columns






45. Conditional Sum






46. Trace immediate dependents






47. Advanced Data Filter






48. Copy formula from above cell


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






50. Paste Link