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. Trace immediate precedents






2. Find Based on Row






3. Trace immediate dependents






4. Absolute Value






5. View Macros






6. Select From List






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






8. All Must Be True






9. Move # of Rows/Columns






10. Refresh Worksheet / Calculate Formulas






11. Sum Numbers






12. Highlight Precedents






13. A model used to investigate dynamic behavior






14. Show Formulas






15. Highlight Comments






16. At Least 1 Must Be True






17. Evaluate formula






18. Go to precedent cells






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






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






21. Zoom to selection






22. Go to Constants






23. Go to dependent cells






24. Sum Adjacent Cells






25. Maximum






26. Minimum






27. Erase Traces






28. Paste Formats & Formulas






29. Remove tracing arrows






30. Find Based on Column






31. Trace all dependents (indirect)






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






33. Average






34. Jump Back to Original Cell






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






36. Find Item's Position






37. Advanced Data Filter






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






39. Copy value from above cell






40. Insert AutoSum formula






41. Copy formula from above cell


42. Create Data Table






43. Record Macros






44. Multiply/Sum Range






45. Anchor Cell






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






47. Conditional Sum






48. Displays the date in a variety of formats.






49. Validate Data






50. Show all Dependents