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. Find Item's Position






2. Paste Link






3. Minimum






4. Track changes






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






6. Copy value from above cell






7. Create Data Table






8. Record Macros






9. Move # of Rows/Columns






10. Trace immediate precedents






11. Trace all dependents (indirect)






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






13. A model used to investigate dynamic behavior






14. At Least 1 Must Be True






15. Insert AutoSum formula






16. Sum Numbers






17. Copy Formula Right






18. Use Relative References






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






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






21. Delete Comment






22. Advanced Data Filter






23. Show all Precedents






24. Go to Constants






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






26. Find Based on Row






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






28. Go to Formulas






29. Conditional






30. Show Formulas






31. Anchor Cell






32. Copy formula from above cell


33. Recalculate all workbooks






34. Highlight Dependents






35. Conditional Sum






36. Highlight Comments






37. Sum Adjacent Cells






38. Count Number of Entries






39. Highlight Precedents






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






41. Find Item






42. Absolute Value






43. Erase Traces






44. Remove tracing arrows






45. Paste Formats & Formulas






46. Evaluate formula






47. Copy Formula Down






48. View Macros






49. Displays the date in a variety of formats.






50. Jump Back to Original Cell